AbstractStatement.php:228

Issue Tools
- View Changes

November 13, 2020 5:23 PM

hollosch

Senior Member

XF\Db\Exception: Error rendering template admin:vw_cp.less: MySQL statement prepare error [1146]: Table 'regio-portal.xf_vw_reactions' doesn't exist src/XF/Db/AbstractStatement.php:228

XF\Db\Exception: Error rendering template admin:vw_cp.less: MySQL statement prepare error [1146]: Table 'regio-portal.xf_vw_reactions' doesn't exist src/XF/Db/AbstractStatement.php:228
Generiert von: Unbekanntes Konto 13. November 2020 um 23:19
Stack-Trace
SELECT `di`.*,`l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*,`index`.*, `iplog2`.`ip` AS `ipaddress`,`iplog`.`ip` AS `creatorip`,`likes`.`reactions`,`likes`.`reaction_users`, `di`.`userid` AS `disambig_userid`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`t`.`discussionid` AS `discussionid`,`t`.`comments` AS `commentcount`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`r`.`parentid` AS `edit_parentid`,`index`.`pageid`,`index`.`title` AS `title` FROM `xf_vw_index` `index` LEFT JOIN `xf_vw_page` `page` ON (`page`.`pageid` = `index`.`pageid`)
LEFT JOIN `xf_vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1)
LEFT JOIN `xf_vw_counter` `c` ON (`c`.`routeid` = `i`.`routeid`)
LEFT JOIN `xf_vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`)
LEFT JOIN `xf_vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`)
LEFT JOIN `xf_vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`)
LEFT JOIN `xf_vw_disambigitem` `di` ON (`page`.`pageid` = `di`.`contentid` AND `di`.`contenttypeid` = 1)
LEFT JOIN `xf_vw_discussion` `t` ON (`t`.`contentid` = `page`.`pageid` AND `t`.`displayorder` = 0 AND `t`.`contenttypeid` = 1)
LEFT JOIN `xf_vw_reactions` `likes` ON (`likes`.`itemtypeid` = 1 AND `likes`.`itemid` = `page`.`pageid`)
LEFT JOIN `xf_ip` `iplog` ON (`iplog`.`ip_id` = `page`.`creator_ip_id`)
LEFT JOIN `xf_ip` `iplog2` ON (`iplog2`.`ip_id` = `r`.`ip_id`) WHERE 0 < `index`.`indexid` LIMIT 1
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException()
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException()
#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(170): XF\Db\AbstractAdapter->query()
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(25): vw_DB_Controller_XF2->query_read()
#6 src/addons/vw/vw/_core/controller/fetch/vw.php(405): vw_DB_MySQL_Model->select()
#7 src/addons/vw/vw/_core/controller/fetch/index/vw.php(78): vw_Fetch_Controller->get()
#8 src/addons/vw/vw/_core/controller/fetch/vw.php(285): vw_Fetch_Index_Controller->cached()
#9 src/addons/vw/vw/Listener.php(571): vw_Fetch_Controller->cached()
#10 [internal function]: vw\vw\Listener::templater_template_pre_render()
#11 src/XF/Extension.php(35): call_user_func_array()
#12 src/XF/App.php(2797): XF\Extension->fire()
#13 src/XF/Template/Templater.php(1568): XF\App->fire()
#14 src/addons/vw/vw/XF/Template/Templater22.php(34): XF\Template\Templater->renderTemplate()
#15 src/XF/CssRenderer.php(331): vw\vw\XF\Template\Templater22->renderTemplate()
#16 src/addons/vw/vw/XF/CssRenderer.php(39): XF\CssRenderer->renderTemplate()
#17 src/XF/CssRenderer.php(258): vw\vw\XF\CssRenderer->renderTemplate()
#18 src/addons/ThemeHouse/UIX/XF/CssRenderer.php(40): XF\CssRenderer->renderTemplates()
#19 src/XF/CssRenderer.php(116): ThemeHouse\UIX\XF\CssRenderer->renderTemplates()
#20 src/XF/CssWriter.php(53): XF\CssRenderer->render()
#21 css.php(30): XF\CssWriter->run()
#22 {main}
Status der Anfrage
array(4) {
["url"] => string(117) "/css.php?css=admin%3Avw_cp.less%2Cpublic%3Aextra.less&s=0& l=2&d=1605305960&k=b4b0ed7701ab43f905da0a66c1538fe4d5c18f 40"
["referrer"] => string(133) "https://regio-portal.wiki/admin.php?tools/run-job&only_ids=17782&_xfRedirect=https%3A%2F%2Fregio-portal.wiki%2Fadmin.php%3Fadd-ons%2F"
["_GET"] => array(5) {
["css"] => string(34) "admin:vw_cp.less,public:extra.less"
["s"] => string(1) "0"
["l"] => string(1) "2"
["d"] => string(10) "1605305960"
["k"] => string(40) "b4b0ed7701ab43f905da0a66c1538fe4d5c18f40"
}
["_POST"] => array(0) {
}
}

