XF 2.2 While creating nodes: MySQL query error [1364]


Active member
Hi everybody,
while trying to create a new node, this error comes up:

XF\Db\Exception: MySQL query error [1364]: Field 'post_rule' doesn't have a default value in src/XF/Db/AbstractStatement.php at line 230
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 79
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 223
XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1512
XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1244
XF\Mvc\Entity\Entity->save() in src/XF/Mvc/Entity/Entity.php at line 1262
XF\Mvc\Entity\Entity->save() in src/XF/Mvc/FormAction.php at line 71
XF\Mvc\FormAction->XF\Mvc\{closure}() in src/XF/Mvc/FormAction.php at line 189
XF\Mvc\FormAction->run() in src/XF/Admin/Controller/AbstractNode.php at line 110
XF\Admin\Controller\AbstractNode->actionSave() in src/XF/Mvc/Dispatcher.php at line 352
XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 263
XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2345
XF\App->run() in src/XF.php at line 512
XF::runApp() in admin.php at line 13
Trouble is, I cannot identify the field post_rule as I do not know the German phrase for it. So not sure where to look.
Any suggestions appreciated....
Thanks in advance!


Well-known member
post_rule is not a standard XenForo field, it was most likely added by an Add-on that violates Resource Standards rule #11, which was put in place to avoid such issues.

Check if you have any "Forum Rules" type Add-ons intalled and if so contact the author for support.

Alternatively you can try to make the field (most likely in table xf_node or xf_forum) nullable via you DB administration tool of choice (phpMyAdmin, etc.).

Auf Deutsch:
post_rule ist kein Standardfeld sondern wurde von einem Add-on hinzugefügt welches sich anscheinend nicht an die Code-Standards für Add-ons hält (Regel # 11, die ist explizit dafür da derartige Probleme zu vermeiden).

Schau mal ob Du ein Add-on "Forenregeln" oder so in der Art hast und wende dich an den Autor um Support zu erhalten.

Alternativ kannst Du das Feld (vmtl. in Tabelle xf_node oder xf_forum) auch einfach in phpMyAdmin etc. Nullable setzen.