The Arcive of vBulletin Modifications Site.

sql error on arcade quick editor · **Released**: 03-15-2006

I can't update costs per game, it says that the collumn "cost" is unknown in the field list...

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

					UPDATE vb_arcade_games
					SET
						title = '2D Knockout',cost = '5'
					WHERE gameid = '118';

MySQL Error  : Unknown column 'cost' in 'field list'
Error Number : 1054
Date         : Wednesday, March 15th 2006 @ 10:14:49 AM
Script       : http://www.rpgfreeze.com/forums/admincp/vbplaza.php
Referrer     : http://www.rpgfreeze.com/forums/admincp/vbplaza.php?do=v3arcadecosts
IP Address   : 68.191.139.128
Username     : Little AlchemyX
Classname    : vb_database

CMX_CMGSCCC · #2 03-15-2006, 02:34 PM

Have u upgraded to the latest verison v3 Arcade? It requires v1.0.5 or higher.

-CMX

AlchemyX · #3 03-15-2006, 02:37 PM

ah, no. I have 1.0.2, I didn't recieve any upgrade e-mails about the arcade.

Thank you for both the solution and the extremely quick reply. :-)

CMX_CMGSCCC · #4 03-15-2006, 03:02 PM

The next vbPlaza 1.5.3 will check to be sure the arcade is installed and it will check to see if the version number is high enough.

If its not installed or its not a high enough version it will display a message with a link to v3arcade.com as well!

Thanx for supporting vbPlaza!

EDIT: New version 1.5.3 is out!

-CMX