Update to 3.0.xx Opencart, SQL Error on upgrade - Where to start?
Posted: Thu Jun 20, 2024 12:53 pm
Receive dthis error on an update form 3.0.3.8 (using PHP 7.4, and trying to update to 3.0.x.x (3.0.4.0) from the repository.
The following error is received, can someone tell me where to start looking or get a general idea of concern?
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"}
The following error is received, can someone tell me where to start looking or get a general idea of concern?
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"}