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 3

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;
Was my answer helpful? You can accept it as a solution.
175+ Professional Extensions for M1 & M2
Need a developer?Just visit Contact Us Now

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.

Was my answer helpful? You can accept it as a solution.
175+ Professional Extensions for M1 & M2
Need a developer?Just visit Contact Us Now