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

XF 1.4 Error Data too long for column 'email_subject'

Discussion in 'Troubleshooting and Problems' started by marremp2, Sep 8, 2015.

  1. marremp2

    marremp2 Member

    Hi

    We launched our new XF site (imported from vb3.8) last friday and have some email sending problems (people claiming that they don't receive alerts for threads or forums they watch).

    Today we have this error for the first time:

    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'email_subject' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
    
    #0 /forums/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 //forums/library/Andy/EmailLog/Mail.php(95): Zend_Db_Adapter_Abstract->query('\n\t\t\tINSERT INTO...', Array)
    #3 forums/library/XenForo/Model/ThreadWatch.php(261): Andy_EmailLog_Mail->queue(')
    #4 /forums/library/XenForo/DataWriter/DiscussionMessage/Post.php(164): XenForo_Model_ThreadWatch->sendNotificationToWatchUsersOnReply(Array, NULL, Array)
    #5 /forums/library/WidgetFramework/XenForo/DataWriter/DiscussionMessage/Post.php(7): XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #6 /forums/library/Tinhte/XenTag/XenForo/DataWriter/DiscussionMessage/Post.php(113): WidgetFramework_XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #7 forums/library/XenForo/DataWriter.php(1423): Tinhte_XenTag_XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #8 /forums/library/XenForo/ControllerPublic/Thread.php(557): XenForo_DataWriter->save()
    #9 /forums/library/Waindigo/Trophies/Extend/XenForo/ControllerPublic/Thread.php(34): XenForo_ControllerPublic_Thread->actionAddReply()
    #10 /forums/library/XenForo/FrontController.php(347): Waindigo_Trophies_Extend_XenForo_ControllerPublic_Thread->actionAddReply()
    #11 /forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #12/forums/index.php(13): XenForo_FrontController->run()
    #13 {main}
    
    Where does it come from : are threads title too long ?
    Could it explain some of our emails problem ?

    Thanks for your help

    Marina
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    I see reference to several add-ons there, notably one related to emails.

    If you disable add-ons do the errors still occur?
     
  3. AndyB

    AndyB Well-Known Member

    I just updated the Email Log add-on to v1.2 which corrects this problem.
     
    marremp2 likes this.
  4. marremp2

    marremp2 Member

    Thanks a lot Andy !
    However, I have updated Email log

    upload_2015-9-9_10-15-31.png

    and I still have the same error :

    Code:
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'email_subject' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
    Généré par: Reboot, il y a 2 minutes
    Trace de la pile
    #0 /forums/library/Zend/Db/Statement.php(317): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /forums/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 //forums/library/Andy/EmailLog/Mail.php(95): Zend_Db_Adapter_Abstract->query('\n\t\t\tINSERT INTO...', Array)
    #3 /forums/library/XenForo/Model/ThreadWatch.php(261): Andy_EmailLog_Mail->queue
    #4 forums/library/XenForo/DataWriter/DiscussionMessage/Post.php(164): XenForo_Model_ThreadWatch->sendNotificationToWatchUsersOnReply(Array, NULL, Array)
    #5 /forums/library/WidgetFramework/XenForo/DataWriter/DiscussionMessage/Post.php(7): XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #6 /forums/library/Tinhte/XenTag/XenForo/DataWriter/DiscussionMessage/Post.php(113): WidgetFramework_XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #7 /forums/library/XenForo/DataWriter.php(1423): Tinhte_XenTag_XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #8 forums/library/XenForo/ControllerPublic/Thread.php(557): XenForo_DataWriter->save()
    #9 /forums/library/Waindigo/Trophies/Extend/XenForo/ControllerPublic/Thread.php(34): XenForo_ControllerPublic_Thread->actionAddReply()
    #10 /forums/library/XenForo/FrontController.php(347): Waindigo_Trophies_Extend_XenForo_ControllerPublic_Thread->actionAddReply()
    #11 forums/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #12 forums/index.php(13): XenForo_FrontController->run()
    #13 {main}
     
  5. Mike

    Mike XenForo Developer Staff Member

    Please direct any further troubleshooting of this add-on to the dedicated add-on thread.
     

Share This Page