Log in

View Full Version : Attachment view error


MuddyPaws
05-10-2008, 01:19 AM
Some help please? File I am trying to view is a uploaded jpg. When trying to view an uploaded attachment I get his error:

Database error in vBulletin 3.6.9:

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

MySQL Error : Incorrect file format 'attachmentviews'
Error Number : 130
Date : Friday, May 9th 2008 @ 10:15:31 PM
Script : http://www.me.com/forums/attachment.php?attachmentid=242&d=1210384920
Referrer :
IP Address : xxx.xxx.xxx.xxx
Username : Me
Classname : vb_database

Marco van Herwaarden
05-10-2008, 01:47 PM
To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:
Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue
If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables.

If this doesn't help, please contact your host.