• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Our first server error

lazer

Well-known member
#1
We switched over to XF at the end of March and we logged our first server error yesterday.

Can anyone shed any light on this?

Error Info:
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'action' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: xxxx, Yesterday at 17:53
Stack Trace:
#0 /home/xxxxx/public_html/xf/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /home/xxxxx/public_html/xf/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /home/xxxxx/public_html/xf/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `dp...', Array)
#3 /home/xxxxx/public_html/xf/library/DigitalPointSpy/DataWriter/ModeratorLog.php(18): Zend_Db_Adapter_Abstract->insert('dp_spy', Array)
#4 /home/xxxxx/public_html/xf/library/XenForo/ModeratorLogHandler/ProfilePost.php(45): DigitalPointSpy_DataWriter_ModeratorLog->save()
#5 /home/xxxxx/public_html/xf/library/XenForo/ModeratorLogHandler/Abstract.php(32): XenForo_ModeratorLogHandler_ProfilePost->_log(Array, Array, 'comment_delete', Array, Array)
#6 /home/xxxxx/public_html/xf/library/XenForo/Model/Log.php(214): XenForo_ModeratorLogHandler_Abstract->log(Array, 'comment_delete', Array, Array, NULL)
#7 /home/xxxxx/public_html/xf/library/XenForo/Model/Log.php(200): XenForo_Model_Log->logModeratorActionLocal('profile_post', Array, 'comment_delete', Array, Array, NULL)
#8 /home/xxxxx/public_html/xf/library/XenForo/ControllerPublic/ProfilePost.php(439): XenForo_Model_Log::logModeratorAction('profile_post', Array, 'comment_delete', Array, Array)
#9 /home/xxxxx/public_html/xf/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_ProfilePost->actionCommentDelete()
#10 /home/xxxxx/public_html/xf/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#11 /home/xxxxx/public_html/xf/index.php(13): XenForo_FrontController->run()

#12 {main}
Request State:
array(3) {
["url"] => string(76) "http://www.xxxxxx.com/xf/profile-posts/17694/comment-delete?comment=818"
["_GET"] => array(1) {
["comment"] => string(3) "818"
}
["_POST"] => array(2) {
["_xfConfirm"] => string(1) "1"
["_xfToken"] => string(57) "22863,1339779207,b173831f91d8a6ee8c37a5d11a3e69f7a0a2fad4"
}
}

Thanks :)
 

Jeremy P

Well-known member
#2
Your DigitalPoint Spy addon was trying to insert something into the database but the column restrictions were too small to contain it. Something I'd report to digitalpoint in his addon's discussion.