Quote:
Originally Posted by elmirage001
A huge thank you to the X-CART team for this upgrade! Paul
Upgrade from 4.7.9 went smoothly except some duplicate entry tries for GB States.
SQL query : INSERT INTO xcart_states (`state`, `code`, `country_code`) VALUES ("York", "YOR", "GB") Error code : 1062 Description : Duplicate entry 'GB-YOR' for key 'code' Request URI: /admin/patch.php
|
I changed "INSERT INTO" TO "REPLACE INTO" and pasted patch. I also received the error shown below. I checked phpMyAdmin and it was already done. Maybe from doing the GDPR mod a while back?
SQL query : ALTER TABLE xcart_customers
DROP INDEX usertype,
ADD INDEX AccessLogUpdateCustomersEU_GDPR (usertype, status)
Error code : 1091
Description : Can't DROP 'usertype'; check that column/key exists
Patch is now complete with version showing is 4.7.10