SQL Error on Showthread while in Threaded Mode

[Trekkan]

Just got an email with the following error:

Database error in vBulletin 4.0.2:

Invalid SQL:

	SELECT *
	FROM dhv_dbtech_vbactivity_rewards
	WHERE userid IN(
		SELECT userid
		FROM dhv_post AS post
		WHERE 
	)
	ORDER BY dateline DESC;

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 ')
	ORDER BY dateline DESC' at line 7
Error Number  : 1064
Request Date  : Sunday, February 28th 2010 @ 05:03:51 AM
Error Date    : Sunday, February 28th 2010 @ 05:03:51 AM
Script        : http://www.XXXXXX.com/showthread.php?4328-New-main-toon&mode=threaded

Looks like the sub-select's WHERE clause is messed up. =)

 

[Fillip H.]

Aha, this doesn't work properly in Threaded mode. That's interesting.

I'll get that fixed for the next version (the fix will be in the Lite version, as that's where that query is ran )

 

[Fillip H.]

As far as I can tell, this has now been fixed.
This'll be fixed in the next version, which will also come with an improved Activity formula, so that ridonkulously high %ages like we see on this board should no longer occur