Attachments Problem:

[Jack Crazy]

Database error in vBulletin 3.5.1:

Invalid SQL:
INSERT INTO attachmentviews (attachmentid)
VALUES (27);

MySQL Error : Can't find file: 'attachmentviews.MYD' (errno: 2)
Error Number : 1017
Date : Friday, October 6th 2006 @ 04:09:21 AM
Script : http://www.vegasimports.com/forum/attachment.php?attachmentid=27&d=1160132817
Referrer :
IP Address : **.***.***.***
Username : **********
Classname : vb_database


What can i do to fix this?

[Jack Crazy]

any help?

[calorie]

Check via say phpMyAdmin whether or not you have an attachmentviews table. If not, run the following query:

CREATE TABLE attachmentviews (attachmentid INT UNSIGNED NOT NULL DEFAULT '0', KEY postid (attachmentid));

Note though that attachmentviews is part of a default vB install. If it was dropped, you might try to find why.

[G0F0RBR0KE]

If the table was drop, I can help you get it back.

Contact: Alexanderjm316@hotmail.com

We will need to find a perfect day, it might take 1 to 2 hrs or less depending on how big your forum is.

I had this issue before.

My backup had a drop file and i had to do a lot of recoding to do. I'll be glad to get it up and running again.

If that want you want or ask the vBulletin to do it for you (i think they'll charge you).