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

Triple Posting and slow query

Discussion in 'Troubleshooting and Problems' started by RobinHood, Jul 16, 2011.

  1. RobinHood

    RobinHood Well-Known Member

    I've had an issue one someone tripple posting and on the same day a couple of users complaining about speed.

    I figured it may be to do with my server location? It's in Dallas, TX but most of our users are UK and Belgium based.

    I didn't know if the server is more to do with this and if moving it might help resolve the issue?

    My hosting company asked me to carry out a tracert which returned the following. They picked up that after 11 there's a pretty big increase and suggested moving my server might rectify this, but would it help speed the site up?

    tracert -d -w 30
    Tracing route to over a maximum of 30 hops
    1 1 ms 1 ms 1 ms
    2 23 ms * 45 ms
    3 24 ms 24 ms 24 ms
    4 22 ms 23 ms 26 ms
    5 24 ms 25 ms 23 ms
    6 23 ms 37 ms 25 ms
    7 24 ms 26 ms 26 ms
    8 24 ms 27 ms 25 ms
    9 64 ms 29 ms 32 ms
    10 34 ms * 30 ms
    11 37 ms 34 ms 32 ms
    12 104 ms 105 ms 106 ms
    13 99 ms * 102 ms
    14 129 ms 130 ms 134 ms
    15 144 ms * 144 ms
    16 133 ms 136 ms 139 ms
    17 134 ms * 137 ms
    18 135 ms 138 ms 137 ms
    19 137 ms * 138 ms
    20 135 ms 139 ms 136 ms
    21 138 ms * 138 ms
    Trace complete.

    TBH it's not a lot of money to get the site site moved to a server in London, but I was curious as to if you guys thought it would actually help and I thought through spam prevention features double/triple posting couldn't happen due to users not being able to post within so many seconds of a post?

    Any advice appreciated :)
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    I believe the nature of your problem is that the browser isn't receiving a response before javascript times out, so the request is submitted again. That might result in double posts. An unreliable server connection can cause this breakdown in communication between client and server.

    If the poor connection is a problem of geography then moving your server will probably fix this.

    You can also try to work around the problem. If you increase the flood check that may prevent double posting in this circumstance:

    Admin CP -> Home -> Options -> Messages -> Minimum Time Between Messages (Seconds)

    But users with this permission may still have the problem (probably admins and mods):

    Admin CP -> Users -> List User Groups -> [click a group] -> Bypass flood check
    Brett Peters and RobinHood like this.
  3. RobinHood

    RobinHood Well-Known Member

    Ahh, thanks for the info Jake. Looks like it was another admin and so they have the flood check bypassed. If I turn that off does it simply restrict us to the same time limit as everyone else as specified in the message options, say 30 seconds?
  4. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    RobinHood likes this.
  5. RobinHood

    RobinHood Well-Known Member

    Okay cool, ta :)
  6. RobinHood

    RobinHood Well-Known Member

    I was just posting something on my forum and it was taking ages then this error came up

    So I submitted the post again, same thing happened.

    So I refreshed the page and both posts has been successfully submitted.

    Any idea what the error means and if it's likely to do with my server or xenforo?
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Is there any pattern to this error or is it intermittent?

    An internal server error is something different. Anything in the logs?

    Admin CP -> Tools -> Server Error Log

    Otherwise you will need to check the logs on the server itself to see if they contain any useful information about the error.
  8. RobinHood

    RobinHood Well-Known Member

    Intermittent, will do, the entire site has just broken as the MySQL is down according the control panel with my host so I'm guessing it's a server issue...will check the logs once it's back up
  9. Dean

    Dean Well-Known Member

    I took the liberty of looking up your domain, it appears you are on shared hosting with many other sites.

    I was also on shared hosting 2 years ago, at The Planet via Hostgator, and things were problematic at best.
  10. RobinHood

    RobinHood Well-Known Member

    Indeed I am, I'm on the $14 a month package from here. I've contacted the hosts to see what they think about the server issues. Do you think I may have to change my plan?

    Hmmm...got 21 pages of server error logs. All from the chatbox on July 6th though so nothing recent. Is there an easy way to clear them all, I can't see a button?
  11. Dean

    Dean Well-Known Member

    I've no idea... depends on many things I have no knowledge of. Since you are here asking about the triple posting, the thought may have already been on your mind.

    I can say that I am delighted we got a vps.
  12. RobinHood

    RobinHood Well-Known Member

    Hmmm....maybe someone who knows about more about this can possibly advise me of the benefits of doing thing or if they think I should?
    I've never had any real issues with the shared hosting, but it's only a few very basic static sites that are also hosted there, maybe I should research a VPS, I hadn't really planned on $50 a month outlay just for hosting though :(
  13. RobinHood

    RobinHood Well-Known Member

    This is the reply I received from them, lets see what happens :)
    Dean likes this.
  14. Barnes

    Barnes Member

    Did this help? I am having similiar issues on slow query and double ,triple posting
  15. RobinHood

    RobinHood Well-Known Member

    Not had lots of issues since, but it's not a very active forum. I did have another user who should be flood check moderated quintuple post the other day which is odd.

    I think it might be to do with my hosting though, I'm going to migrate to a VPS this week and share it with a mate to see if that helps.
  16. kforo

    kforo Active Member

    I've deleted somewhere north of a hundred, (2 all the way to 6) duplicate posts from a number of users in the last week or so. I'm on a VPS. Floodcheck bypass is set to never.
  17. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    If not a flood check then perhaps some kind of server issue such as a spotty connection or proxy that initiates multiple requests. Have you noticed any connection problems with your forum lately? Do you have another server you can test?
  18. kforo

    kforo Active Member

    I've talked to my host and they tweaked a few things, but said things are good on their end and blame the software. No other server to test
  19. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

Share This Page