The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
mysql errors
I keep getting around 300 odd emails a day with errors like this in them
Code:
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 Watson |
#2
|
|||
|
|||
Run this query:
[sql]REPAIR TABLE attachmentviews;[/sql] |
#3
|
||||
|
||||
it could be needed to run it more than once.
|
#4
|
||||
|
||||
got this error
repair error Can't find file: 'attachmentviews.MYD' (errno: 2) |
#5
|
||||
|
||||
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... |
#6
|
||||
|
||||
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 |
#7
|
||||
|
||||
|
#8
|
||||
|
||||
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 |
#9
|
||||
|
||||
Quote:
|
#10
|
||||
|
||||
Cheers Zach, both executed succesful, I will let you know later on if it works (no more emails )
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|