Issue Details

Issue Number 6121

Issue Type Bug

Project VaultWiki 4.x Series

Category Unknown

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.0

Fixed Version 4.1.0

Milestone (none)

Software DependencyXenForo 2.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

November 13, 2020 5:23 PM

hollosch

Senior Member

XF\Db\Exception: Error rendering navigation: MySQL statement prepare error [1146]: Table 'regio-portal.xf_vw_noderead' doesn't exist src/XF/Db/AbstractStatement.php:228
Generiert von: Holger Schrag 13. November 2020 um 23:19
Stack-Trace
SELECT `liked`.*,`di`.*,`l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*, `index`.*,`liked`.`reaction_content_id` AS `like_id`,`iplog2`.`ip` AS `ipaddress`,`iplog`.`ip` AS `creatorip`,`likes`.`reactions`,`likes`.`reaction_users`, `rv`.`vote` AS `myrating`,`rv`.`reason` AS `myratingreason`,`nk`.`readtime` AS `cascadetime`,`sub`.`subscribeid` AS `issubscribed`,`sub`.`notifytype` AS `subscribetype`,`sub`.`options` AS `subscribeoptions`,`mk`.`readtime`,`di`.`userid` AS `disambig_userid`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`t`.`discussionid` AS `discussionid`,`t`.`comments` AS `commentcount`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`r`.`parentid` AS `edit_parentid`,`index`.`pageid`,`index`.`title` AS `title` FROM `xf_vw_index` `index` LEFT JOIN `xf_vw_page` `page` ON (`page`.`pageid` = `index`.`pageid`)
LEFT JOIN `xf_vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1)
LEFT JOIN `xf_vw_counter` `c` ON (`c`.`routeid` = `i`.`routeid`)
LEFT JOIN `xf_vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`)
LEFT JOIN `xf_vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`)
LEFT JOIN `xf_vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`)
LEFT JOIN `xf_vw_disambigitem` `di` ON (`page`.`pageid` = `di`.`contentid` AND `di`.`contenttypeid` = 1)
LEFT JOIN `xf_vw_discussion` `t` ON (`t`.`contentid` = `page`.`pageid` AND `t`.`displayorder` = 0 AND `t`.`contenttypeid` = 1)
LEFT JOIN `xf_vw_markread` `mk` ON (`mk`.`itemtypeid` = 1 AND `mk`.`itemid` = `page`.`pageid` AND `mk`.`userid` = 3)
LEFT JOIN `xf_vw_subscribe` `sub` ON (`sub`.`nodetypeid` = 1 AND `sub`.`nodeid` = `page`.`pageid` AND `sub`.`userid` = 3)
LEFT JOIN `xf_vw_noderead` `nk` ON (`nk`.`nodeid` = `page`.`pageid` AND `nk`.`nodetypeid` = 1 AND `nk`.`userid` = 3)
LEFT JOIN `xf_vw_rate` `rv` ON (`rv`.`contenttypeid` = 7 AND `rv`.`contentid` = `page`.`revisionid` AND `rv`.`userid` = 3)
LEFT JOIN `xf_vw_reactions` `likes` ON (`likes`.`itemtypeid` = 1 AND `likes`.`itemid` = `page`.`pageid`)
LEFT JOIN `xf_ip` `iplog` ON (`iplog`.`ip_id` = `page`.`creator_ip_id`)
LEFT JOIN `xf_ip` `iplog2` ON (`iplog2`.`ip_id` = `r`.`ip_id`)
LEFT JOIN `xf_reaction_content` `liked` ON (`liked`.`content_type` = 'vwpage' AND `liked`.`content_id` = `page`.`pageid` AND `liked`.`reaction_user_id` = 3) WHERE 0 < `index`.`indexid` LIMIT 1
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException()
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException()
#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(170): XF\Db\AbstractAdapter->query()
#5 src/addons/vw/vw/_core/model/db/mysql/vw.php(25): vw_DB_Controller_XF2->query_read()
#6 src/addons/vw/vw/_core/controller/fetch/vw.php(405): vw_DB_MySQL_Model->select()
#7 src/addons/vw/vw/_core/controller/fetch/index/vw.php(78): vw_Fetch_Controller->get()
#8 src/addons/vw/vw/_core/controller/fetch/vw.php(285): vw_Fetch_Index_Controller->cached()
#9 src/addons/vw/vw/_core/model/ui/tab/index/vw.php(30): vw_Fetch_Controller->cached()
#10 src/addons/vw/vw/_core/model/ui/tab/vw.php(55): vw_UI_Tab_Index_Model->can_main_tab()
#11 src/addons/vw/vw/_core/model/plugins/general/vw.php(336): vw_UI_Tab_Model->check()
#12 src/addons/vw/vw/_core/model/plugins/general/xf2.php(152): vw_Plugins_General_Model->get_raw_links()
#13 src/addons/vw/vw/_core/model/plugins/general/vw.php(185): vw_Plugins_General_Model_XF2->get_raw_links()
#14 src/addons/vw/vw/Helper/Model/Navigation.php(26): vw_Plugins_General_Model->get_nav_links()
#15 internal_data/code_cache/navigation_cache.php(152): vw\vw\Helper\Model\Navigation::canViewNav()
#16 src/XF/Template/Templater.php(7311): XF\Pub\App->{closure}()
#17 src/XF/Pub/App.php(575): XF\Template\Templater->renderNavigationClosure()
#18 src/XF/Pub/App.php(526): XF\Pub\App->getNavigation()
#19 src/XF/App.php(2105): XF\Pub\App->renderPageHtml()
#20 src/XF/Mvc/Dispatcher.php(402): XF\App->renderPage()
#21 src/XF/Mvc/Dispatcher.php(58): XF\Mvc\Dispatcher->render()
#22 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#23 src/XF.php(465): XF\App->run()
#24 index.php(20): XF::runApp()
#25 {main}
Status der Anfrage
array(4) {
["url"] => string(21) "/index.php?sw/offline"
["referrer"] => string(43) "https://regio-portal.wiki/service_worker.js"
["_GET"] => array(1) {
["sw/offline"] => string(0) ""
}
["_POST"] => array(0) {
}
}

