ERROR during upgrade from v3.0.3.8 to v3.0.3.9 => SyntaxError: Unexpected token '<', "Warning"... is not valid JSON pa

• Ubuntu 22.04.03/LTS
• Apache 2.4.52/FPM
• PHP 7.4.33
• MySQL v8.0.37
• Opencart v3.0.3.8
• default theme

SyntaxError: Unexpected token '<', "Warning"... is not valid JSON parsererror Warning: mysqli::query(): (23000/1062): Duplicate entry '28-3-1' for key 'oc_product_attribute.PRIMARY' in /var/www/html/opencart3038/public_html/system/library/db/mysqli.php on line 25{"error":"Error Code(0): Error: Duplicate entry '28-3-1' for key 'oc_product_attribute.PRIMARY'
Error No: 1062
ALTER TABLE `oc_product_attribute` ADD PRIMARY KEY(`product_id`,`attribute_id`,`language_id`) in \/var\/www\/html\/opencart3038\/public_html\/system\/library\/db\/mysqli.php on line 49"}

• The error mentions a duplicate key.
• I like to stress that I started out with a correct populated database w.o. errors.
• So any errors reported must be caused by the upgrade procedure, especially since the error mentions a SYNTAX error.

skidrow wrote: ↑

Sat Jun 15, 2024 6:04 am

using:

• Ubuntu 22.04.03/LTS
• Apache 2.4.52/FPM
• PHP 7.4.33
• MySQL v8.0.37
• Opencart v3.0.3.8
• default theme

During upgrade from v3.0.3.8 to v3.0.3.9 I am getting error:

Code: Select all

SyntaxError: Unexpected token '<', "Warning"... is not valid JSON parsererror Warning: mysqli::query(): (23000/1062): Duplicate entry '28-3-1' for key 'oc_product_attribute.PRIMARY' in /var/www/html/opencart3038/public_html/system/library/db/mysqli.php on line 25{"error":"Error Code(0): Error: Duplicate entry '28-3-1' for key 'oc_product_attribute.PRIMARY'
Error No: 1062
ALTER TABLE `oc_product_attribute` ADD PRIMARY KEY(`product_id`,`attribute_id`,`language_id`) in \/var\/www\/html\/opencart3038\/public_html\/system\/library\/db\/mysqli.php on line 49"}

See screenshot #1 below.

I followed the steps in the included UPGRADE markdown file.
As the error shown concerns a SYNTAX error, how to proceed now?

PLEASE NOTE:

• The error mentions a duplicate key.
• I like to stress that I started out with a correct populated database w.o. errors.
• So any errors reported must be caused by the upgrade procedure, especially since the error mentions a SYNTAX error.

Jaesin wrote: ↑

Thu Jun 20, 2024 12:48 pm

Dont mean to derail this, but I cam here for a similar concern.... in my 3038 to 3039 upgrade...
My error is the following while trying to upgrade....

SyntaxError: Unexpected token '<', "Warning"... is not valid JSON parsererror Warning: mysqli::query(): (HY000/1283): Column 'description' cannot be part of FULLTEXT index in /var/www/vhosts/mydomain.com/httpdocs/system/library/db/mysqli.php on line 25{"error":"Error Code(0): Error: Column 'description' cannot be part of FULLTEXT index
Error No: 1283
ALTER TABLE `oc_product_description` CHANGE `name` `name` VARCHAR(255) NOT NULL AFTER `language_id` in \/var\/www\/vhosts\/mydomain.com\/httpdocs\/system\/library\/db\/mysqli.php on line 49"}


Should I start a different question thread?

Thx