Database Error..Starka

[gangoos88]

Hello,

today i got my first problem with MySQL

in phpAdmin is showing several of my tables as "In Use" and when I select them, it says:

#1033 - Incorrect information in file: './gangoos_gangoos/chat.frm'

This is happening to 7 out of 144 tables.

in other ways i would like to tell that it happened only with my chat feature and its related table..

since my site is online but the chat not working...

i did not change anything in last 100 hours..

Everything was fine since yesterday night..now not..

Please check..

Thanks..

---------- Post added at 10:38 AM ---------- Previous post was at 10:23 AM ----------

you might look at this thread..

Here

i think this problem is in starka database..

because 100% same problem in two sites (maybe more) at same time..

i did not made any changes in last 100 hours

i tried to repair the table..but it doesn't work.. says corrupted

since i haven't any backup for that particular tables, i am afraid that i am going to loose a huge amount of data..

Please solve this if you can..

Thanks....

[Skizzerz]

Hello,

I have notified the administrator of this issue and it should now be resolved.

[gangoos88]

wow..

really it has been solved now..

will you please tell us what was the problem?

and thanks for everything..

I love you guys....

[Skizzerz]

Sure,

The issue was that the InnoDB module wasn't loaded in MySQL for some strange reason, so we needed to restart the MySQL server. Once it restarted, all was well and the module was loaded.

[gangoos88]

Nice..

i think now it will not give any trouble in next 100 years..right??