PDA

View Full Version : There seems to have been a slight problem with the database


Akany
Sun 10th Sep '00, 11:12am
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
Sun 10th Sep '00, 2:44pm
do you ahve telnet acces? Run that script in telnet and see what it says.

Akany
Sun 10th Sep '00, 3:07pm
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
Sun 10th Sep '00, 9:20pm
what is the TRUE syntax for run this php file on Telnet ?

doron
Mon 11th Sep '00, 7:38am
you'll have to ask the your host to get a backup and fix it, if it was their fault.

Akany
Mon 11th Sep '00, 7:44am
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.