See Node tree - Error

[ioneti]

Hi, in ACP when i go to see node tree i have this error:

Mysqli statement execute error : Can't create/write to file '/tmp/#sql_35a6_0.MYD' (Errcode: 17)

1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
3. Zend_Db_Adapter_Abstract->query() in XenForo/Model.php at line 219
4. XenForo_Model->fetchAllKeyed() in XenForo/Model/Moderator.php at line 97
5. XenForo_Model_Moderator->getContentModerators() in XenForo/ControllerAdmin/Node.php at line 26
6. XenForo_ControllerAdmin_Node->actionIndex() in XenForo/FrontController.php at line 337
7. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
8. XenForo_FrontController->run() in /home/forocsgo/public_html/admin.php at line 13

sorry if this is not the site to post it.

 

[Mike]

I deleted the database but other example:

When i go to create a thread and i pulse S, it shows me threads of x.com!!!!!

is possible that it is the error?

Yes, that is probably the cause of all of this. It almost sounds like the database directory was just deleted, rather than the database being removed via MySQL.

I don't have a particular recommendation to be honest. This is a potential situation where a specialist is needed to ensure data consistency in the database. If there's no other data, it might be safer to uninstall MySQL, delete all the data and then reinstall it. (These options are not for the faint of heart and I only recommend a server administrator undertaking them.)