What is at the bottom of the database error that you posted above? When you get the error, view the page source for that page and you will see the actual database error near the bottom of that page. It will have some information like this:
Code:
The actual mysql query/code/problem....
MySQL Error : some sort of something here
Error Number : another something here
Date : Sunday, April 13th 2008 @ 11:16:43 AM
Script : http://address.path.path/page.php
Referrer :
IP Address : **.***.**.***
Username : username
Classname : database
I would suggest if you have a lot of attachments, and especially large attachments, that you store them in the filesystem.
http://www.vbulletin.com/docs/html/attachment_storage