An exception occurred: Mysqli statement execute error

[Saburov]

Suddenly my forum started to give this error message and couldn't open:


An exception occurred: Mysqli statement execute error : Error writing file '/tmp/MYpSJuN0' (Errcode: 28) in /home/gezinen/public_html/library/Zend/Db/Statement/Mysqli.php on line 214

1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
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 218
4. XenForo_Model->fetchAllKeyed() in XenForo/Model/Thread.php at line 371
5. XenForo_Model_Thread->getThreads() in WidgetFramework/WidgetRenderer/Threads.php at line 93
6. WidgetFramework_WidgetRenderer_Threads->_render() in WidgetFramework/WidgetRenderer.php at line 167
7. WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 172
8. WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 134
9. WidgetFramework_Core->renderWidgetsFor() in WidgetFramework/Listener.php at line 20
10. WidgetFramework_Listener::template_post_render()
11. call_user_func_array() in XenForo/CodeEvent.php at line 54
12. XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 195
13. XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
14. XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 119
15. XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 565
16. XenForo_FrontController->renderView() in XenForo/FrontController.php at line 156
17. XenForo_FrontController->run() in /home/gezinen/public_html/index.php at line 13

Is someone hacked my website? or anything else?

 

[Chris D]

Looking at the error trace it seems as though the ultimate cause is the Widget Framework, specifically the Threads renderer.

I would first look at disabling that widget. Then if that doesn't work, try disabling the entire widget framework.

The provided error seems to suggest that it is having difficulty writing to a temp file on your server so it might actually be that you need to contact your host, verify you still have enough disk space and that the location it is writing to is writable.

 

[MattW]

I'd say you've run out of space in /tmp

 

[Saburov]

I checked out my hosting admincp disk space ability, but it seems there is enough space. And I disabled Widget Framework but it doesn't work.

But when i disabled Xenporta Portal my forum opened smoothly. How this xenporta might be broken suddenly?? I didn't even change anything.

 

[MattW]

Have a look here: http://xenforo.com/community/threads/currently-have-a-database-error.16882/

 

[Chris D]

Widget Framework or XenPorta are not the root causes.

The root cause is exactly what the error message says: "An exception occurred: Mysqli statement execute error : Error writing file '/tmp/MYpSJuN0' (Errcode: 28) in /home/gezinen/public_html/library/Zend/Db/Statement/Mysqli.php on line 214"

This happened to someone else recently, here is some more detail and a fix: http://xenforo.com/community/threads/mysqli-errors.36608/

Definitely looks to be disk space related, but not necessarily your entire file system.