• 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'

marremp2

Active member
#1
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
 

Brogan

XenForo moderator
Staff member
#2
I see reference to several add-ons there, notably one related to emails.

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

marremp2

Active member
#4
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}
 

Mike

XenForo developer
Staff member
#5
Please direct any further troubleshooting of this add-on to the dedicated add-on thread.