Strange error, forum will not work.

[not]

Database error in vBulletin 3.8.6:

Invalid SQL:

SELECT thread.threadid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views

FROM vbull_thread AS thread


WHERE forumid = 13
AND sticky = 0

AND visible IN (0,1,2)




ORDER BY sticky DESC, lastpost DESC
LIMIT 0, 20;

MySQL Error : Unexpected e o f found when reading file '/tmp/MY****0' (Errcode: 0)
Error Number : 9
Request Date : Friday, October 28th 2011 @ 08:25:31 AM
Error Date : Friday, October 28th 2011 @ 08:25:32 AM
MySQL Version : 4.1.14

[Trevor Hannant]

Run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin Control Panel -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP, then you can use phpMyAdmin to repair tables.

If that doesn't work then this may be too damaged to fix with the normal methods. Please check out this thread for other ways to repair a db, particularly items #2 and 3:

https://www.vbulletin.com/forum/showthread.php?s=&threadid=44909

You may have to ask your host to try and repair this for you.

[not]

the entire database? or just the thread tables

I checked the tables in phpmyadmin and they all checked out OK, it has me puzzled.

[Trevor Hannant]

If repairing the specific table doesn't work, you will need to speak to your host

[not]

We have tried to repair tables
We have tried to restore it from a good 3 day old backup, and keep getting the "Unexpected eof found when reading file '/tmp/MY*******O' (Errcode: 0)

It's only affecting two of the 8 forums on the board.

It also looks like a new HEAP temp file has been created. vbull_taggregate_temp_1306434600 could i try to run a query on session and cpsession, and delete the temp file?

any suggestions? Would it be better to file a ticket? My host is stumped.

[not]

We have tried to repair tables
We have tried to restore it from a good 3 day old backup, and keep getting the "Unexpected eof found when reading file '/tmp/MY*******O' (Errcode: 0)

It's only affecting two of the 8 forums on the board.

It also looks like a new HEAP temp file has been created. vbull_taggregate_temp_1306434600 could i try to run a query on session and cpsession, and delete the temp file?

any suggestions? Would it be better to file a ticket? My host is stumped.

Used two backups, both were made when the site was working properly. Both crashed the same tables when used to restore.

[Simon Lloyd]

You can get rid of the temp files and ask your host to optimise tables for you, you may find that there are TMD files already created in your database for crashed tables (you cannot see them in phpmyadmin you need to use ssh or have other database management software) these will need to be deleted before repairing or optimising tables, your host should be able to do this for you.

[not]

Simon Lloyd, thank you. It looks like we are out of luck, as they claim they cannot access their database server. ???(yahoo) I guess we are lucky that we kept it going for 5 years, it would be nice if they would remove the file so we can move to another place. Again, thanks for your help.

[Simon Lloyd]

Simon Lloyd, thank you. It looks like we are out of luck, as they claim they cannot access their database server. ???(yahoo) I guess we are lucky that we kept it going for 5 years, it would be nice if they would remove the file so we can move to another place. Again, thanks for your help.

Thats very strange, a host that cannot access it's server?

If you've paid them then they have a duty to provide the service!

[not]

This is getting more and more strange. From the beginning we have been getting this error in two forums on our board.

Database error in vBulletin 3.8.6:

Invalid SQL:

SELECT thread.threadid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views
FROM vbull_thread AS thread
WHERE forumid = 7
AND sticky = 0
AND visible IN (0,1,2)
ORDER BY sticky DESC, lastpost DESC
LIMIT 0, 20;

MySQL Error : Unexpected eof found when reading file '/tmp/MY******' (Errcode: 0)
Error Number : 9
Request Date : Thursday, November 10th 2011 @ 03:38:57 AM
Error Date : Thursday, November 10th 2011 @ 03:38:57 AM

After a week of rebuilding the database, calling the host, and restoring the board several times, we cleared it up on one forum.
With help from the host, I made a new account for them to check the board. To my surprise, the new account could enter the forum and post, but all old accounts could not (database error). I made another new account and tried it, it also allowed access. The database error is only affecting old accounts, new ones work ok. (remember this is just on one forum, not the entire board).

The host went through and deleted the temp files, and everyone has access. (the temp files always start with '/tmp/MY the next six numbers can change.)

Is it possibile this is a problem with login keys? Any suggestions?

[Wayne Luke]

Is it possibile this is a problem with login keys? Any suggestions?

No.. It means the temporary files were corrupted. Probably from abnormal shutdowns in MySQL for some reason or another. Deleting them allows MySQL to return to normal operations.