MySQL error when installing new games: Field 'g_raters' doesn't have a default value
 

I recently have moved servers and had a couple of errors when I tried to use the arcade. I thought I had fixed the problem but I went to install some games today and got a MySQL error: Field 'g_raters' doesn't have a default value. How can I fix this? I thought maybe allowing a null value would fix it so I tried that using the MySQL admin program but it gave me some error about "can't DROP 'PRIMARY'; check that column key exists." when I tried applying the change on unchecking "Not Null". I don't get it, any help would be great. As it sits right now I've got hundreds of games that I can't install.

Edit: Well I think I fixed it. In the file admincp>arcade.php I added this code under the "tar install" section. Just after the "cost" value. I'm not sure why others haven't had this same problem.

is you host using mysql 5.x.x series instead of mysql 4.x.x series? the default for mysql 5 is "strict" while mysql 4 isn't. a LOT of php code "breaks" when run against mysql 5. including, in my experience, this hack.

Is there a way to change 5 to not run "strict"? I looked through most of the settings in MySQLadmin but didn't see it.

Thanks, fixed that in several needed places for v2.5.8+ :)

Is there something I should do or just leave it as is until the next release? By the way thanks for such a great hack.