[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