Author Topic: NO_AUTO_VALUE_ON_ZERO error on import  (Read 71 times)

0 Members and 1 Guest are viewing this topic.

Offline
***
NO_AUTO_VALUE_ON_ZERO error on import
« 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

Offline
*****
Re: NO_AUTO_VALUE_ON_ZERO error on import
« Reply #1 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.

Offline
***
Re: NO_AUTO_VALUE_ON_ZERO error on import
« Reply #2 on: May 23, 2019, 11:35:32 AM »
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.