mysql errors

[Watson]

I keep getting around 300 odd emails a day with errors like this in them

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 21st of October 2004 10:10:11 AM
Script: http://forums.bootleg.org.uk/cron.php?&rand=790522
Referer: http://forums.bootleg.org.uk/showthread.php?p=10417&posted=1#post10417
Username: Watson
IP Address: 62.252.128.25

They aint able to do anything over at vb.com cause I used hacks, but these emails are really annoying me now, anyone know what could be causeing them?

Watson

[Brad]

Run this query:

[sql]REPAIR TABLE attachmentviews;[/sql]

[Xenon]

it could be needed to run it more than once.

[Watson]

got this error

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

[Xenon]

it's a corruption in your DB, nothing to do with vBulletin itself.

try upload the file tools.php from your vb zip file and run the repair option several times, if that doesn't help, you will have to contact the server admin, to repair the DB manually.

it could also mean you would have to upload a backup...

[Watson]

ahh, its been like that for ages now, so any backup I got will have same problems I tried the tools.php a while ago and still had same problem. Only good thing thats came of it is I filtered the mail into a new folder, heh, but still a pain. I will have a word with the server admins, cause I know them personally, its just trying to convince 1 of them to have a look

thanks for the help tho

[Zachery]

http://www.vbulletin.com/forum/showp...98&postcount=4

[Watson]

got another error mate

SQL-query :

DROP IF EXISTS threadviews

MySQL said:

You have an error in your SQL syntax near 'IF EXISTS threadviews' at line 1

[Zachery]

Originally Posted by Watson

got another error mate

SQL-query :

DROP IF EXISTS threadviews

MySQL said:


You have an error in your SQL syntax near 'IF EXISTS threadviews' at line 1

give it another shot now (i edited my post)

[Watson]

Cheers Zach, both executed succesful, I will let you know later on if it works (no more emails )