Hi,

As part of my upgrade to zen-cart 1.3.8a I followed the recommended procedure of creating a new database and importing info from my 1.3.7 database into it for testing purposes. Know that I've successfully upgraded, I'd like to transfer this information back to my original database. I need to import information from my test DB to the original one because I've used the test one for a couple weeks now and just noticed there's extra updated information in it that I need to keep. When I try to import the data into the original DB I get the following error in phpMySQL:

Error

SQL query:
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;


MySQL said:
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'

My host provider is still using the same version of MySQL and PHP so I chose "NONE" for the compatibility mode within phpMySQL. Is this where the problem is coming from? Do I need to choose something else?

Thanks,