Author Topic: NO_AUTO_VALUE_ON_ZERO error on import  (Read 326 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.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

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.