XF 1.3 Server error's

[Robdenio]

Hello

Could anyone help us we keep getting server error when we try and post on the forum. We have spoken to our host and they have said its msql database that needs cleaning does anyone know how this is done?

 

[Walter]

Please post the full error message.

 

[Robdenio]

Mysqli statement execute error : Out of range value for column 'alerts_unread' at row 1

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/DataWriter/Alert.php at line 98
4. XenForo_DataWriter_Alert->_postSave() in XenForo/DataWriter.php at line 1409
5. XenForo_DataWriter->save() in XenForo/Model/Alert.php at line 452
6. XenForo_Model_Alert->alertUser() in XenForo/Model/Alert.php at line 426
7. XenForo_Model_Alert::alert() in XenForo/Model/ForumWatch.php at line 310
8. XenForo_Model_ForumWatch->sendNotificationToWatchUsersOnMessage() inXenForo/DataWriter/DiscussionMessage/Post.php at line 176
9. XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction() in XenForo/DataWriter.php at line 1423
10. XenForo_DataWriter->save() in XenForo/DataWriter/Discussion.php at line 477
11. XenForo_DataWriter_Discussion->_saveFirstMessageDw() in XenForo/DataWriter/Discussion.php at line 426
12. XenForo_DataWriter_Discussion->_postSave() in XenForo/DataWriter.php at line 1409
13. XenForo_DataWriter->save() in XenForo/ControllerPublic/Forum.php at line 679
14. XenForo_ControllerPublic_Forum->actionAddThread() in XenForo/FrontController.php at line 347
15. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
16. XenForo_FrontController->run() in /home/content/13/11491013/html/index.php at line 13

 

[Mike]

See http://xenforo.com/community/thread...umn-alerts_unread-at-row-1.70065/#post-788487

 

[Robdenio]

Thank you!!

I cant believe how simple that was been pulling my hair our for weeks.