See Node tree - Error

ioneti

ioneti

Active member
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.
 
Sort by date Sort by votes
yes. this:

Code: 
Info del error
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Can't create/write to file '/tmp/#sql_35a6_0.MYD' (Errcode: 17) - library/Zend/Db/Statement/Mysqli.php:214
Generado por: i0n, Hace 1 minuto
Seguimiento

#0 /home/forocsgo/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/forocsgo/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/forocsgo/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT mod...', Array, 2)
#3 /home/forocsgo/public_html/library/XenForo/Model/Moderator.php(97): XenForo_Model->fetchAllKeyed('?????SELECT mod...', 'moderator_id')
#4 /home/forocsgo/public_html/library/XenForo/ControllerAdmin/Node.php(26): XenForo_Model_Moderator->getContentModerators(Array)
#5 /home/forocsgo/public_html/library/XenForo/FrontController.php(337): XenForo_ControllerAdmin_Node->actionIndex()
#6 /home/forocsgo/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /home/forocsgo/public_html/admin.php(13): XenForo_FrontController->run()
#8 {main}

Estado de la solicitud

array(3) {
  ["url"] => string(39) "http://www.xiglo21.com/admin.php?nodes/"
  ["_GET"] => array(1) {
    ["nodes/"] => string(0) ""
  }
  ["_POST"] => array(0) {
  }
 
Upvote 0 Downvote
ioneti said:
yes. this:

Code: 
Info del error
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Can't create/write to file '/tmp/#sql_35a6_0.MYD' (Errcode: 17) - library/Zend/Db/Statement/Mysqli.php:214
Generado por: i0n, Hace 1 minuto
Seguimiento

#0 /home/forocsgo/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/forocsgo/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/forocsgo/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT mod...', Array, 2)
#3 /home/forocsgo/public_html/library/XenForo/Model/Moderator.php(97): XenForo_Model->fetchAllKeyed('?????SELECT mod...', 'moderator_id')
#4 /home/forocsgo/public_html/library/XenForo/ControllerAdmin/Node.php(26): XenForo_Model_Moderator->getContentModerators(Array)
#5 /home/forocsgo/public_html/library/XenForo/FrontController.php(337): XenForo_ControllerAdmin_Node->actionIndex()
#6 /home/forocsgo/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /home/forocsgo/public_html/admin.php(13): XenForo_FrontController->run()
#8 {main}

Estado de la solicitud

array(3) {
  ["url"] => string(39) "http://www.xiglo21.com/admin.php?nodes/"
  ["_GET"] => array(1) {
    ["nodes/"] => string(0) ""
  }
  ["_POST"] => array(0) {
  }
Click to expand...

Have you tried disabling your resources via config.php to see if the problem persists afterward?
 
Upvote 0 Downvote
Jeremy said:
This is a server issue related to mySQL. You should contact your host for help.
Click to expand...


The error has been for a private forum. I think an error with xenporta...

Now, i want to create the same node-forum and when i click to accept an error shows again

Mysqli statement execute error : Duplicate entry '18' for key 'PRIMARY'
  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 Zend/Db/Adapter/Abstract.php at line 574
  4. Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1612
  5. XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1601
  6. XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1393
  7. XenForo_DataWriter->save() in XenForo/ControllerAdmin/Forum.php at line 122
  8. XenForo_ControllerAdmin_Forum->actionSave() in XenForo/FrontController.php at line 337
  9. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  10. XenForo_FrontController->run() in /home/forocsgo/public_html/admin.php at line 13
 
Upvote 0 Downvote
With the first error, the second error makes me wonder if there's potential data corruption here. The error you're now receiving indicates inconsistent data. If you have a recent backup, that might be the safest option.

If not, be aware that you may run into various other errors. On the whole, you'll just need to try to create the record until it goes through (the number in the error should go up each time).
 
Upvote 0 Downvote
Mike said:
With the first error, the second error makes me wonder if there's potential data corruption here. The error you're now receiving indicates inconsistent data. If you have a recent backup, that might be the safest option.

If not, be aware that you may run into various other errors. On the whole, you'll just need to try to create the record until it goes through (the number in the error should go up each time).
Click to expand...


When i created some new forums some dates of the previous forum shows on.

example:

i created a forum. i select name and when i pulse D it shows me Donation, the problem is that Donation is a forum of my previous XENFORO forum that i deleted.

I deleted the XENFORO forum and the database...

Maybe it is the error i thinks, or not? what can i do?
 
Upvote 0 Downvote
I dont explain very good but help please:

2 weeks ago my xenforo forum was x.com. I deleted it and create new xenforo forum call y.com.

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?

thanks!!
 
Upvote 0 Downvote
My forum its new...i reset host and i go to install all again...

Thanks again!

One more question Jeremy, i want to auto backup my database.

My host has cron works...what i have to do?
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

jb9826
  • Question Question
XF 1.5 Batch Update Threads Timeout
Replies
0
Views
316
jb9826
jb9826
questlot
  • Solved
XF 2.0 Xenforo Import Error
Replies
5
Views
544
questlot
questlot
jb9826
  • Question Question
XF 1.5 Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction
Replies
0
Views
532
jb9826
jb9826
RG70Hz
  • Question Question
XF 1.2 Math error when uploading new styles [themehouse]
Replies
15
Views
778
RG70Hz
RG70Hz
C
  • Solved
XF\Db\Exception: MySQL statement prepare error [2006]: MySQL server has gone away
Replies
7
Views
957
canina
C
Top Bottom