Fixed - See Edit at bottom of message
-------------------------------------------
Stats works wonderfully as long as I don't select any of the Limit By options.
When I select either the limit by posts or usergroup id's, I get the following database error (any recommendations on what to look for?):
Database error in vBulletin 3.0.6:
Invalid SQL: SELECT COUNT(referrerid) as getusers FROM user WHERE referrerid > 0 AND posts 9
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 '9' at line 1
mysql error number: 1064
Date: Wednesday 16th of March 2005 08:38:36 PM
Script:
http://www.barrreport.com/forums/adm...rralstatistics
Referer:
http://www.barrreport.com/forums/admincp/
Username: Admin
IP Address: 63.162.87.195
***********EDIT**************************
This error is created if you do not set a "conditional" in the field:
That is / are:
Set the conditional to Equals and all works well ...
Greg