kylek
03-10-2006, 02:37 AM
I have had the new vbPlaza running for two days with no problems except for now, cant even access my site as this sql error pops up. Tried to get into admincp to temp. turn store off but cant. Help!!
Database error in vBulletin 3.5.4:
Invalid SQL:
UPDATE vb3_user
SET
3000.00000 = 3000.00000 * 1.02,
vbp_nextbankinterest = 1142050989
WHERE userid = '1'
AND vbp_receivespoints = '1';
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 '3000.00000 = 3000.00000 * 1.02,
vbp_nextbankinterest = 11
Error Number : 1064
Date : Thursday, March 9th 2006 @ 11:23:11 PM
Script : http://www.okanaganwatch.ca/
Referrer :
IP Address : xxxx.xxx.xxxxx.x..x
Username : xxxx
Classname : vb_database
Update - went into my database and changed the time setting for the vbp_nextbankinterest to 0, saved and at least I can now see and get into my site.
Database error in vBulletin 3.5.4:
Invalid SQL:
UPDATE vb3_user
SET
3000.00000 = 3000.00000 * 1.02,
vbp_nextbankinterest = 1142050989
WHERE userid = '1'
AND vbp_receivespoints = '1';
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 '3000.00000 = 3000.00000 * 1.02,
vbp_nextbankinterest = 11
Error Number : 1064
Date : Thursday, March 9th 2006 @ 11:23:11 PM
Script : http://www.okanaganwatch.ca/
Referrer :
IP Address : xxxx.xxx.xxxxx.x..x
Username : xxxx
Classname : vb_database
Update - went into my database and changed the time setting for the vbp_nextbankinterest to 0, saved and at least I can now see and get into my site.