Reply
November 13, 2020 5:26 PM

hollosch

Senior Member

It chrashed the whole site - Wiki deactivated

Reply
November 13, 2020 6:18 PM
pegasus

VaultWiki Team
Confirmed vw_noderead and couple more were not successfully renamed. This happens when upgrading to 4.1.1 if the installer and uninstaller table lists became desynchronized. Please run the following MySQL query:

Code:

RENAME TABLE vw_noderead TO xf_vw_noderead; RENAME TABLE vw_autolinkcache TO xf_vw_autolinkcache; RENAME TABLE vw_reactions TO xf_vw_reactions

If you encounter other tables please also rename using this pattern and reply with the list of affected tables.
Reply
November 13, 2020 8:11 PM

hollosch

Senior Member

Thx, that works!

Reply
November 14, 2020 8:00 AM

hollosch

Senior Member

XF\Db\Exception: MySQL statement prepare error [1146]: Table 'regio-portal.vw_page' doesn't exist src/XF/Db/AbstractStatement.php:228
Generiert von: Holger Schrag 14. November 2020 um 13:54
Stack-Trace
INSERT INTO `vw_page` (`areaid`, `creatorid`, `creatorname`, `visible`, `dateline`, `protect`, `typelist`, `parsedate`, `pageid`, `revisionid`, `creator_ip_id`, `tagcache`, `fieldcache`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException()
#1 src/XF/Db/Mysqli/Statement.php(39): XF\Db\Mysqli\Statement->getException()
#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/XF/Db/AbstractAdapter.php(218): XF\Db\AbstractAdapter->query()
#5 src/XF/Mvc/Entity/Entity.php(1510): XF\Db\AbstractAdapter->insert()
#6 src/XF/Mvc/Entity/Entity.php(1242): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/addons/vw/vw/XF/Entity/EntityBase.php(551): XF\Mvc\Entity\Entity->save()
#8 src/addons/vw/vw/_core/controller/dm/xf2.php(382): vw\vw\XF\Entity\EntityBase->vwSave()
#9 src/addons/vw/vw/_core/controller/ui/edit/vw.php(246): vw_DM_Controller_XF2->save()
#10 src/addons/vw/vw/_core/controller/ui/create/vw.php(445): vw_UI_Edit_Controller->save()
#11 src/addons/vw/vw/_core/controller/ui/area/vw.php(145): vw_UI_Create_Controller->publish()
#12 src/addons/vw/vw/_core/controller/ui/area/vw.php(47): vw_UI_Area_Controller->publish()
#13 src/addons/vw/vw/_core/controller/ui/stack/vw.php(294): vw_UI_Area_Controller->execute()
#14 src/addons/vw/vw/Pub/Controller/Wiki/Wiki.php(80): vw_UI_Stack_Controller->execute()
#15 src/addons/vw/vw/Mvc/Dispatcher.php(30): vw\vw\Pub\Controller\Wiki\Wiki->_actionIndex()
#16 src/addons/vw/vw/Pub/Controller/Wiki/AbstractController.php(26): vw\vw\Mvc\Dispatcher::dispatch()
#17 src/XF/Mvc/Dispatcher.php(350): vw\vw\Pub\Controller\Wiki\AbstractController->actionIndex()
#18 src/XF/Mvc/Dispatcher.php(257): XF\Mvc\Dispatcher->dispatchClass()
#19 src/XF/Mvc/Dispatcher.php(113): XF\Mvc\Dispatcher->dispatchFromMatch()
#20 src/XF/Mvc/Dispatcher.php(55): XF\Mvc\Dispatcher->dispatchLoop()
#21 src/XF/App.php(2300): XF\Mvc\Dispatcher->run()
#22 src/XF.php(465): XF\App->run()
#23 index.php(20): XF::runApp()
#24 {main}
Status der Anfrage
array(4) {
["url"] => string(51) "/wiki/Stadtwiki_Geislingen?do=publish&itemtypeid=11"
["referrer"] => string(96) "https://regio-portal.wiki/wiki/Stadtwiki_Geislingen?do=create&itemtypeid=11&etid=1&ecid= 0&eaid=4"
["_GET"] => array(2) {
["do"] => string(7) "publish"
["itemtypeid"] => string(2) "11"
}
["_POST"] => array(28) {
["message_html"] => string(289) "Bau der neuen Sport- und KulturhalleEinweihung17. Oktober 2020Image Datei:Sport-und_Kulturhalle_Aufhausen_01.jpg"
["prefixid"] => string(2) "26"
["edittitle"] => string(46) "Bau der neuen Sport- und Kulturhalle Aufhausen"
["summary"] => string(0) ""
["query"] => string(0) ""
["typelist"] => array(1) {
[11] => string(1) "1"
}
["icontype"] => string(0) ""
["fonticon"] => string(4) "f15b"
["fontstyle"] => string(1) "r"
["untabbed"] => string(1) "0"
["autolink"] => string(2) "-2"
["htmlstate"] => string(8) "on_nl2br"
["notifytype"] => string(1) "1"
["sub_options"] => array(2) {
["item_edits"] => string(1) "1"
["item_comments"] => string(1) "1"
}
["do"] => string(7) "publish"
["itemtypeid"] => string(2) "11"
["areaid"] => string(1) "4"
["section"] => string(1) "0"
["posthash"] => string(0) ""
["poststarttime"] => string(10) "1605358471"
["revparentid"] => string(0) ""
["loggedinuser"] => string(1) "3"
["from_draft"] => string(9) "11:0:45:0"
["_xfToken"] => string(8) "********"
["sbutton"] => string(9) "undefined"
["_xfRequestUri"] => string(71) "/wiki/Stadtwiki_Geislingen?do=create&itemtypeid=11&etid=1&ecid= 0&eaid=4"
["_xfWithData"] => string(1) "1"
["_xfResponseType"] => string(4) "json"
}
}

After using RENAME TABLE vw_vw_page TO xf_vw_page SQL tells me:

#1050 - table 'xf_vw_page' exists

Reply
November 14, 2020 6:21 PM
pegasus

VaultWiki Team
In src/addons/vw/vw/Helper/Entity/Structure.php, find:

Code:

$structure->primaryKey = $node['idfield'];

BEFORE it, add:

Code:

$structure->table = \vw_DB::get()->query()->prefix($structure->table);

Then please try your action again.
Reply
December 1, 2020 9:21 AM
gerryvz

New Member
Originally Posted by pegasus

Confirmed vw_noderead and couple more were not successfully renamed. This happens when upgrading to 4.1.1 if the installer and uninstaller table lists became desynchronized. Please run the following MySQL query:

Code:

RENAME TABLE vw_noderead TO xf_vw_noderead; RENAME TABLE vw_autolinkcache TO xf_vw_autolinkcache; RENAME TABLE vw_reactions TO xf_vw_reactions

If you encounter other tables please also rename using this pattern and reply with the list of affected tables.

Last query above is missing semicolon after "xf_vw_reactions" -- FYI.
Reply

+ Reply

All times are GMT -4. The time now is 8:25 AM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: XF\Db\Exception: Error rendering template admin:vw_cp.less: MySQL statement prepare error [1146]: Table 'regio-portal.xf_vw_reactions' doesn't exist src/XF/Db/AbstractStatement.php:228

Issue Tools