mysql error: Can't find file: 'attachmentviews.MYD' (errno: 2)

[SharkMatt]

Why am I getting this error for the past few days?
How can I fix it?!? Thanks

 
[size=2]Database error in vBulletin 3.0.0 Beta 4:

 
Invalid SQL: SELECT attachmentid, COUNT(*) AS views FROM attachmentviews GROUP BY attachmentid
mysql error: Can't find file: 'attachmentviews.MYD' (errno: 2)
 
 
mysql error number: 1017
 
 
Date: Thursday 07th of August 2003 07:50:44 AM
Script: [/size][url="http://www.sbhacsupport.ca/cron.php3?&rand=463724"][u][size=2][color=#0000ff]http://www.sbhacsupport.ca/cron.php3?&rand=463724[/color][/size][/u][size=2][color=#0000ff][/color][/size][/url]
[size=2]Referer: [/size][url="http://www.sbhacsupport.ca/"][u][size=2][color=#0000ff]http://www.sbhacsupport.ca/[/color][/size][/u][size=2][color=#0000ff][/color][/size][/url]
[size=2]Username: Unregistered
[/size]

[Steve Machol]

You don't have an attachmentviews table. What exactly have you done up to this point?

[SharkMatt]

All I have done to this point is go through the "Repair/Optimize Tables" which hasnt helped @ all. How can I have this problem all of sudden? Nothing has been done to the database in any sort.

[Steve Machol]

That's not what I meant. The creation of this table is a normal part of the vB3 upgrade/install process. Either something went wrong with this process, or the table was removed after it was done. I'm trying to ascertain exactly what has been done to get to this point of having this table missing.

[SharkMatt]

VB3 Beta 4 was installed weeks ago and I havent had any problems til the past few days. The database itself hasnt been touch. Normal duties (approval, adding navbar buttons, adding faqs) have been done, but nothing to the database itself. I also changed the permission for unregistered users so that they can view the forums but not the posts.

[Steve Machol]

So everything was fine until the last few days? If you haven't done anything to the database then in all likelihood something happened on the seer to remove that table.

Assuming you did not use a table prefix, you can run this query to recreate that table:

TABLE attachmentviews (
        attachmentid int unsigned NOT NULL DEFAULT '0',
        KEY postid (attachmentid)
)
;

[SharkMatt]

ErrorSQL-query : TABLE attachmentviews ( attachmentid int unsigned NOT NULL DEFAULT '0', KEY postid (attachmentid))MySQL said:
You have an error in your SQL syntax near 'TABLE attachmentviews ( attachmentid int unsigned NOT NULL DEFAULT '0',' at line 1

[Steve Machol]

Sorry. Try this:

CREATE TABLE attachmentviews (
attachmentid int unsigned NOT NULL DEFAULT '0',
KEY postid (attachmentid)
)
;

[SharkMatt]

It worked! Now lets hope the error is gone and won't have anymore error email about it *crosses fingers*