cancel
Showing results for 
Search instead for 
Did you mean: 

Magento Upgrade Not Working

Magento Upgrade Not Working

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..

 

Thanks!

 

Eleanor

3 REPLIES

Re: Magento Upgrade Not Working

@eleanor_qeeple

 

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;
Found something useful, please give "Kudos" or "Accept as Solution" for Token of Appreciation.
Free Magento Extensions : https://magecomp.com/free-magento-extensions.html

Re: Magento Upgrade Not Working

Thanks for the reply

Re: Magento Upgrade Not Working

@eleanor_qeeple

 

Smiley Happy

Let me know if it fixed your issue or not.

Found something useful, please give "Kudos" or "Accept as Solution" for Token of Appreciation.
Free Magento Extensions : https://magecomp.com/free-magento-extensions.html