Log in

View Full Version : Database error


hunter22375
06-25-2008, 11:03 PM
Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE casino_blackjack_dealt SET hand = 2, bet = WHERE cardnum = AND playerid = 6;

MySQL Error : You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'WHERE
cardnum = AND playerid = 6' at line 1
Error Number : 1064
Request Date : Tuesday, June 24th 2008 @ 03:39:44 PM
Error Date : Tuesday, June 24th 2008 @ 03:39:44 PM
Script : http://thesourcecheck.com/forum/casino.php?do=blackjack&ajax=1
Referrer : http://thesourcecheck.com/forum/casino.php?do=blackjack
IP Address :
Username :
Classname : vB_Database
MySQL Version :

Can someone tell me whats going on with this?

org knopper
06-26-2008, 12:56 AM
<font color="Navy">
open ur config.php n check whether the DB username n PW are same as the ones u gave for the mysql database n den try running site !</font>

Dismounted
06-26-2008, 06:56 AM
This had nothing to do with config.php - it has already connected to the server successfully.

A casino modification is causing this error, due to a malformed SQL statement.

Opserty
06-26-2008, 07:16 AM
If you have questions regarding modifications please post in the modification thread from which you downloaded it as the author or other users will be the ones best placed to assist you.

casino.php is not a default vBulletin file.