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

[jiffy]

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.

'g_raters' => None,
'license' => None,

[jamesk]

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.

[jiffy]

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.

[MrZeropage]

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

[jiffy]

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.