What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

  • This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.
  • We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

Bug Fixed Mysqli statement execute error : Field 'automation_id' doesn't have a default value

Running a new install. I get the following error any time I make a new post, or try to enable thread automation for a thread:

Mysqli statement execute error : Field 'automation_id' doesn't have a default value

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in XFA/ThreadAutomation/Model/ThreadAutomation.php at line 40
XFA_ThreadAutomation_Model_ThreadAutomation->addAction() in XFA/ThreadAutomation/Model/ThreadAutomation.php at line 47
XFA_ThreadAutomation_Model_ThreadAutomation->addActions() in XFA/ThreadAutomation/Extends/ControllerPublic/Forum.php at line 102
XFA_ThreadAutomation_Extends_ControllerPublic_Forum->actionAddThread() in XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 134
XenForo_FrontController->run() in /home/xxx/public_html/community/index.php at line 13

Of course, adding a default value to automation_id (I just used 1) fixes the issue, but I'm not sure that's really the permanent fix I'm looking for.

Any ideas?


Freaky Coder
Staff member

Indeed there is an issue it should be an autoincremented field.
The install code has a bug.

For now I recommend you uninstall it and wait till I release a bug fix version tomorrow.