XF 2.0 An exception occurred: [XF\Db\Exception] MySQL query error [126]: Incorrect key file for table '.\xf2\xf_session_admin.MYI';

[CyberAP]

Basically my PC froze when it was idle, I did a reboot and got a plain page with this message:

The site is currently being upgraded. Please check back later.

I googled that this might be caused by some add-ons misconfiguration, when it has is_processing set to 1. I set it to 0 and then got this error:

An exception occurred: [XF\Db\Exception] MySQL query error [126]: Incorrect key file for table '.\xf2\xf_session_admin.MYI'; try to repair it in src\XF\Db\AbstractStatement.php on line 212

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 174
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 70
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 74
4. XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
5. XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
6. XF\Session\Session->save() in src/XF/Admin/App.php at line 84
7. XF\Admin\App->complete() in src/XF/App.php at line 1883
8. XF\App->run() in src/XF.php at line 328
9. XF::runApp() in admin.php at line 13

It's crucial for me to restore access to admin CP as I have a lot of development progress unsaved (silly me). Frontend is working fine it's only ACP that I can't get into.

I tried rebuilding master data, it didn't work.

 

[Paul B]

Try to repair the xf_session_admin table, otherwise truncating it should work.

 

[CyberAP]

Try to repair the xf_session_admin table, otherwise truncating it should work.

Thanks, that helped.

 

[IGSteven]

is there any tools to repair databases as I've got multiple issues with my database after migrating a xf1 > xf2 forum

 

[CyberAP]

is there any tools to repair databases as I've got multiple issues with my database after migrating a xf1 > xf2 forum

I believe MySQL has a built-in mechanism for table repair, PHPMyAdmin just provides a simple interface for it.