Weird MySQL Error

[CheeSie]

DB Error..

I receive quite a bit of this..

Database error in vBulletin 4.0.5:

Invalid SQL:
UPDATE user AS vbcreditst_1 SET vbcreditst_1.credits =  WHERE vbcreditst_1.userid = 41277;

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 vbcreditst_1.userid = 41277' at line 1
Error Number  : 1064
Request Date  : Friday, August 6th 2010 @ 01:03:51 PM
Error Date    : Friday, August 6th 2010 @ 01:03:52 PM
Script        : login.php?do=login
Referrer      : showthread.php?148566-Mystery-Pic-Answer-(Round-930)
IP Address    : (removed)
Username      : (removed)
Classname     : vB_Database
MySQL Version :

Why and how to fix? XD

 

[robdog]

UPDATE user AS vbcreditst_1 SET vbcreditst_1.credits =  WHERE vbcreditst_1.userid = 5615;

The value for vbcreditst_1.credits is empty. It ran this query on this page:
/login.php?do=login

Any thoughts?

 

[Darkwaltz4]

Actually I think I fixed that in the 1.2 version which i neglected to backport to lite... I'll do that asap so keep an eye out. If you marked as installed at vborg youll get the alert.

 

[robdog]

Thanks! I will update this thread once the lite version is updated.

 

[robdog]

Any update on getting the fix for this out in the lite version?

 

[Darkwaltz4]

The lite version has been upgraded to v2.0.0 available here: http://www.dragonbyte-tech.com/threads/2139-vBCredits-II-Deluxe-v2.0.0-Gold-Lite-Released

 

[Darkwaltz4]

just cross-posting the fix from the pro forum until it is rolled into the next update:

Edit (forums)/dbtech/credits/credits_core.php find

$obj->myself[$currencyid]

replace with

floatval($obj->myself[$currencyid])