Print Page - NO_AUTO_VALUE_ON_ZERO error on import

Title: NO_AUTO_VALUE_ON_ZERO error on import
Post by: pixelpadre on May 12, 2019, 03:49:46 PM

Im importing database from old cwp to new cwp. I get an error but import appears to be successful. Can I ignore the error?

Mysql error:
phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"
#1064 - 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 'phpMyAdmin SQL Dump

Title: Re: NO_AUTO_VALUE_ON_ZERO error on import
Post by: Igor S. on May 22, 2019, 05:58:23 PM

Hi, try to check the SQL dump or re-create it.
Or try to import the database via SSH console.

Title: Re: NO_AUTO_VALUE_ON_ZERO error on import
Post by: pixelpadre on May 23, 2019, 11:35:32 AM

Quote from: Igor S. on May 22, 2019, 05:58:23 PM
Hi, try to check the SQL dump or re-create it.
Or try to import the database via SSH console.

Yes, as I posted in a different thread, I had to use shell to export. phpmyadmin export gives a bad unuseable sql file.

Control Web Panel

WebPanel => MySQL => Topic started by: pixelpadre on May 12, 2019, 03:49:46 PM