All records/articles are gone!

alex1000 · Post by **alex1000** » Fri Mar 26, 2004 6:07 am

Hello,

We've been using phpMyFaq 1.3.5-7 for the past 6 mos or so, and like it very much.

Today we ran into a problem when someone discovered ALL our articles (FAQ-KB articles) were gone. Not one record remains (we had about 150 articles). We restarted MySQL (4.0.14) a couple of times, with no change.

If I login as an admin user I see all the users, so they still remain, and if I click " Edit open questions", I see a ton of "questions", but the articles can't be found anywhere.

Any insight on what to check or what could have happened? We do have another database in MySQL, but it is still functioning properly.

I'll check in the morning for backups, to see if we can perform a restore.

phpMyFAQ Version phpMyFAQ 1.3.7
PHP Version PHP 4.3.3
Register Globals off
Safe Mode off
MySQL Version MySQL 4.0.14
Webserver Interface APACHE

Thanks.

alex1000 · Post by **alex1000** » Fri Mar 26, 2004 6:08 am

Also verified disk wasn't full, as that was our first thought. But we have several gigs left.

Post by **Thorsten** » Fri Mar 26, 2004 6:48 am

Hi,

are the records in the database or is there nothing?

Do you have access to your server logs? Especially to the apache logs?

Please answer via e-mail.

bye
Thorsten

alex1000 · Post by **alex1000** » Fri Mar 26, 2004 8:10 pm

Thanks for your reply! We noticed the table was corrupt, as we got this error:
#1016 - Can't open file: 'faqdata.MYI'. (errno: 145)

We managed to rebuild the corrupted table using the command...
# mysqlcheck -r faq faqdata -uroot -p[ourpassword]

No dataloss, and all is back to normal: www.bynari.net/faq/

We also upgraded to 1.3.10 now