There seems to have been a slight problem with the database

[Akany]

Within the last few days im getting these failures:


Database error in vBulletin: Invalid SQL: SELECT threadid,title,open,lastpost,replycount,postuserna me,lastposter,notes,iconid,views FROM thread WHERE forumid=1 AND visible=1 AND lastpost >= 966001384 ORDER BY lastpost DESC LIMIT 0,40
mysql error: Got error 127 from table handler
mysql error number: 1030
Date: Sunday 10th of September 2000 03:43:04 PM
Script: /forum/forumdisplay.php3?forumid=1


Anyone has an idea?

[doron]

do you ahve telnet acces? Run that script in telnet and see what it says.

[Akany]

Hi,
no i do not have telnet access - in the meanwhile i already found out whats the problem - the thread table got corrupted through a power outage. So i can not dump this table and i can not repair via telnet. I need to repair this table esle 50 % of the threats in my forum will be away...

[Dode]

what is the TRUE syntax for run this php file on Telnet ?

[doron]

you'll have to ask the your host to get a backup and fix it, if it was their fault.

[Akany]

I just found a solution for my problem (Copy and Paste 300 Threads :-() with phpMyAdmin. The first thing that ill do after finishing that is writing a little backup script for my dbase.