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

XF 1.2 Out of range value for column 'alerts_unread' at row 1

Discussion in 'Troubleshooting and Problems' started by multibam, Mar 8, 2014.

  1. multibam

    multibam Member

    Have anyone experience this error message when users try to post to certain forums?

    Code:
    Mysqli statement execute error : Out of range value for column 'alerts_unread' at row 1
    I'd love to access the db with a quick fix... :confused:
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Can you post the full stack trace of the error?
    Also, which add-ons do you have installed?
    Does the error stop when you disable them all?
     
  3. NeoCHI

    NeoCHI Active Member

    I'm getting this now too!

    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Out of range value for column 'alerts_unread' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: tubthumper82, 6 minutes ago


    Stack Trace
    Code:
    #0 /home/xx/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/xx/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/xx/public_html/library/XenForo/DataWriter/Alert.php(98): Zend_Db_Adapter_Abstract->query('????UPDATE xf_u...', 1295)
    #3 /home/xx/public_html/library/XenForo/DataWriter.php(1397): XenForo_DataWriter_Alert->_postSave()
    #4 /home/xx/public_html/library/XenForo/Model/Alert.php(452): XenForo_DataWriter->save()
    #5 /home/xx/public_html/library/XenForo/Model/Alert.php(426): XenForo_Model_Alert->alertUser(1295, 5403, 'tubthumper82', 'post', 956483, 'insert', NULL)
    #6 /home/xx/public_html/library/XenForo/Model/ForumWatch.php(304): XenForo_Model_Alert::alert(1295, 5403, 'tubthumper82', 'post', 956483, 'insert')
    #7 /home/xx/public_html/library/Tinhte/XenTag/XenForo/Model/ForumWatch.php(7): XenForo_Model_ForumWatch->sendNotificationToWatchUsersOnMessage(Array, NULL, Array, Array)
    #8 /home/xx/public_html/library/bdTagMe/XenForo/Model/ForumWatch.php(9): Tinhte_XenTag_XenForo_Model_ForumWatch->sendNotificationToWatchUsersOnMessage(Array, NULL, Array, Array)
    #9 /home/xx/public_html/library/XenForo/DataWriter/DiscussionMessage/Post.php(156): bdTagMe_XenForo_Model_ForumWatch->sendNotificationToWatchUsersOnMessage(Array, NULL, Array, Array)
    #10 /home/xx/public_html/library/Tinhte/XenTag/XenForo/DataWriter/DiscussionMessage/Post.php(113): XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #11 /home/xx/public_html/library/WidgetFramework/XenForo/DataWriter/DiscussionMessage/Post.php(7): Tinhte_XenTag_XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #12 /home/xx/public_html/library/bdTagMe/XenForo/DataWriter/DiscussionMessage/Post.php(8): WidgetFramework_XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #13 /home/xx/public_html/library/XenForo/DataWriter.php(1411): bdTagMe_XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #14 /home/xx/public_html/library/Dark/TaigaChat/DataWriter/DiscussionMessage/Post.php(7): XenForo_DataWriter->save()
    #15 /home/xx/public_html/library/XenForo/DataWriter/Discussion.php(477): Dark_TaigaChat_DataWriter_DiscussionMessage_Post->save()
    #16 /home/xx/public_html/library/XenForo/DataWriter/Discussion.php(426): XenForo_DataWriter_Discussion->_saveFirstMessageDw()
    #17 /home/xx/public_html/library/XenForo/DataWriter.php(1397): XenForo_DataWriter_Discussion->_postSave()
    #18 /home/xx/public_html/library/XenForo/ControllerPublic/Forum.php(681): XenForo_DataWriter->save()
    #19 /home/xx/public_html/library/Waindigo/Thumbnails/Extend/XenForo/ControllerPublic/Forum.php(129): XenForo_ControllerPublic_Forum->actionAddThread()
    #20 /home/xx/public_html/library/Tinhte/XenTag/XenForo/ControllerPublic/Forum.php(28): Waindigo_Thumbnails_Extend_XenForo_ControllerPublic_Forum->actionAddThread()
    #21 /home/xx/public_html/library/Tac/StopHumanSpam/ControllerPublic/Forum.php(151): Tinhte_XenTag_XenForo_ControllerPublic_Forum->actionAddThread()
    #22 /home/xx/public_html/library/Tac/StopHumanSpam/ControllerPublic/Forum.php(69): Tac_StopHumanSpam_ControllerPublic_Forum->addThreadResponse(false)
    #23 /home/xx/public_html/library/XenMods/MultiPrefix/ControllerPublic/Forum.php(16): Tac_StopHumanSpam_ControllerPublic_Forum->actionAddThread()
    #24 /home/xx/public_html/library/XenForo/FrontController.php(337): XenMods_MultiPrefix_ControllerPublic_Forum->actionAddThread()
    #25 /home/xx/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #26 /home/xx/public_html/index.php(13): XenForo_FrontController->run()
    #27 {main}
    
    Request State
    Code:
    array(3) {
    ["url"] => string(58) "http://xx.com/forums/this-for-that.271/add-thread"
    ["_GET"] => array(0) {
    }
    ["_POST"] => array(11) {
    ["title"] => string(34) "This 4-7 Jabba + that 4-7 Old maul"
    ["message_html"] => string(166) "<p>I am trading my 4-7 Jabba, evo 1 droideka, base magnaguard and base c3po for a 4/7 old maul. &nbsp;I can skill any of these cards to 10 to help sweeten the pot</p>"
    ["_xfRelativeResolver"] => string(61) "http://xx.com/forums/this-for-that.271/create-thread"
    ["attachment_hash"] => string(32) "b1e0f706eec9ad803ed399a8258efc3a"
    ["watch_thread"] => string(1) "1"
    ["watch_thread_state"] => string(1) "1"
    ["poll"] => array(2) {
    ["question"] => string(0) ""
    ["responses"] => array(2) {
    [0] => string(0) ""
    [1] => string(0) ""
    }
    }
    ["_xfToken"] => string(8) "********"
    ["_xfRequestUri"] => string(39) "/forums/this-for-that.271/create-thread"
    ["_xfNoRedirect"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
    }
    }
    
    Someone please help!
     
    Last edited: Jul 3, 2014
  4. Tracy Perry

    Tracy Perry Well-Known Member

    You have several add-ons interacting together (those are in the quote). I would suggest disabling all those add-ons and then enable them one at a time until the error crops up again.
    Further, make sure you have updated those add-ons to the latest versions.

    Once you have traced it down to the appropriate add-on, then post in that resources discussion area directing a them back to your post I quoted.
     
  5. NeoCHI

    NeoCHI Active Member

    I disabled all addons that was listed in the stack trace and I'm STILL getting the errors. Here's what the stack trace looks like now after all addons are disabled:

    Code:
    #0 /home/xx/public_html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /home/xx/public_html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /home/xx/public_html/library/XenForo/DataWriter/Alert.php(98): Zend_Db_Adapter_Abstract->query('????UPDATE xf_u...', 1295)
    #3 /home/xx/public_html/library/XenForo/DataWriter.php(1397): XenForo_DataWriter_Alert->_postSave()
    #4 /home/xx/public_html/library/XenForo/Model/Alert.php(452): XenForo_DataWriter->save()
    #5 /home/xx/public_html/library/XenForo/Model/Alert.php(426): XenForo_Model_Alert->alertUser(1295, 1, 'NeoCHI', 'post', 957490, 'insert', NULL)
    #6 /home/xx/public_html/library/XenForo/Model/ForumWatch.php(304): XenForo_Model_Alert::alert(1295, 1, 'NeoCHI', 'post', 957490, 'insert')
    #7 /home/xx/public_html/library/XenForo/DataWriter/DiscussionMessage/Post.php(156): XenForo_Model_ForumWatch->sendNotificationToWatchUsersOnMessage(Array, NULL, Array, Array)
    #8 /home/xx/public_html/library/XenForo/DataWriter.php(1411): XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #9 /home/xx/public_html/library/XenForo/DataWriter/Discussion.php(477): XenForo_DataWriter->save()
    #10 /home/xx/public_html/library/XenForo/DataWriter/Discussion.php(426): XenForo_DataWriter_Discussion->_saveFirstMessageDw()
    #11 /home/xx/public_html/library/XenForo/DataWriter.php(1397): XenForo_DataWriter_Discussion->_postSave()
    #12 /home/xx/public_html/library/XenForo/ControllerPublic/Forum.php(681): XenForo_DataWriter->save()
    #13 /home/xx/public_html/library/XenForo/FrontController.php(337): XenForo_ControllerPublic_Forum->actionAddThread()
    #14 /home/xx/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #15 /home/xx/public_html/index.php(13): XenForo_FrontController->run()
    #16 {main}
    
    Please need assistance.
     
  6. Mike

    Mike XenForo Developer Staff Member

    You can run this query:

    UPDATE xf_user SET alerts_unread = 0 WHERE alerts_unread > 65000;
     
    NeoCHI likes this.
  7. NeoCHI

    NeoCHI Active Member

    Where should I run that?

    Looking at the query it looks like it'll set users with over 65k unread alerts to 0. Problem is my own account on my forum is also experiencing this issue and I don't have over 65k unread alerts...so how would that solve the issue for me?
     
  8. Mike

    Mike XenForo Developer Staff Member

    You would run that query via something like phpMyAdmin.

    What do you mean your account is experiencing it? If you just mean when posting, it's not your account with the problem. It's someone getting an alert. (User 1295 it seems, who is watching the forum you're posting into.)
     
  9. NeoCHI

    NeoCHI Active Member

    Oh so your saying one of my users (1295) has over 65k unread alerts is watching the forums I'm trying to post in which is causing this issue?
     
  10. Mike

    Mike XenForo Developer Staff Member

    Yes.
     
  11. NeoCHI

    NeoCHI Active Member

    Worked like a charm! Thanks!
     
  12. JackIsi

    JackIsi Member

    I have the same error : Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Out of range value for column 'end_date' at row 1 - library/Zend/Db/Statement/Mysqli.php:214

    #0 /var/www/html/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/html/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /var/www/html/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `xf...', Array)
    #3 /var/www/html/library/XenForo/Model/UserUpgrade.php(533): Zend_Db_Adapter_Abstract->insert('xf_user_upgrade...', Array)
    #4 /var/www/html/library/XenForo/ControllerAdmin/UserUpgrade.php(306): XenForo_Model_UserUpgrade->upgradeUser(61, Array, true, 9491731200)
    #5 /var/www/html/library/XenForo/FrontController.php(351): XenForo_ControllerAdmin_UserUpgrade->actionManual()
    #6 /var/www/html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #7 /var/www/html/admin.php(13): XenForo_FrontController->run()
    #8 {main}

    i runned the query : UPDATE xf_user SET alerts_unread = 0 WHERE alerts_unread > 65000;
    but didn't worked for me.. :( i keep getting this error when i try to upgrade a user.

    array (size=3)
    'url' => string 'http://seductivemodding.com/admin.php?user-upgrades/king-donater.4/manual' (length=73)
    '_GET' =>
    array (size=1)
    'user-upgrades/king-donater_4/manual' => string '' (length=0)
    '_POST' =>
    array (size=3)
    'username' => string 'AdvanceModding' (length=14)
    'end_date' => string '2270-10-13' (length=10)
    '_xfToken' => string '********' (length=8)
     
  13. Brogan

    Brogan XenForo Moderator Staff Member

    The error is not the same.

    In your case it is due to the end date being 2270-10-13.
     
    JackIsi likes this.
  14. JackIsi

    JackIsi Member

    Okay thanks for the information so do u know how i can easy fix this issue ?
     
  15. Brogan

    Brogan XenForo Moderator Staff Member

    What value are you entering for the end date when you manually upgrade the user?

    I just entered the same date (2270-10-13) and it upgraded and changed the date to 2039-01-19.
     
  16. JackIsi

    JackIsi Member

  17. JackIsi

    JackIsi Member

    I changed it to Permanent now it works :) thanks guys!
     

Share This Page