Help! I’m trying to restore my database but I keep getting this error:
Database error: Duplicate entry ‘119287’ for key 1 (1062)
Invalid query: INSERT INTO cscart_stat_requests (req_id, timestamp, url, title, https, loadtime, sess_id, request_type) VALUES (‘119287’, ‘1314116586’, ‘/index.php?dispatch=products.view&product_id=3822’, ‘PC Cables :: Joystick Cables :: 10 foot Mac Monitor/Joystick Extension Cable DB15 Male to Female (2 Rows of Pins) - Phantom Cables: Premium Audio/Video Cable Solutions’, ‘N’, ‘3’, ‘3415’, ‘3002’)
Backtrace:
File: /var/www/vhosts/phantomcables.com/httpdocs/core/fn.database.php
Line: 310
Function: db_error
File: /var/www/vhosts/phantomcables.com/httpdocs/core/fn.database.php
Line: 791
Function: db_query
File: /var/www/vhosts/phantomcables.com/httpdocs/controllers/admin/database.php
Line: 133
Function: db_import_sql_file
File: /var/www/vhosts/phantomcables.com/httpdocs/core/fn.control.php
Line: 567
Function: include
File: /var/www/vhosts/phantomcables.com/httpdocs/core/fn.control.php
Line: 422
Function: fn_run_controller
File: /var/www/vhosts/phantomcables.com/httpdocs/adminphantom.php
Line: 28
Function: fn_dispatch
Solved. I just deleted the product first then ran the restore option again. it worked this time.
whew! sorry for the post, just panicked and went looking for the best source of cs-cart info i knew.