Trying to promote a page to a feed
Inverse problem now
When I am on a page I want to add to a feed, I go to "promote to a feed"
I type the start of my feed name in the box
No suggestion options appear
If I try and manually enter the full feed name I get unexpected error.
In the admin log:
XF\Db\InvalidQueryException: MySQL statement prepare error [1064]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND contenttypeid = 1 AND contentid = 1493' at line 1 src/XF/Db/AbstractStatement.php:230
Generated by: Raigryn Vayd Dec 1, 2021 at 2:43 PM
Stack trace
SELECT * FROM `xf_vw_feeditem` WHERE `itemfeedid` IN () AND contenttypeid = 1 AND contentid = 1493
------------
#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1064, '42000')
#1 src/XF/Db/Mysqli/Statement.php(41): 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/addons/vw/vw/_core/controller/db/xf2.php(170): XF\Db\AbstractAdapter->query('SELECT * FROM `...')
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(25): vw_DB_Controller_XF2->query_read('SELECT * FROM `...')
#6 src/addons/vw/vw/_core/controller/ui/assign/feed/vw.php(177): vw_DB_MySQL_Model->select(Array)
#7 src/addons/vw/vw/_core/controller/ui/assign/feed/vw.php(104): vw_UI_Assign_Feed_Controller->prepare_parents(Object(vw_UI_Page_Controller), Array, Array)
#8 src/addons/vw/vw/_core/controller/ui/assign/vw.php(62): vw_UI_Assign_Feed_Controller->start_assignments(Object(vw_UI_Page_Controller), Array, Array)
#9 src/addons/vw/vw/_core/controller/ui/page/vw.php(786): vw_UI_Assign_Controller->do_assign(Object(vw_UI_Page_Controller))
#10 src/addons/vw/vw/_core/controller/ui/page/vw.php(192): vw_UI_Page_Controller->do_assign()
#11 src/addons/vw/vw/_core/controller/ui/stack/vw.php(295): vw_UI_Page_Controller->execute()
#12 src/addons/vw/vw/Pub/Controller/Wiki/Wiki.php(80): vw_UI_Stack_Controller->execute()
#13 src/addons/vw/vw/Mvc/Dispatcher.php(30): vw\vw\Pub\Controller\Wiki\Wiki->_actionIndex(Object(XF\Mvc\ParameterBag))
#14 src/addons/vw/vw/Pub/Controller/Wiki/AbstractController.php(26): vw\vw\Mvc\Dispatcher::dispatch(Object(vw\vw\Pub\Controlle r\Wiki\Wiki), 'index', Object(XF\Mvc\ParameterBag))
#15 src/XF/Mvc/Dispatcher.php(352): vw\vw\Pub\Controller\Wiki\AbstractController->actionIndex(Object(XF\Mvc\ParameterBag))
#16 src/XF/Mvc/Dispatcher.php(259): XF\Mvc\Dispatcher->dispatchClass('\\vw\\vw\\Pub\\Cont...', 'Index', Object(XF\Mvc\RouteMatch), Object(vw\vw\Pub\Controller\Wiki\Wiki), NULL)
#17 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(vw\vw\Pub\Controller\Wiki\Wiki), NULL)
#18 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#19 src/XF/App.php(2345): XF\Mvc\Dispatcher->run()
#20 src/XF.php(512): XF\App->run()
#21 index.php(20): XF::runApp('XF\\Pub\\App')
#22 {main}
Request state
array(4) {
["url"] => string(45) "/Folklore/Siege-of-Cregsbend-Castle?do=assign"
["referrer"] => string(70) "https://chroniclesrp.net/Folklore/Siege-of-Cregsbend-Castle?do=promote"
["_GET"] => array(2) {
["/Folklore/Siege-of-Cregsbend-Castle"] => string(0) ""
["do"] => string(6) "assign"
}
["_POST"] => array(8) {
["feedtype"] => string(1) "1"
["query"] => string(27) "Timeline Event Article Feed"
["feedids"] => array(1) {
[0] => string(0) ""
}
["assigntype"] => array(1) {
[0] => string(4) "feed"
}
["_xfToken"] => string(8) "********"
["_xfRequestUri"] => string(46) "/Folklore/Siege-of-Cregsbend-Castle?do=promote"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}