[taffy056]

Hi,

I was getting the same error message as post number 14, but after I put the query in the following post I get this error on the forumhome, can you suggest a fix to this.

Thanks

PHP Code:

Database error in vBulletin 3.0.7:
Invalid SQL: SELECT userid, username, count(username) as posts FROM post as post where dateline >  group by username ORDER BY posts 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 'group by username ORDER BY posts DESC' at line 1

mysql error number: 1064