Log in

View Full Version : Database error


wi11ie1950
09-17-2006, 03:57 AM
When i try to install a Zipped game i get...

mySQL query error: INSERT INTO games_list (gname,gwords,gtitle,bgcolor,gwidth,gheight,active ,object,gkeys,gcat,cost,jackpot,jackpot_type,added ,tourney_user,gtime) VALUES ('pinguslap','Tired of beating penguins to death? Try throwing snowballs at them!','Pingu Slap','000000','500','308','1','Tired of beating penguins to death? Try throwing snowballs at them!','','1','0','0','-1','1158468771','1','0')

mySQL error: Unknown column 'tourney_user' in 'field list'
mySQL error code:
Date: Sunday 17th of September 2006 05:52:51 AM

Running VB3.6.1

Tar games install without a problem.

The Arcade installed flawlessly :)

Ok i fixed it :):) They work now.
For those having the same problem. Open admincp/arcade.php with an editor and search for "tourney_user" change it to "tourney_use" and save the file.

Black Tiger
09-17-2006, 10:39 PM
Can anybody confirm this? Because in the datastore table I can see "tourney_user" as well as "tourney_use".
It would not be correct if the tourney_use part was for the use of tourney's, and the tourney_user data would get in there too.

Ah see it now.. table games list.. your right, thanks mate!

MrZeropage
09-21-2006, 08:17 AM
Yes, sorry for that typo, it is fixed in next version v2.5.7+ :)