Print Page - Update to 3.8.9.10602 lot of SQL errors

Title: Update to 3.8.9.10602 lot of SQL errors
Post by: diri on March 09, 2022, 08:10:08 AM

Many errrors like this one related to _virtuemart_countries:

vmError: vmTable store updateObject Duplicate entry '162' for key 'country_num_code' UPDATE `xyz_virtuemart_countries` SET `virtuemart_worldzone_id`='1',`country_name`='Christmas Island-1',`country_3_code`='CXR',`country_2_code`='CX',`country_num_code`='162',`ordering`='0',`published`='1',`created_on`='2022-03-09 07:01:44',`created_by`='62',`modified_on`='2022-03-09 07:01:44',`modified_by`='62' WHERE `virtuemart_country_id` = '45'

Didn't count them but, I'm pretty shure there's room for improvement.

cu, diri

Title: Re: Update to 3.8.9.10602 lot of SQL errors
Post by: GJC Web Design on March 09, 2022, 11:22:03 AM

this is being worked on now - try 3.8.9.10603

Title: Re: Update to 3.8.9.10602 lot of SQL errors
Post by: Milbo on March 09, 2022, 11:34:36 AM

Thank you, GJC. Diri please read here first
https://forum.virtuemart.net/index.php?topic=147985.msg527920#msg527920

VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: diri on March 09, 2022, 08:10:08 AM