Hi Magento Support
we are currently revamping a site and we just bought a new magento theme. Tried to upload all the files and also upgraded magento from 1.5 to 1.9. While upgrading the magento the data from previous theme was lost and got an SQL error message which is : #1062 - Duplicate entry '677963-150' for key 'UNQ_BY_VISITOR'
Anyone here has this issue? Need help..
Please run this query and try to upgrade again.
SET foreign_key_checks = 0; TRUNCATE dataflow_batch_export; TRUNCATE dataflow_batch_import; TRUNCATE log_customer; TRUNCATE log_quote; TRUNCATE log_summary; TRUNCATE log_summary_type; TRUNCATE log_url; TRUNCATE log_url_info; TRUNCATE log_visitor; TRUNCATE log_visitor_info; TRUNCATE log_visitor_online; TRUNCATE report_viewed_product_index; TRUNCATE report_compared_product_index; TRUNCATE report_event; TRUNCATE index_event; TRUNCATE catalog_compare_item; SET foreign_key_checks = 1;
Let me know if it fixed your issue or not.