Duplicate Unapprove first post erro

Affected version
2.0.0 Beta 7

Lukas W.

Formerly katsulynx
Receiving the following error when trying to unapprove the first post of a thread:

XF\Db\Exception: MySQL query error [1264]: Out of range value for column 'position' at row 1 in src\XF\Db\AbstractStatement.php at line 183
XF\Db\AbstractStatement->getException() in src\XF\Db\Mysqli\Statement.php at line 66
XF\Db\Mysqli\Statement->execute() in src\XF\Db\AbstractAdapter.php at line 67
XF\Db\AbstractAdapter->query() in src\XF\Db\AbstractAdapter.php at line 228
XF\Db\AbstractAdapter->update() in src\XF\Mvc\Entity\Entity.php at line 1179
XF\Mvc\Entity\Entity->fastUpdate() in src\XF\Entity\Post.php at line 617
XF\Entity\Post->postHidden() in src\XF\Entity\Post.php at line 421
XF\Entity\Post->_postSave() in src\XF\Mvc\Entity\Entity.php at line 1109
XF\Mvc\Entity\Entity->save() in src\XF\InlineMod\Post.php at line 55
XF\InlineMod\Post->XF\InlineMod\{closure}() in src\XF\InlineMod\SimpleAction.php at line 79
XF\InlineMod\SimpleAction->applyToEntity() in src\XF\InlineMod\AbstractAction.php at line 87
XF\InlineMod\AbstractAction->applyInternal() in src\XF\InlineMod\AbstractAction.php at line 80
XF\InlineMod\AbstractAction->apply() in src\XF\Pub\Controller\InlineMod.php at line 131
XF\Pub\Controller\InlineMod->actionPerform() in src\XF\Mvc\Dispatcher.php at line 249
XF\Mvc\Dispatcher->dispatchClass() in src\XF\Mvc\Dispatcher.php at line 89
XF\Mvc\Dispatcher->dispatchLoop() in src\XF\Mvc\Dispatcher.php at line 41
XF\Mvc\Dispatcher->run() in src\XF\App.php at line 1831
XF\App->run() in src\XF.php at line 328
XF::runApp() in index.php at line 13

Lukas W.

Formerly katsulynx
Unapproving works now. However, approving it won't approve the whole thread - so it effectively does nothing. Is that by design?


XenForo developer
Staff member
More or less. It'd be the same in XF 1. You'd choose to approve the thread.