XF\Db\InvalidQueryException: Batch install error: MySQL statement prepare error [1064]: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 1 src/XF/Db/AbstractStatement.php:230
Generated by: ozzy47 Feb 12, 2024 at 4:39 PM
Stack trace
UPDATE `xf_xcpm_project_task` SET `task_status` = ? WHERE project_task_id in ()
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1064, '42000')
#1 src/XF/Db/Mysqli/Statement.php(40): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1064, '42000')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(323): XF\Db\AbstractAdapter->query('UPDATE `xf_xcp...', Array)
#5 src/addons/XenConcept/ProjectManager/Setup.php(285): XF\Db\AbstractAdapter->update('xf_xcpm_project...', Array, 'project_task_id...')
#6 src/XF/AddOn/StepRunnerUpgradeTrait.php(124): XenConcept\ProjectManager\Setup->upgrade2020091Step3(Array)
#7 src/XF/AddOn/StepRunnerUpgradeTrait.php(73): XenConcept\ProjectManager\Setup->upgradeStepRunner(2020091, 3, Array, NULL)
#8 src/XF/Job/AddOnInstallBatch.php(299): XenConcept\ProjectManager\Setup->upgrade(Array)
#9 src/XF/Job/AddOnInstallBatch.php(91): XF\Job\AddOnInstallBatch->stepAction(Object(XF\Timer))
#10 src/XF/Job/Manager.php(260): XF\Job\AddOnInstallBatch->run(8)
#11 src/XF/Job/Manager.php(202): XF\Job\Manager->runJobInternal(Array, 8)
#12 src/XF/Job/Manager.php(118): XF\Job\Manager->runJobEntry(Array, 8)
#13 src/XF/Admin/Controller/Tools.php(122): XF\Job\Manager->runByIds(Array, 8)
#14 src/XF/Mvc/Dispatcher.php(352): XF\Admin\Controller\Tools->actionRunJob(Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('XF:Tools', 'RunJob', Object(XF\Mvc\RouteMatch), Object(OzzModz\GranAdminPerms\XF\Admin\Controller\Tools), NULL)
#16 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(OzzModz\GranAdminPerms\XF\Admin\Controller\Tools), NULL)
#17 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#18 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#19 src/XF.php(524): XF\App->run()
#20 admin.php(13): XF::runApp('XF\\Admin\\App')
#21 {main}
Request state
array(4) {
["url"] => string(24) "/admin.php?tools/run-job"
["referrer"] => string(57) "https://development.com/admin.php?tools/run-job"
["_GET"] => array(1) {
["tools/run-job"] => string(0) ""
}
["_POST"] => array(3) {
["_xfRedirect"] => string(94) "https://development.com/admin.php?add-ons/install-from-archive-complete&batch_id=341"
["_xfToken"] => string(8) "********"
["only_ids"] => string(5) "10646"
}
}