Restore error: NO AUTO VALUE ON ZERO";

Forum Moderators: open

Message Too Old, No Replies

Restore error: NO AUTO VALUE ON ZERO";

zulubanshee

2:15 am on Aug 25, 2008 (gmt 0)

I am moving servers and the new server has an older version of mysql (3.23.58). The one im using is 4.1.22. Specifically, I'm getting this error:

#1064 - You have an error in your SQL syntax near 'SQL_MODE="NO_AUTO_VALUE_ON_ZERO"' at line 2

I'm not sure it has to do with different versions, but some of the other troubleshooting stuff suggests it might. It could also be a phpmyadmin version problem.

Does anyone have any ideas about this?

coopster

3:12 pm on Aug 25, 2008 (gmt 0)

Yes, this has to do with different versions.

NO_AUTO_VALUE_ON_ZERO [dev.mysql.com]

was added in MySQL 4.1.1 so your 3.23 server is choking on the syntax. We once had a related discussion in PHP that may shed some more light on what it does if you are not certain: Autoincrementing id fields from a post form [webmasterworld.com]

zulubanshee

2:12 am on Aug 26, 2008 (gmt 0)

Thank you that is very helpful.

zulubanshee

5:35 am on Aug 26, 2008 (gmt 0)

Well silly me, I didn't realize you could export the database as 3.23. I got it up on a test server. But now I wonder what the effect will be if i add records. Onward through the fog.