Duplicate Unapprove first post erro

[Lukas W.]

Affected version

2.0.0 Beta 7

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

 

[Mike]

Are you sure you're running beta 7? This was fixed there: https://xenforo.com/community/threads/error-on-inline-moderation-unapproved-post.135501/ (And I can't reproduce it with the current code.)

Your line numbers match up with the pre-beta 7 version as there's no save() call on line 55 of the XF\InlineMod\Post any longer, so I'm going to call this a duplicate on that basis.

 

[Lukas W.]

Oh well, I actually forgot to update on one of my two devices. Sorry for that.

 

[Lukas W.]

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

 

[Mike]

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