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

laggy, double post in one section only

Discussion in 'Troubleshooting and Problems' started by Brandon Sheley, Feb 15, 2012.

  1. Brandon Sheley

    Brandon Sheley Well-Known Member

    I've been trying to figure out a problem I'm having on one of my forums and it seems to only happen in one section which is really weird.
    http://general-forums.com/forums/general-discussions.20/
    I've already removed the nicer style we're using and changed the color on the default one.
    I've also removed damn near all the mods I did have, these are what we're currently running

    LeafNet Blog 1.0.0 Beta 3
    Simple Sitemap 1.02
    Stop Forum Spam v1.0.1
    Tapatalk 1.1.1
    XF Arcade 0.0.2
    [8wayRun.Com] XenMedio (Media) 1.3.7
    [8wayRun.Com] XenPorta (Portal) 1.5.0
    [bd] Tag Me 1.0

    I've ran the file check and everything comes back clear, I also recently upgraded and we're still getting reports.
    I've checked the forum premissions and everything should be good.

    What happens, and it may only be doing the quick reply..
    is when a post is made, we see the loading bar at the top right and the site just hangs.
    Sometimes if a user hits refresh or submit again, thinking it didn't go through, it double post.


    So if anyone has any ideas, I'm game?

    Thanks
    -Brandon
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Check your error log:

    Admin CP -> Tools -> Server Error Log

    Anything?

    I have seen this problem be the result of a failed SMTP connection. Posting a reply can trigger notification emails to be sent. If the SMTP connection is failing then it can manifest as posting lag, but only in threads that have email subscribers.
     
  3. Brandon Sheley

    Brandon Sheley Well-Known Member

    I see several of these errors

    1. Mysqli statement execute error : Prepared statement needs to be re-prepared Today at 7:07 AM - library/Zend/Db/Statement/Mysqli.php:214
    2. Delete...
      Mysqli prepare error: Unknown column 'session.session_id' in 'order clause' Today at 6:51 AM - library/Zend/Db/Statement/Mysqli.php:77
    Also I just checked my email settings and they are the same as my other forum and AFAIK have been working correctly.
     
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    This is a server problem. See this thread:

    http://xenforo.com/community/threads/error-on-install.17901/

    Does the stack trace for the error indicate that it is from a posting attempt? If the error happens when making a post then that may explain the original problem.

    Can you post the full error including stack trace?
     
  5. Brandon Sheley

    Brandon Sheley Well-Known Member

    How would I find that?

    Thanks
     
  6. DRE

    DRE Well-Known Member

    I've had the same issue too. I thought it was server-related.
     
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Admin CP -> Tools -> Server Error Log

    Click on an error and it will reveal the full stack trace.
     
  8. Brandon Sheley

    Brandon Sheley Well-Known Member

    Thanks.

    Code:
    #0 /home/genforms/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT gam...')
    #1 /home/genforms/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT gam...')
    #2 /home/genforms/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT gam...')
    #3 /home/genforms/public_html/library/XenForo/Model.php(218): Zend_Db_Adapter_Abstract->query('?????SELECT gam...', Array, 2)
    #4 /home/genforms/public_html/library/Arcade/Model/Game.php(201): XenForo_Model->fetchAllKeyed('?????SELECT gam...', 'game_id')
    #5 /home/genforms/public_html/library/Arcade/Model/Game.php(225): Arcade_Model_Game->getGames(Array, Array)
    #6 /home/genforms/public_html/library/Arcade/ControllerPublic/ArcadeUgly.php(109): Arcade_Model_Game->getGame(Array, Array)
    #7 /home/genforms/public_html/library/XenForo/FrontController.php(310): Arcade_ControllerPublic_ArcadeUgly->actionCoreBurn()
    #8 /home/genforms/public_html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #9 /home/genforms/public_html/index.php(13): XenForo_FrontController->run()
    #10 {main}
     
  9. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    I see an "Arcade" addon in the trace. Try disabling that addon to see if it fixes the error.
     
    Brandon Sheley likes this.
  10. Brandon Sheley

    Brandon Sheley Well-Known Member

    Thanks Jake,

    I disabled the arcade and everything seems to be running smooth.
    I'll check to see if there was an upgrade out that I may of missed.

    Thanks again!
     
  11. Shelley

    Shelley Well-Known Member

    If i'm correct i'm on the same server as you and the members, myself have been experiencing the same issues. I put it down to the e-mail transport method option i was using and moved it back to default which seems to have fixed it. Then again, I've hardly posted at my forum to give this a thorough test and eliminate that as the cause.
     
    Brandon Sheley likes this.
  12. mrGTB

    mrGTB Well-Known Member

    Your not on the the same server host as AWS by chance? I pointed out to him last week at Admin Addict, that when making posts at times, or even editing them. They hang sometimes after hitting submit, you have to do a hard refresh to see it was actually submitted and posted. Otherwise you'll get a double post if you hit the submit button again while hanging and it get displayed right away the second time around. He uses IPB though, not XenForo. So just wondering if he might also be on the same server host as you Brandon, seeing as your both from the states.

    The problem sounds very similar and doesn't happen with every posts either. Very hit and miss!

    EDIT: Ah! I see it was solved, game add-on causing it.
     
  13. DRE

    DRE Well-Known Member

  14. Brandon Sheley

    Brandon Sheley Well-Known Member

    So I haven't changed anything on the site in months and now users are hitting this error again.
    Our host did have some downtime the last 2 days, so I'm not sure if something was broken during that?

    Code:
    Server Error Log
    Error Info
    Zend_Mail_Protocol_Exception: Connection timed out - library/Zend/Mail/Protocol/Abstract.php:277
    Generated By: Brandon, Today at 5:04 PM
    Stack Trace
     
    #0 /home/genforms/public_html/library/Zend/Mail/Protocol/Smtp.php(167): Zend_Mail_Protocol_Abstract->_connect('tcp://mail.gene...')
    #1 /home/genforms/public_html/library/Zend/Mail/Transport/Smtp.php(199): Zend_Mail_Protocol_Smtp->connect()
    #2 /home/genforms/public_html/library/Zend/Mail/Transport/Abstract.php(348): Zend_Mail_Transport_Smtp->_sendMail()
    #3 /home/genforms/public_html/library/Zend/Mail.php(1194): Zend_Mail_Transport_Abstract->send(Object(Zend_Mail))
    #4 /home/genforms/public_html/library/XenForo/Mail.php(170): Zend_Mail->send()
    #5 /home/genforms/public_html/library/XenForo/Mail.php(145): XenForo_Mail->sendMail(Object(Zend_Mail))
    #6 /home/genforms/public_html/library/XenForo/Mail.php(197): XenForo_Mail->send('ekkehard@ekkeha...', 'Monster', Array, '', '', '')
    #7 /home/genforms/public_html/library/XenForo/Model/ThreadWatch.php(234): XenForo_Mail->queue('ekkehard@ekkeha...', 'Monster')
    #8 /home/genforms/public_html/library/XenForo/DataWriter/DiscussionMessage/Post.php(108): XenForo_Model_ThreadWatch->sendNotificationToWatchUsersOnReply(Array, NULL, Array)
    #9 /home/genforms/public_html/library/bdTagMe/DataWriter/DiscussionMessagePost.php(110): XenForo_DataWriter_DiscussionMessage_Post->_postSaveAfterTransaction()
    #10 /home/genforms/public_html/library/XenForo/DataWriter.php(1399): bdTagMe_DataWriter_DiscussionMessagePost->_postSaveAfterTransaction()
    #11 /home/genforms/public_html/library/XenForo/ControllerPublic/Thread.php(504): XenForo_DataWriter->save()
    #12 /home/genforms/public_html/library/XenForo/FrontController.php(310): XenForo_ControllerPublic_Thread->actionAddReply()
    #13 /home/genforms/public_html/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #14 /home/genforms/public_html/index.php(13): XenForo_FrontController->run()
    #15 {main}
     
    Request State
     
    array(3) {
      ["url"] => string(49) "http://general-forums.com/threads/35358/add-reply"
      ["_GET"] => array(0) {
      }
      ["_POST"] => array(8) {
        ["message_html"] => string(15) "<p>test....</p>"
        ["_xfRelativeResolver"] => string(40) "http://general-forums.com/threads/35358/"
        ["attachment_hash"] => string(32) "ade24a7b5494a2c1bd66178a90f05d74"
        ["last_date"] => string(10) "1333165973"
        ["_xfToken"] => string(53) "1,1333209797,e5f8af55c7516a10cdcd2cdedec271638014dfc7"
        ["_xfRequestUri"] => string(15) "/threads/35358/"
        ["_xfNoRedirect"] => string(1) "1"
        ["_xfResponseType"] => string(4) "json"
      }
    }
    
    any ideas?
     
  15. mrGTB

    mrGTB Well-Known Member

    Curious looking at your code posted, what gives with the strange email address listed two times.

     
  16. Shelley

    Shelley Well-Known Member

    Have you tried (I mentioned previously) changing the e-mail transport method back to default? this was an issue I was getting and to be honest it's really quite irritating considering all registrations (signing up through gmail) the e-mails are being sent into the spam folder.

    That said, whenever I had it set to Smtp to counteract the sending of regged e-mails being sent to spam I got the server timeout and people thinking their posts never submitted thus they submitted again causing the double posting I saw.
     
    Brandon Sheley likes this.
  17. mrGTB

    mrGTB Well-Known Member

    I don't understand why people tend to use SMTP and Gmail over using default PHP mail myself. What I do is create a web-server forwarding email address in cPanel called for example: "admin@domain.com", then all mail sent on forum to admin@domain.com goes directly to my own Hotmail address instantly using PHP mail method.
     
  18. Brandon Sheley

    Brandon Sheley Well-Known Member

    I changed that one forum back to default and everything seems to be working correctly.
    It's weird that I have 2 forums with basically the same settings, and this one fails out of no where.. I'm guess it has something to do with the recent downtime..

    Thanks as always everyone for the help :)
     
  19. mrGTB

    mrGTB Well-Known Member

    Your probably better contacting them first explaining the forum was working perfect until the server issues started, and things have not been right since. They've not updated PHP version have they to latest one recently released and talked about here in a few threads?
     
  20. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Just to confirm... this is a failed SMTP connection. That explains the lag when posting.
     

Share This Page