MySQL Update failed

[Murat333]

Hello, after the last update i recieve this error, please help me how to fix it;

 

[JakeSully]

It clearly says in yellow box you will have to execute query that is above manually to your mysql server, mostlikely your mysql server is not version 8.0 which is required on v3.20.x

 

[Murat333]

How should I do it please let me know.

 

[kissnavel]

After manually updating the database tables from the MyIsam table to the Innodb table,run SQL query to update the database successfully.

 

[Murat333]

Could you please explain in detail.

 

[McAtze]

Could you please explain in detail.

Did you host your website or how did you serve your chevereto?

 

[Murat333]

Did you host your website or how did you serve your chevereto?

Dear McAtze;

SSD Cloud VDS using server
Operation System : CentOS Linux 7.9.2009 (Core) - Plesk Obsidian v18.0.36_build1800210604.22 os_CentOS 7
MySQL : 10.2.39-MariaDB
PHP : 7.3.28-1centos.7.210430.1502

Is that enough information?

 

[JakeSully]

Dear McAtze;

SSD Cloud VDS using server
Operation System : CentOS Linux 7.9.2009 (Core) - Plesk Obsidian v18.0.36_build1800210604.22 os_CentOS 7
MySQL : 10.2.39-MariaDB
PHP : 7.3.28-1centos.7.210430.1502

Is that enough information?

Use php 7.4, since 7.3 is deperecated

 

[McAtze]

MySQL : 10.2.39-MariaDB

This could be updated to 10.3/4/5

PHP : 7.3.28-1centos.7.210430.1502

As @JakeSully said, min php7.4

Plesk Obsidian v18.0.36

If you use Plesk, then you can use PhpMyAdmin to execute these queries.

 

[Rodolfo]

Must read - Re: MySQL issues V3.20

Hey there, If you have one of these: Error SQL query: Copy CREATE TABLE `chv_assets` ( `asset_id` bigint(32) NOT NULL AUTO_INCREMENT, `asset_key` varchar(255) NOT NULL, `asset_md5` varchar(32) NOT NULL, `asset_filename` varchar(255) NOT NULL, `asset_file_path` varchar(255) NOT NULL...

chevereto.com

 

[imghut]

I finally decided to update to 3.20 and had same problem, this helped me

How to convert all tables from MyISAM into InnoDB?

I know I can issue an alter table individually to change the table storage from MyISAM to InnoDB. I am wondering if there is a way to quickly change all of them to InnoDB?

stackoverflow.com

This part specifically,

Run this SQL statement (in the MySQL client, phpMyAdmin, or wherever) to retrieve all the MyISAM tables in your database.
Replace value of the name_of_your_db variable with your database name.

SET @DATABASE_NAME = 'name_of_your_db';

SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

Then, copy the output and run as a new SQL query.