Bug Database error

[Teamremodeling]

Hello,

We found this email:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT MAX(timestamp) AS latest, MIN(timestamp) AS earliest FROM vb_credits_transaction WHERE status IN (1, 2) AND timestamp >= 1224805080 AND timestamp <= 1363053695 AND u.userid = 229;

MySQL Error : Unknown column 'u.userid' in 'where clause'
Error Number : 1054
Request Date : Monday, March 11th 2013 @ 09:01:35 PM
Error Date : Monday, March 11th 2013 @ 09:01:36 PM
Script : Log in - Billievers Forums - vBulletin Admin Control Panel
Referrer : Log in - Billievers Forums - vBulletin Admin Control Panel
IP Address : 184.153.80.15
Username : Czech54
Classname : vB_Database
MySQL Version : 5.0.92-community

Could you please investigate this error?

Thank you

 

[Fillip H.]

I have uploaded a potential hotfix to /admincp/credits_admin.php - could you please re-download and re-upload that file and let me know if it's working for you now?

If it isn't, can you please specify the exact steps you took to produce the error, and I'll attempt to replicate it locally.