PDA

View Full Version : sql error on arcade quick editor


AlchemyX
03-15-2006, 02:22 PM
I can't update costs per game, it says that the collumn "cost" is unknown in the field list...

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
03-15-2006, 02:34 PM
Have u upgraded to the latest verison v3 Arcade? It requires v1.0.5 or higher.

-CMX

AlchemyX
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
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