UPDATE `xf_vw_chapterorder` SET `displayorder` = (@new_chapter_order := @new_chapter_order + 10) WHERE rootid = ORDER BY displayorder ASC
------------
#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL statement...', 1064, '42000')
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1064, '42000')
#2 src/XF/Db/Mysqli/Statement.php(54): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#4 src/addons/vw/vw/_core/controller/db/xf2.php(117): XF\Db\AbstractAdapter->query('UPDATE `xf_vw_...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(1386): vw_DB_Controller_XF2->query_write('UPDATE `xf_vw_...')
#6 src/addons/vw/vw/_core/model/db/mysql/vw.php(983): vw_DB_MySQL_Model->shutdown_or_run('UPDATE `xf_vw_...', false)
#7 src/addons/vw/vw/_core/controller/dm/item/chapter/vw.php(844): vw_DB_MySQL_Model->update(Array)
#8 src/addons/vw/vw/_core/controller/dm/vw.php(135): vw_DM_Item_Chapter_Controller->delete_multiple(Array)
#9 src/addons/vw/vw/_core/model/cron/deferred/node/vw.php(403): vw_DM_Controller->delete_multiple(Array)
#10 src/addons/vw/vw/_core/model/cron/deferred/node/vw.php(115): vw_Cron_Deferred_Node_Model->delete(Array)
#11 src/addons/vw/vw/_core/model/cron/deferred/vw.php(64): vw_Cron_Deferred_Node_Model->run(Array)
#12 src/addons/vw/vw/Handler/Job/Defer.php(30): vw_Cron_Deferred_Model->exec()
#13 src/XF/Job/Manager.php(258): vw\vw\Handler\Job\Defer->run(7.99332)
#14 src/addons/Hampel/JobRunner/XF/Job/Manager.php(87): XF\Job\Manager->runJobInternal(Array, 7.99332)
#15 src/XF/Job/Manager.php(200): Hampel\JobRunner\XF\Job\Manager->runJobInternal(Array, 7.99332)
#16 src/addons/Hampel/JobRunner/XF/Job/Manager.php(80): XF\Job\Manager->runJobEntry(Array, 7.99332)
#17 src/XF/Job/Manager.php(84): Hampel\JobRunner\XF\Job\Manager->runJobEntry(Array, 7.99332)
#18 src/addons/Hampel/JobRunner/XF/Job/Manager.php(24): XF\Job\Manager->runQueue(false, 8)
#19 job.php(43): Hampel\JobRunner\XF\Job\Manager->runQueue(false, 8)
#20 {main}