Bug Database Error

[Madhatterr]

I am receiving a database error when trying to integrate multiple currencies with the new shop system from VBCredits II.

Here is the error.

Database error in vBulletin 4.1.3:

Invalid SQL:

			SELECT
				pointstable_1.credits AS points_1,pointstable_2.activity_points AS points_2,
				post.userid
			FROM post AS post
			LEFT JOIN user AS pointstable_1 ON(pointstable_1.userid = post.userid),LEFT JOIN user AS pointstable_2 ON(pointstable_2.userid = post.userid)
			WHERE post.postid IN (0109787,110026,110278);

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 'LEFT JOIN user AS pointstable_2 ON(pointstable_2.userid = post.userid)
			WHERE ' at line 5
Error Number  : 1064
Request Date  : Saturday, May 14th 2011 @ 10:41:38 AM
Error Date    : Saturday, May 14th 2011 @ 10:41:38 AM
Script        : http://myworldofdarkness.com/showthread.php?t=6855
Referrer      : http://myworldofdarkness.com/announcements/
IP Address    : 70.243.111.132
Username      : Miranda
Classname     : vB_Database_MySQLi
MySQL Version : 5.0.92-community-log

 

[Fillip H.]

Ah I think that's my fault, gimme a sec

 

[Fillip H.]

Re-download vBShop please, I fixed it

 

[Madhatterr]

Will do, thank you!