SQL File Corruption

[Twinkie]

Back to threads again I see...

Anyhoo, I am getting this error when I query certain tables in my database and I don't think there is anything I can do from my end: Error: Incorrect information in file: './mtwinkie_testdb/Order_Items.frm'

I get this in two tables: Orders and Order_Items.

cPanel: mtwinkie
Domain: twinkie.pcriot.com
Forum Username: Twinkie

Thanks in advanced =]

PS: Why does x10 change so much! Every time I turn around, some important system is completely different :dunno:

 

[misson]

You can do two things. If you haven't already, try making a backup, then

• go into PHPMyAdmin and repair the Order_Items table.
• drop the Order_Items table and restore from an older backup.

The "Incorrect information in file" error might also indicate that InnoDB is currently unavailable.. To test this, try creating an InnoDB table, then insert data into it.

In case you're curious, the frm file holds the table definition. Outside of that, an admin will need to repair Order_Items. They might need the CREATE TABLE statement.

 

[descalzo]

The "Incorrect information in file" error might also indicate that InnoDB is currently unavailable.. To test this, try creating an InnoDB table, then insert data into it.

phpMyAdmin does not show InnoDB as an option on Chopin any more.
I tried to create an InnoDB table via php script. Script ran. Table created. Shows up as myISAM.

After the recent mySQL changes, two of my test tables were suddenly listed as 'Views'. At least one of them had been InnoDB.

 

[leafypiggy]

I also had this problem. David wasn't able to fix it. But I'll escalate it to support for you.