Forwarded to devs Migration gives an SQL error

[tkalfaoglu]

Username: tkalfaoglu

TITLE

Migration gives an SQL error

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

CENTOS 8 Obsidian

PROBLEM DESCRIPTION

While migrating I see these errors for one hosting:

Failed to copy content of database 'cebiopendoc'
Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code.
command: mysql --defaults-file=/usr/local/psa/var/modules/panel-migrator/sessions/20210709111654/target-server/my_localhost_cebiopendoc.cnf -h localhost -P 3306 -uadmina cebiopendoc < /usr/local/psa/var/modules/panel-migrator/sessions/20210709111654/target-server/db-dumps/cebiopendoc.sql
exit code: 1
stdout:
stderr: ERROR 1064 (42000) at line 25: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 5

STEPS TO REPRODUCE

migate this domain from another server running centos 7 obsidian

ACTUAL RESULT

gives this error

EXPECTED RESULT

smooth sailing

ANY ADDITIONAL INFORMATION



YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[tkalfaoglu]

Here is the offending table:

DROP TABLE IF EXISTS `odm_access_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `odm_access_log` (
`file_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`action` enum() NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

I suspect it has to do with the MariaDB configuration/version..

 

[IgorG]

Most likely the source server is running another version of MariaDB or MySQL and the target server is running Mariadb 10.3.
Developers recommend upgrading MySQL/MariaDB on the source server as described here  How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux? and then migrating the entire domain again.

 

[tkalfaoglu]

Thank you both servers were updated regularly and religiously throughout their lives..

 

[tkalfaoglu]

I just checked and the source server's yum update did not have anything new..