XF\Db\InvalidQueryException | Error moving page to another area
XF\Db\InvalidQueryException: 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:212
Generiert von: hollosch 4. Januar 2019 um 10:02
Stack-Trace
SELECT pageid FROM `vw_page` WHERE areaid =
------------
#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(79): XF\Db\Mysqli\Statement->execute()
#4 src/addons/vw/vw/_core/controller/db/xf2.php(203): XF\Db\AbstractAdapter->query('SELECT pageid F...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(25): vw_DB_Controller_XF2->query_first('SELECT pageid F...')
#6 src/addons/vw/vw/_core/controller/dm/page/vw.php(111): vw_DB_MySQL_Model->select(Array)
#7 src/addons/vw/vw/_core/controller/dm/page/xf2.php(101): vw_DM_Page_Controller->verify_areaid(NULL)
#8 [internal function]: vw_DM_Page_Controller_XF2->verify_areaid(NULL, 'areaid', 2, Array, Object(vw_DM_Page_Controller_XF2))
#9 src/XF/Mvc/Entity/Entity.php(717): call_user_func_array(Array, Array)
#10 src/XF/Mvc/Entity/Entity.php(570): XF\Mvc\Entity\Entity->_verifyValueCustom(NULL, 'areaid', 2, Array)
#11 src/addons/vw/vw/XF/Entity/Entity.php(356): XF\Mvc\Entity\Entity->set('areaid', NULL, Array)
#12 src/addons/vw/vw/_core/controller/dm/xf2.php(197): vw\vw\XF\Entity\Entity->set('areaid', NULL)
#13 src/addons/vw/vw/_core/controller/ui/imod/action/move/vw.php(100): vw_DM_Controller_XF2->set('areaid', NULL)
#14 src/addons/vw/vw/_core/controller/ui/imod/action/move/vw.php(87): vw_UI_iMod_Action_Move_Controller->process_move_type(Array, Array)
#15 src/addons/vw/vw/_core/controller/ui/imod/action/base/vw.php(91): vw_UI_iMod_Action_Move_Controller->perform_domove()
#16 src/addons/vw/vw/Handler/InlineMod/Base/AbstractAction.php(183): vw_UI_iMod_Action_base_Controller->process('domove')
#17 src/XF/InlineMod/AbstractAction.php(87): vw\vw\Handler\InlineMod\Base\AbstractAction->applyToEntity(Object(vw_DM_Page_Controller_XF2), Array)
#18 src/XF/InlineMod/AbstractAction.php(80): XF\InlineMod\AbstractAction->applyInternal(Object(XF\Mvc\Entity\ArrayCollection), Array)
#19 src/XF/Pub/Controller/InlineMod.php(131): XF\InlineMod\AbstractAction->apply(Object(XF\Mvc\Entity\ArrayCollection), Array)
#20 src/addons/vw/vw/XF/Pub/Controller/InlineMod.php(41): XF\Pub\Controller\InlineMod->actionPerform()
#21 src/XF/Mvc/Dispatcher.php(249): vw\vw\XF\Pub\Controller\InlineMod->actionPerform(Object(XF\Mvc\ParameterBag))
#22 src/XF/Mvc/Dispatcher.php(88): XF\Mvc\Dispatcher->dispatchClass('XF:InlineMod', 'Perform', 'json', Object(XF\Mvc\ParameterBag), '', Object(vw\vw\XF\Pub\Controller\InlineMod), NULL)
#23 src/XF/Mvc/Dispatcher.php(41): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#24 src/XF/App.php(1934): XF\Mvc\Dispatcher->run()
#25 src/XF.php(333): XF\App->run()
#26 index.php(13): XF::runApp('XF\\Pub\\App')
#27 {main}
Status der Anfrage
array(4) {
["url"] => string(19) "/inline-mod/perform"
["referrer"] => string(34) "https://regio-portal.wiki/wiki/KKP"
["_GET"] => array(0) {
}
["_POST"] => array(11) {
["toarea"] => string(1) "4"
["returnid"] => string(4) "3235"
["returntype"] => string(1) "1"
["ids"] => array(1) {
[10000000003235] => string(14) "10000000003235"
}
["type"] => string(6) "vwpage"
["action"] => string(4) "move"
["confirmed"] => string(1) "1"
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(9) "/wiki/KKP"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}