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:cool:

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 :)