View Single Post
  #11  
Old 10-20-2018, 02:01 PM
 
elmirage001 elmirage001 is offline
 

X-Wizard
  
Join Date: Apr 2007
Posts: 1,964
 

Default Re: X-Cart 4.7.10 released

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
__________________
X-Cart GoldPlus v4.7.12 | reBOOT (reDUX) Template v4.7.12.9 | Always The Best
Reply With Quote