Cripes Posted March 19, 2013 Share Posted March 19, 2013 I'm looking for a bit of help in resolving a possible database issue on my 1.5.3 installation. I have a product export module that produces a blank file. Turning on debugging produces the following error message within the file: Fatal error: Uncaught Incorrect key file for table '/tmp/#sql_a887_0.MYI' The developer suspects it's an issue with the ps_category_lang table, but I can't repair it from cPanel or phpMyAdmin because my install uses the InnoDB engine. The hosting company has confirmed there's no issue with lack of space in the /tmp folder, which the develop also suggested checking. How do I repair this particular table? Any suggestions appreciated... Link to comment Share on other sites More sharing options...
benjamin utterback Posted March 19, 2013 Share Posted March 19, 2013 Hello Cripes, what is the reason that you cannot enter phpmyadmin? I didn't think that using InnoDB will effect your access to phpmyadmin. Link to comment Share on other sites More sharing options...
Cripes Posted March 19, 2013 Author Share Posted March 19, 2013 Thanks for replying. I have full use of phpMyAdmin, but when I try to repair the ps_category_lang table it returns a message "The storage engine for the table doesn't support repair". A quick Google suggests it's because of Prestashop's default InnoDB option that phpMyAdmin can't properly repair it. Link to comment Share on other sites More sharing options...
benjamin utterback Posted March 19, 2013 Share Posted March 19, 2013 Could you export the table and repair it offline, then import the table(s) back? Back up before you do anything, but don't override any existing backups. Link to comment Share on other sites More sharing options...
Cripes Posted March 19, 2013 Author Share Posted March 19, 2013 I'm not sure how this can be done? Is there a website or utility (I'm on a Mac) I can use to do this? Link to comment Share on other sites More sharing options...
benjamin utterback Posted March 19, 2013 Share Posted March 19, 2013 Hi, If you have full access to phpmyadmin, there should be a way that you export/import tables. Link to comment Share on other sites More sharing options...
Cripes Posted March 19, 2013 Author Share Posted March 19, 2013 Yes, I can certainly export and import databases and individual tables, but what method to actually repair them? I'm not even sure how a table is repaired? I have another PS installation with no errors that I can compare it to, bit I'm still not sure what specific error/mismatch etc is causing the damage. Link to comment Share on other sites More sharing options...
benjamin utterback Posted March 19, 2013 Share Posted March 19, 2013 Well, hopefully you can use your last known working backup and repair the tables that way. That would be one way, I'm sure others may have their own ways. Link to comment Share on other sites More sharing options...
Cripes Posted March 19, 2013 Author Share Posted March 19, 2013 Righto, I'll have a look at the most recent backup and see whether importing that table fixes the issue - I'll report back... Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts