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.

[Paul M]

In default vb, only the attachment table has a field called counter - you seem to have one in either your post or user table. It's not added by the arcade so an old modification must have added in the past. You should check which of those two table has the extra column and drop/rename it.

[dsa411]

Thank you so much! just dropped the table and it worked out fine

seems like the only other problem i have is moving the attachments from the database to filesystem here is the error

atabase error in vBulletin 3.6.1:

Invalid SQL:

		SELECT attachmentid, filename, filedata, filesize, userid, thumbnail
		FROM vb_attachment
		WHERE attachmentid >= 2 AND attachmentid < 302
		ORDER BY attachmentid ASC;

MySQL Error  : MySQL client run out of memory
Error Number : 2008
Date         : Saturday, October 21st 2006 @ 01:59:19 AM
Script       : http://****/*****/admincp/attachment.php?do=domoveattachment
Referrer     : http://****/*****/admincp/attachment.php?do=doswitchtype
IP Address   : *.*.*.*
Username     : *****
Classname    : vb_database

FIXED!
seems i just turned "Number of attachments to process per cycle" down and worked fine. guess my server cant handle 300