Forum Moderators: open

Message Too Old, No Replies

#1231 - Variable 'sql mode' can't be set to the value of 'NULL'

         

jshpik1

10:07 am on Nov 13, 2007 (gmt 0)

10+ Year Member



Hello,

I'm trying to import a database for a forum using phpmyadmin. I'm getting the following error:


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'

Not sure how to fix this... I'm guessing I should replace


@OLD_SQL_MODE

With something else?

jshpik1

3:59 pm on Nov 13, 2007 (gmt 0)

10+ Year Member



I read online that I should try to replace

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

with

/*!40101 SET SQL_MODE="" */;

but alas it did not work, I got an error saying "" in not valid or something.