• 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

Bryan Wollenberg

New Member
Joined
Dec 1, 2016
Messages
1
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?
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
5,414
Hello,

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.

Clément
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
5,414
Posting the new version right now