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

XF 1.5 Server Error on logout

Discussion in 'Troubleshooting and Problems' started by Baron, Jul 21, 2016.

  1. Baron

    Baron Member

    I just moved my xf installation from a self-hosted solution to Google's Cloud SQL service, which is MySql 5.6 based. Everything is working fine except for one thing. There's a server error when users try to log out:

    Error Info
    Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables. - library/Zend/Db/Statement/Mysqli.php:214
    Generated By: Covertibility, 20 minutes ago
    Stack Trace
    #0 /var/www/www.elitetrader.com/public/et/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
    #1 /var/www/www.elitetrader.com/public/et/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
    #2 /var/www/www.elitetrader.com/public/et/library/Zend/Db/Adapter/Abstract.php(661): Zend_Db_Adapter_Abstract->query('DELETE FROM `xf...')
    #3 /var/www/www.elitetrader.com/public/et/library/XenForo/Model/Session.php(487): Zend_Db_Adapter_Abstract->delete('xf_session_acti...', '(user_id = 1830...')
    #4 /var/www/www.elitetrader.com/public/et/library/XenForo/ControllerPublic/Logout.php(44): XenForo_Model_Session->processLastActivityUpdateForLogOut(18306)
    #5 /var/www/www.elitetrader.com/public/et/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Logout->actionIndex()
    #6 /var/www/www.elitetrader.com/public/et/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
    #7 /var/www/www.elitetrader.com/public/et/index.php(13): XenForo_FrontController->run()
    #8 {main}
    Request State
    array(3) {
    ["url"] => string(108) "http://www.elitetrader.com/et/logou...2004,42c5c08f207c3690aac6406121be1bfe960fb12a"
    ["_GET"] => array(1) {
    ["_xfToken"] => string(57) "18306,1469112004,42c5c08f207c3690aac6406121be1bfe960fb12a"
    }
    ["_POST"] => array(0) {
    }
    }


    Any suggestions?
     
  2. Mike

    Mike XenForo Developer Staff Member

    You may need to change xf_session_activity to InnoDB due to this extra constraint.
     
  3. Baron

    Baron Member

    Ok, no problem. Thanks. (y)
     

Share This Page