Jump to content

Archived

This topic is now archived and is closed to further replies.

jca13

Database Editor not showing new entries?

Recommended Posts

I woke up this morning to find my website coated in "Fatal Error: Database Error! - Can't open file: 'newscmts.MYI' (errno: 145)".

I set about going to the MySQL database to see what had gone wrong, assuming that one of the users had deliberately set about causing problems via unprotected database entry fields (as has happened before, and yes I have taken steps to help prevent this!).

Anyway, I got into the database and looked up the table where I assumed there would be a dodgy entry made to cause the error.

However, I found that the database entries for this table were outdated - the most recent shown was 3 days ago, even though there have been several since (all of which displayed by the MySQL call functions on the site). This is true for ALL of the tables in the database shown in the database editor - the tables only seem to show entries up until a couple days ago, even though the functions on the site clearly show many more recent entries.

What could have caused this problem?

Thanks in advance for any help!

Share this post


Link to post
Share on other sites
Doesn't sound good... at least it's the index file, and not the data... see what check tables has to say about this.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.