• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Forwarded to devs Migration gives an SQL error

tkalfaoglu

Silver Pleskian
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
 
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..
 
Back
Top