XF 1.5 DELAYED option not supported for table 'xf_thread_view'

Minecraftly

Active member
I recently migrated my database from MariaDB10 to AWS Aurora and encountered this problem. Can you guys help me fix it?

Code:
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: DELAYED option not supported for table 'xf_thread_view' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, 2 minutes ago
Stack Trace
#0 /var/www/html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\n\t\t\tINSERT DELA...')
#1 /var/www/html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\n\t\t\tINSERT DELA...')
#2 /var/www/html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\n\t\t\tINSERT DELA...')
#3 /var/www/html/library/XenForo/Model/Thread.php(2506): Zend_Db_Adapter_Abstract->query('\n\t\t\tINSERT DELA...', 1092)
#4 /var/www/html/library/XenForo/ControllerPublic/Thread.php(159): XenForo_Model_Thread->logThreadView(1092)
#5 /var/www/html/library/XenForo/FrontController.php(351): XenForo_ControllerPublic_Thread->actionIndex()
#6 /var/www/html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /var/www/html/index.php(13): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
  ["url"] => string(64) "https://forums.minecraftly.com/threads/herro-its-me-twitch.1092/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}
 
Disabled the DELAYED option under admincp options -> performance.

You can't use it with InnoDB anyway, and it is honestly a hack to workaround MyISAM's full-table lock behaviour.
 
Last edited:
Back
Top Bottom