[shabbirbhimani]

Originally Posted by 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 


possible reason for your error can be the prefix that you have given when installing the vB. Use that prefix in all the tables but here in post table you are not prefixing it. I hope this should solve the problem but if not you can post again.

Also if you want much faster response you can use my site also.. url in sig.