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"}
As I said in the other topic. Something has changed you database tables and added FULLTEXT to the description column of the oc_product_description table. OpenCart does not use FULLTEXT in any tables.
There are no major changes to the database between 3.0.3.8 and 3.0.3.9, so you are probably safe skipping the upgrade script. For the latest 3.0.x.x branch the only change to structure is https://github.com/opencart/opencart/co ... e0274570f9.
There are no major changes to the database between 3.0.3.8 and 3.0.3.9, so you are probably safe skipping the upgrade script. For the latest 3.0.x.x branch the only change to structure is https://github.com/opencart/opencart/co ... e0274570f9.
Who is online
Users browsing this forum: No registered users and 7 guests