I just noticed that 4.04 was released. I forget if VaultWiki requires some special approach to upgrading, but here's what I did:
Uploaded contents of upload file via FTP.
When I did that, the entire site went down, and I generated 10 pages of server errors. I just disabled the wiki via the add on menu to restore functionality. Is this normal?
I got lots of Database error SELECT issues such as:
Code:
XenForo_Exception: Database Error: SELECT `l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*,`likes`.`likes`,`likes`.`like_users`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`r`.`parentid` AS `edit_parentid`,`page`.`pageid` FROM `vw_page` `page` LEFT JOIN `vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1) LEFT JOIN `vw_counter` `c` ON (`c`.`routeid` = `i`.`routeid`) LEFT JOIN `vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`) LEFT JOIN `vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`) LEFT JOIN `vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`) LEFT JOIN `vw_likes` `likes` ON (`likes`.`itemtypeid` = 1 AND `likes`.`itemid` = `page`.`pageid`) WHERE `page`.`areaid` = 0 Mysqli prepare error: Unknown column 'c.routeid' in 'on clause' - vault/core/controller/db/xf.php:146
Generated By: Unknown Account, 16 minutes ago
Stack Trace
#0 /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/db/xf.php(160): vw_DB_Controller_XF->throw_error(Object(Zend_Db_Statement_Mysqli_Exception), 'SELECT `l`.*,`c...')
#1 /home/mario/public_html/saverocity.com/public/forum/vault/core/model/db/mysql/vw.php(29): vw_DB_Controller_XF->query_read('SELECT `l`.*,`c...')
#2 /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/fetch/vw.php(211): vw_DB_MySQL_Model->select(Array)
#3 /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/fetch/vw.php(493): vw_Fetch_Controller->get('Page', Array)
#4 /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/fetch/vw.php(308): vw_Fetch_Controller->get_index()
#5 /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/fetch/vw.php(123): vw_Fetch_Controller->return_the_index(0)
#6 /home/mario/public_html/saverocity.com/public/forum/library/vw/WidgetFramework/WidgetRenderer.php(194): vw_Fetch_Controller->get('Index', 0)
#7 /home/mario/public_html/saverocity.com/public/forum/library/WidgetFramework/WidgetRenderer.php(693): vw_WidgetFramework_WidgetRenderer->_render(Array, 'thread_view', Array, Object(XenForo_Template_Public))
#8 /home/mario/public_html/saverocity.com/public/forum/library/vw/WidgetFramework/WidgetRenderer.php(149): WidgetFramework_WidgetRenderer->render(Array, 'thread_view', Array, Object(XenForo_Template_Public), Object(_WidgetFramework_ArrayOfString))
#9 /home/mario/public_html/saverocity.com/public/forum/library/WidgetFramework/Core.php(397): vw_WidgetFramework_WidgetRenderer->render(Array, 'thread_view', Array, Object(XenForo_Template_Public), Object(_WidgetFramework_ArrayOfString))
#10 /home/mario/public_html/saverocity.com/public/forum/library/WidgetFramework/Core.php(316): WidgetFramework_Core->_renderWidgetsFor('thread_view', Array, Object(XenForo_Template_Public), '')
#11 /home/mario/public_html/saverocity.com/public/forum/library/WidgetFramework/Listener.php(126): WidgetFramework_Core->renderWidgetsFor('thread_view', Array, Object(XenForo_Template_Public), Array)
#12 [internal function]: WidgetFramework_Listener::template_post_render('thread_view', '\n\n\t\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nArray, Object(XenForo_Template_Public))
#13 /home/mario/public_html/saverocity.com/public/forum/library/XenForo/CodeEvent.php(58): call_user_func_array(Array, Array)
#14 /home/mario/public_html/saverocity.com/public/forum/library/XenForo/Template/Abstract.php(195): XenForo_CodeEvent::fire('template_post_r...', Array, 'thread_view')
#15 /home/mario/public_html/saverocity.com/public/forum/library/XenForo/Template/Public.php(110): XenForo_Template_Abstract->render()
#16 /home/mario/public_html/saverocity.com/public/forum/library/XenForo/ViewRenderer/HtmlPublic.php(123): XenForo_Template_Public->render()
#17 /home/mario/public_html/saverocity.com/public/forum/library/XenForo/FrontController.php(618): XenForo_ViewRenderer_HtmlPublic->renderContainer(Object(XenForo_Template_Public), Array)
#18 /home/mario/public_html/saverocity.com/public/forum/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#19 /home/mario/public_html/saverocity.com/public/forum/index.php(13): XenForo_FrontController->run()
#20 {main}
Request State
array(3) {
["url"] => string(58) "https://saverocity.com/forum/threads/lurkers.53893/page-14"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}
And there were a number of other errors also. The forum itself only displayed a page of database errors.... I didn't copy that down in my rush to get the site active again.
Right now, I'm wrapping up the install (slow FTP upload) and was thinking to reactivate the wiki and try the upgrade script.
When I reactivated the Wiki in addons after completing the FTP I received the following error page (displayed when looking at the forum... AKA the entire site was unusable)
Code:
An exception occurred: Database Error: SELECT `l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*,`likes`.`likes`,`likes`.`like_users`, IF(`sub`.`userid`, 1, 0) AS `issubscribed`,`mk`.`readtime`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`r`.`parentid` AS `edit_parentid`,`page`.`pageid` FROM `vw_page` `page` LEFT JOIN `vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1) LEFT JOIN `vw_counter` `c` ON (`c`.`routeid` = `i`.`routeid`) LEFT JOIN `vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`) LEFT JOIN `vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`) LEFT JOIN `vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`) LEFT JOIN `vw_markread` `mk` ON (`mk`.`itemtypeid` = 1 AND `mk`.`itemid` = `page`.`pageid` AND `mk`.`userid` = 1) LEFT JOIN `vw_subscribe` `sub` ON (`sub`.`nodetypeid` = 1 AND `sub`.`nodeid` = `page`.`pageid` AND `sub`.`userid` = 1) LEFT JOIN `vw_likes` `likes` ON (`likes`.`itemtypeid` = 1 AND `likes`.`itemid` = `page`.`pageid`) WHERE `page`.`areaid` = 0 Mysqli prepare error: Unknown column 'c.routeid' in 'on clause' in /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/db/xf.php on line 146
vw_DB_Controller_XF->throw_error() in /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/db/xf.php at line 160
vw_DB_Controller_XF->query_read() in /home/mario/public_html/saverocity.com/public/forum/vault/core/model/db/mysql/vw.php at line 29
vw_DB_MySQL_Model->select() in /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/fetch/vw.php at line 211
vw_Fetch_Controller->get() in /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/fetch/vw.php at line 493
vw_Fetch_Controller->get_index() in /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/fetch/vw.php at line 308
vw_Fetch_Controller->return_the_index() in /home/mario/public_html/saverocity.com/public/forum/vault/core/controller/fetch/vw.php at line 123
vw_Fetch_Controller->get() in vw/WidgetFramework/WidgetRenderer.php at line 194
vw_WidgetFramework_WidgetRenderer->_render() in WidgetFramework/WidgetRenderer.php at line 693
WidgetFramework_WidgetRenderer->render() in vw/WidgetFramework/WidgetRenderer.php at line 149
vw_WidgetFramework_WidgetRenderer->render() in WidgetFramework/Core.php at line 397
WidgetFramework_Core->_renderWidgetsFor() in WidgetFramework/Core.php at line 316
WidgetFramework_Core->renderWidgetsFor() in WidgetFramework/Listener.php at line 126
WidgetFramework_Listener::template_post_render()
call_user_func_array() in XenForo/CodeEvent.php at line 58
XenForo_CodeEvent::fire() in XenForo/Template/Abstract.php at line 195
XenForo_Template_Abstract->render() in XenForo/Template/Public.php at line 110
XenForo_Template_Public->render() in XenForo/ViewRenderer/HtmlPublic.php at line 123
XenForo_ViewRenderer_HtmlPublic->renderContainer() in XenForo/FrontController.php at line 618
XenForo_FrontController->renderView() in XenForo/FrontController.php at line 158
XenForo_FrontController->run() in /home/mario/public_html/saverocity.com/public/forum/index.php at line 13