Database Error

AndrewB · Post by **AndrewB** » Thu Mar 18, 2004 5:40 pm

I am trying to edit a record in my FAQ. I get the following error

Unfortunately, a database error occured.Incorrect key file for table: 'faqdata'. Try to repair it

I am able to update other records and insert new entries.

Can this item be corrupt?
Is there a size limit on the data that can go in a TEXT column?
Anything I can try to debug this more?

BTW - the update also fails in phpMyAdmin with this error
tbl_replace.php: Missing db
tbl_replace.php: Missing table
tbl_replace.php: Missing goto

thanks for any help

Post by **Thorsten** » Thu Mar 18, 2004 8:33 pm

Hi,

the limit of a TEXT column is at 2 mio characters.

It seems your MySQL database is corrupt and need to rebuild.

bye
Thorsten

AndrewB · Post by **AndrewB** » Thu Mar 18, 2004 9:18 pm

thanks for replying.

to rebuild it...

do I just drop all the tables and restore from a backup or is just a restore from backup enough?

is it more drastic? Do I have to install phpMyFAQ again?

thanks

Post by **Thorsten** » Thu Mar 18, 2004 9:21 pm

Hi Andrew,

I would test to restore the whole data. If the error still occurs contact your webhoster because this could be a file problem with the MySQL server, too.

bye
Thorsten

AndrewB · Post by **AndrewB** » Thu Mar 18, 2004 10:26 pm

thanks

AndrewB · Post by **AndrewB** » Fri Mar 19, 2004 5:16 am

I was unable to work on this all day and then later in the day I got this error

MySQL said: #1016 - Can't open file: 'faqdata.MYI'. (errno: 145)

my whole faqdata table was not available

I had a backup from this morning - so I dropped the table and re built it and then did a restore from the backup

Now it is running fine again

thank goodness for backups