Bug Viewing of credits transaction in admincp - Database error.

[avatar12345]

Hi,

After upgrading to the latest vbcredits version. When I try re-calculate users accounts and click on a username to view their transaction.

It shows me this error message: Please rectify? Thanks.

Database error in vBulletin 4.2.1:

Invalid SQL:
SELECT * FROM credits_transaction WHERE status IN (1, 2) AND timestamp >= 1331544540 AND timestamp <= 1372756404 AND t.userid = 4 ORDER BY status DESC, timestamp DESC LIMIT 0, 50;

MySQL Error : Unknown column 't.userid' in 'where clause'
Error Number : 1054
Request Date : Tuesday, July 2nd 2013 @ 05:13:24 PM
Error Date : Tuesday, July 2nd 2013 @ 05:13:24 PM
Script : http://www.com.sg/admincp/cr...ansactions&u=4
Referrer : http://www.com.sg/admincp/cr...p?do=findusers
IP Address : 12.12.12.12.12
Username : admin
Classname : vB_Database
MySQL Version : 5.5.31-cll

 

[Fillip H.]

Please try re-downloading and re-uploading /AdminCP/credits_admin.php and let me know if this works for you

 

[avatar12345]

Ok. it works now. Why is this so?

 

[Fillip H.]

Why is this so?

Because I updated the file to fix it... :RpS_unsure: