Mysql Errors

[babycarrots]

I hope someone can help me decipher what to do here....

Today I've been getting these errors:

Database error in vBulletin 3.0.3:

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 05th of August 2004 09:11:03 PM
Script: http://*********.com/forums/cron.php?&rand=844966
Referer:
Username: Unregistered
IP Address: **.*.***.**

_________________________

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT threadid , COUNT(*) AS views FROM threadviews GROUP BY threadid
mysql error: Can't find file: 'threadviews.MYD' (errno: 2)

mysql error number: 1017

Date: Thursday 05th of August 2004 09:56:14 PM
Script: http://*******.com/forums/cron.php?&rand=6187
Referer: http://*******.com/forums/forumdisplay.php?f=30
Username: Unregistered
IP Address: **.***.**.**

I've ran the repair/optimization on the tables. But I still get these errors. What can cause this and what can I do about it?

Thanks,
Babycarrots

[Brian]

The error means your attachment table is corrupt. Repairing the table shoud fix the probelm. If not, I would contact your host.

[Our Sponsors]

[Zachery]

Er, not exactly both the thread and attachment views tables have gone somewhere on you odly.
You will need to recreate it

follow the instructions listed here

http://www.vbulletin.com/forum/showpost.php?p=697598&postcount=4

[babycarrots]

Thanks very much....I have dropped/recreated tables. Hopefully this will resolve issue. :)

Babycarrots

[Our Sponsors]

[Brian]

Er, not exactly both the thread and attachment views tables have gone somewhere on you odly.
You will need to recreate it

follow the instructions listed here

http://www.vbulletin.com/forum/showpost.php?p=697598&postcount=4
Ahhh... Strange that this has happend to a couple of people now...

[Zachery]

Yes we noticed it at vB.com and we have no anwser for it :/