XF 1.5 Server Error

[Shawn Gossman]

On my XF forum (running version 1.5.13), I'm getting the following error:

Mysqli prepare error: Table 'databasename.xf_thread' doesn't exist

Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
XenForo_Model->fetchAllKeyed() in XenForo/Model/Thread.php at line 563
XenForo_Model_Thread->getThreads() in XenForo/ControllerPublic/Forum.php at line 103
XenForo_ControllerPublic_Forum->actionIndex() in PrefixEss/XenForo/ControllerPublic/Forum.php at line 7
PrefixEss_XenForo_ControllerPublic_Forum->actionIndex() in WidgetFramework/XenForo/ControllerPublic/Forum.php at line 12
WidgetFramework_XenForo_ControllerPublic_Forum->actionIndex() in NFLJ/AMS/XenForo/ControllerPublic/Forum.php at line 7
NFLJ_AMS_XenForo_ControllerPublic_Forum->actionIndex() in NFLJ/Showcase/XenForo/ControllerPublic/Forum.php at line 7
NFLJ_Showcase_XenForo_ControllerPublic_Forum->actionIndex() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/-/-/index.php at line 13

I've not tampered with that database recently at all. The forum worked fine the other day. The database size is 1.95 GB.

Any ideas?

 

[Shawn Gossman]

Just an update in case anyone runs into this problem and since no one answered, now you can know what to try

I asked my hosting service to restart my MySQL server, which they did and it was fixed.

 

[Gregory Lynn]

Just an update in case anyone runs into this problem and since no one answered, now you can know what to try

I asked my hosting service to restart my MySQL server, which they did and it was fixed.

Thats wild and good to know. I read your thread and I would have answered it if I knew how to fix it but I don't know anything about MySQL.

 

[Shawn Gossman]

It didn't remain good for long, now I am getting this error:

Mysqli statement execute error : Index xf_thread is corrupted

 

[Paul B]

That sounds like server/MySQL issues/instability, which is causing MySQL to restart unexpectedly, resulting in database corruption.

Your host should look into what's causing the instability and resolve it.
After which time you may be able to repair the xf_thread table.
If that doesn't work, restoring from a known good backup may be your only option.

 

[Shawn Gossman]

Here is their response:

2017-07-30 09:22:37 2e2ec263700 InnoDB: table
"2015skywarnforum"."xf_thread"is corrupted. Please drop the table and
recreate
2017-07-30 09:22:37 7243 [Warning] InnoDB: Cannot open table
2015skywarnforum/xf_thread from the internal data dictionary of InnoDB
though the .frm file for the table exists. See
http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for
how you can resolve the problem.