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

XF 1.2 Server Error


New member
I'm getting the following error during step 2b... any ideas?

Mysqli statement execute error : Incorrect integer value: '' for column 'trigger_date' at row 1

  1. Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
  2. Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
  3. Zend_Db_Adapter_Abstract->query() in XenForo/Model/Deferred.php at line 113
  4. XenForo_Model_Deferred->defer() in XenForo/Application.php at line 1288
  5. XenForo_Application::defer() in XenForo/Install/Model/Install.php at line 345
  6. XenForo_Install_Model_Install->insertDeferredRebuild() in XenForo/Install/Controller/Install.php at line 227
  7. XenForo_Install_Controller_Install->actionStep2b() in XenForo/FrontController.php at line 337
  8. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
  9. XenForo_FrontController->run() in /home/faith/public_html/community/install/index.php at line 18


XenForo developer
Staff member
Searched for the error in your ticket to double check and only found your own thread as a result, so... :)

Here's what I said in the ticket.
I believe we have seen a similar error to this before, though very rarely (twice I think). Unfortunately though, I believe it's a server configuration issue and not something that we can workaround. We are sending through a query with a correct value but the MySQL server isn't getting that value as expected.

I suspect it's related to the MySQL server and the MySQL bindings in PHP being from different versions. I would say that the PHP MySQL bindings are using an older version, but I'm not positive.

It's been sometime since I've seen this before, but I think the workaround involved changing the MySQL version itself (in general, it was quite outdated) or changing the version of MySQL PHP was compiled against. I assume that you're on a shared server, so this is something your host would have to do.