Well the hard drive on the server I am on got full and MYSQL Crashed, my site was down for about 20 hours. When it returned there was a weird error when someone tried to post a thread but I ran the repair script in the admin panel and that fixed it.
However now there are constant emails of MYSQL errors sent to me even though users aren't experiencing a problem.
Here are the two errors I have received so far.
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
and
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
Again the user when they browse the forum post threads view attachments encounter no error what so ever. However I am emailed with the above.
I do recall that when I ran the repair script that the MyAtachments.MYD wasn't found and I beleive PostSomething.MYD (don’t remember the name) said it had Crashed.
Can anyone help?
However now there are constant emails of MYSQL errors sent to me even though users aren't experiencing a problem.
Here are the two errors I have received so far.
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
and
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
Again the user when they browse the forum post threads view attachments encounter no error what so ever. However I am emailed with the above.
I do recall that when I ran the repair script that the MyAtachments.MYD wasn't found and I beleive PostSomething.MYD (don’t remember the name) said it had Crashed.
Can anyone help?
Comment