Bug Database error in vBulletin 4.1.7

[soso]

Hey guys, get this after submitting a quiz that is set up for an award ???

Database error in vBulletin 4.1.7:

Invalid SQL:

						SELECT 
							COUNT() AS award_count 
						FROM dbtech_vbactivity_rewards
						WHERE 
							userid			= 3 && 
							featureid		= 4 && 
							feature			= 'medal';

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 ') AS award_count 
						FROM dbtech_vbactivity_rewards
						WHERE 
							useri' at line 2
Error Number  : 1064
Request Date  : Sunday, March 11th 2012 @ 01:17:07 PM
Error Date    : Sunday, March 11th 2012 @ 01:17:08 PM
Script        : http://www.*********.com/vbquiz.php?do=quizcomplete
Referrer      : http://www.*********.com/vbquiz.php?do=takequiz
IP Address    : 81.129.226.14
Username      : *********
Classname     : vB_Database
MySQL Version : 5.0.95-community

 

[Dylan]

Sorry about the problem.
Can you open dbtech/vbquiz/actions/quizcomplete.php

Find on about line 761

                            COUNT() AS award_count

and replace with

                            COUNT(*) AS award_count

That should fix it for you. Thanks for letting me know, I'll release a bugfix for it soon.

 

[soso]

Thanks mate .. Will let you know if i have any more issues with it ....