[RedFoxy]

Hi,
I've a really tedious error with my iTrader 2.7.8 on vBulletin Suite 4.1.0pl2, every day I've a lot of follow error:

 Database error in vBulletin 4.1.0:

Invalid SQL:

			SELECT COUNT(DISTINCT(userid)) AS usercount, COUNT(*) AS usercountall, rating
			FROM itrader
			WHERE rateduserid = 
			GROUP BY rating;

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 'GROUP BY rating' at line 4
Error Number  : 1064
Request Date  : Monday, January 24th 2011 @ 02:02:10 PM
Error Date    : Monday, January 24th 2011 @ 02:02:10 PM
Script        : http://www.softairmania.it/itrader_detail.php?ir=38098u=2894
Referrer      : 
IP Address    : *.*.*.*
Username      : Non registrato
Classname     : vB_Database
MySQL Version :

I tried by a logged user to visit the suggested links and I've no errors, but if I try to visit http://www.softairmania.it/itrader_d...ir=38098u=2894 as unlogged i got database error.

I thin that you miss a condition about unlogged user that have "Can View Ratings YES" in unregistered/unlogged usergroup, because if i set "Can View Ratings NO" to unregistered/unlogged users it goes without errors