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

XF 1.5 DELAYED option not supported for table 'xf_thread_view'

Discussion in 'Troubleshooting and Problems' started by Minecraftly, May 25, 2016.

  1. Minecraftly

    Minecraftly 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) {
      }
    }
     
  2. Xon

    Xon Well-Known Member

    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: May 25, 2016
    Minecraftly likes this.

Share This Page