Log in

View Full Version : SQL Error

MetalEd
03-13-2007, 03:34 AM
I'm running on vBulletin version 3.6.5 and whenever I try to open a game I get this error
mySQL query error: INSERT INTO games_session (gname, gameid, gtitle, mname, mid, randgid, randgid2) VALUES ('haloFlashv2Th', '35', 'The name of the game I'm trying to play', 'My username', '1', '1', '1')

mySQL error: Unknown column 'randgid' in 'field list'
mySQL error code:
Date: Monday 12th 2007f March 2007 09:32:44 PM
I've tried to repair my database but that didn't do anything. I've tried reinstalling quite a few times and it still doesn't work.
MetalEd
03-18-2007, 05:29 PM
Can anyone help me out with this?
WhaLberg
03-18-2007, 05:39 PM
There is no column named "randgid".
MetalEd
03-18-2007, 05:54 PM
So what do I do to fix it? Like I said, I've tried reinstalling it a few times and nothing works.
WhaLberg
03-18-2007, 06:05 PM
Can you check your table to see if there's a column named "randgid" or not via phpMyAdmin?
MetalEd
03-18-2007, 06:13 PM
No, there isn't a column randgid in games_session
MrZeropage
03-20-2007, 07:38 PM
upload the installer.php from the archive and run it like this:
installer.php?do=override
after this is done, remove installer.php and everything should work fine :)
MetalEd
03-20-2007, 09:09 PM
Yep, it worked. Thanks!
MrZeropage
03-20-2007, 09:27 PM
you're welcome :)