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

[Bryan Wollenberg]

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?

 

[Clement]

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

 

[Clement]

Posting the new version right now