attachments : DB Error

[dsa411]

Hi i have vb 3.6.1 installed and when i am in admincp trying to manage my attachments i get database errors for pretty much every option except the maanger. All parts of the attachment section start out good (i can see the page for the function) until i try to perform the actual function(hit save, go, search etc..) like move attacments from database to file system or search for attacments
here is the error i get

Database error in vBulletin 3.6.1:

Invalid SQL:

		SELECT attachmentid, attachment.dateline, attachment.postid, filename, counter,
		user.userid, IF(user.userid<>0, user.username, post.username) AS username
		FROM vb_attachment AS attachment
		LEFT JOIN vb_user AS user ON (attachment.userid=user.userid)
		LEFT JOIN vb_post AS post ON (attachment.postid=post.postid)
		ORDER BY counter DESC
		LIMIT 5;

MySQL Error  : Column: 'counter' in field list is ambiguous
Error Number : 1052
Date         : Friday, October 20th 2006 @ 05:59:42 PM
Script       : http://****/****/admincp/attachment.php?do=stats
Referrer     : http://****/****/admincp/index.php?do=nav
IP Address   : *.*.*.*
Username     : ****
Classname    : vb_database

This error is i get from clickin attachment statistics.

i have only v3arcade related hacks installed and i am positive the error happend before installation of the hacks. for what ever reason(im a moron) i decided to wait til now to get to it.