sql errors when adding games and submitting scores

[Madmp3zz]

I just wiped out my board and started from scratch.
I've done so many updates and hacks I figured it was about time to redo the whole box.

It's been a while since I installed vbulletin so I'm a little confused with this error.

The board is up and running along with the arcade.
When I try and add new games using tar files I am getting this error with every game I try, just the name is different..
I'm assuming it's a permission error.

mySQL query error: INSERT INTO games_list (gname,gwords,gtitle,bgcolor,gwidth,gheight,active ,object,gkeys,gcat,added) VALUES ('100mRunning',' Run 100M as fast as you can, your best time will be submitted. ','100m Running','FFFFFF','600','450','1','4',' Run 100M as fast as you can. ','1','1139080076')

mySQL error: Field 'g_raters' doesn't have a default value
mySQL error code:
Date: Saturday 04th 2006f February 2006 02:07:56 PM

These are all good tar files, I had them saved from the original board.

When submitting scores I get thise error..
mySQL query error: INSERT INTO games_scores
(mid,gid,name,score,ip,timespent,datescored) VALUES
('1','4','PAWSOX','3242','68.56.143.32','229','113 9080830')

mySQL error: Field 'comment' doesn't have a default value
mySQL error code: 0
Date: Saturday 04th 2006f February 2006 02:20:30 PMDid I miss something on the original setup?

TIA

[cyberhypnotic]

That's the game 100m, not the arcade. I'll let you know that some games don't work quite as well as some others.

Some games don't post scores, some games aren't even playable. It's all a matter of where you get the games from also. Some game files aren't written correctly and such.

Where did you get the 100m game from?

[Madmp3zz]

It's all 1100+ games that I get the error on...
I just posted that one as an example.

The error for the posting scores is from the standard Tetris that installs with the arcade.

I've used all these games 1100+ games on my board prior to reformatting and starting from scratch.

[Madmp3zz]

Is this a common issue or do I need to do a complete reinstall?

[cyberhypnotic]

I would try that out. Make sure you uninstall completely before reinstalling it.

[Madmp3zz]

WTF....
Just did a complete reinstall.. same errors..

I think it has to do with the mysql install...
Not sure what I did wrong, going to try and uninstall and reinstall mysql.

Anyone have a tutorial to setup mysql?
I remember I found one on the web somewhere and it worked perfect for my original install months ago..

[jiffy]

I'm having this same problem after moving to a new server. Did you figure it out?