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

SOS! Errors On The Site

Discussion in 'Troubleshooting and Problems' started by TheBigK, Jun 15, 2013.

  1. TheBigK

    TheBigK Well-Known Member

    Errors on the site and all of a suddent I got an email from members that the site's showing database errors. On the front page (which runs xenporta) I got the regular 'unexpected error'. The /community/ however ran fine (note: /community/ is actually directed by XenPorta, XF resides in the root).

    I quickly logged into adminCP and disabled xenporta. It brought the site back (but the forums continue to throw error). I therefore enabled xenfporta and since then getting following error on front page -

    An exception occurred: Mysqli prepare error: MySQL server has gone away in /home/<snipped>/public_html/library/Zend/Db/Statement/Mysqli.php on line 77

    1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
    2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
    3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
    4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 825
    5. Zend_Db_Adapter_Abstract->fetchOne() in XenForo/Error.php at line 48
    6. XenForo_Error::unexpectedException() in XenForo/Application.php at line 309
    7. XenForo_Application::handleException()
     
  2. TheBigK

    TheBigK Well-Known Member

  3. TheBigK

    TheBigK Well-Known Member

    Update - I force reboot the server and it seems to be back. I've no way to know. My host says -

    ... the process that seems to trip up mysql: | 4 | DELAYED | localhost | _my_site's_db | Delayed insert | 6 | Waiting for INSERT |
     
  4. Mike

    Mike XenForo Developer Staff Member

    Unfortunately, despite my best efforts, that error is actually masking the real one.

    It's likely an issue in XenPorta itself. You'd need to handle that with the author.

    Your host's comment about that process tripping up MySQL isn't correct, but you can disable the delayed inserts in XF's options if you wish.
     
  5. TheBigK

    TheBigK Well-Known Member

    Thank you for your reply, Mike. I disabled XenPorta; but the error (related to database) appeared up on the forum page. I'd believe that if the error was with XenPorta; it'd be gone with the addon-disabled.

    Do you have any suggestions on ways to investigating the cause? The error popped up on site that's running fine without issues. I'm more concerned about the error appearing with no-one touching the server or software backend.
     
  6. Mike

    Mike XenForo Developer Staff Member

    Well, if you're getting it consistently, then I can debug it if you submit a ticket with FTP details.
     
    Walter likes this.
  7. TheBigK

    TheBigK Well-Known Member

    I'm not getting it constantly. Is there anything you'd like me to do if I get the error again?

    Rebooting the server worked in my case and the host admin ran some repair operations [dumped mysql and did a report which fixed xf_session related issues]. The site's working fine now; and we're performing PHP+MySQL upgrade.
     
  8. Mike

    Mike XenForo Developer Staff Member

    Well, since the real error is annoyingly being masked, it's hard to say. (I'm not sure why in some PHP setups I can't trap that second error - we do try. Maybe an issue with older PHP versions.)
     
  9. Digital Doctor

    Digital Doctor Well-Known Member

    This is a popular error
    [list]
     
    TheBigK likes this.
  10. Digital Doctor

    Digital Doctor Well-Known Member

    It usually was associated with emails (and being over the limit).
     

Share This Page