XF 1.5 Server Error on logout

[Baron]

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?

 

[Mike]

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

 

[Baron]

Ok, no problem. Thanks.