Issue: Error on Upgrade

Issue Tools
- View Changes

May 24, 2015 8:26 AM

matth2

New Member

Error on Upgrade

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

Issue Details

Issue Number 4302

Issue Type Bug

Project VaultWiki 4.x Series

Category Unknown

Status Not a Bug

Priority 2 - Fatal / Database Errors

Affected Version 4.0.4

Fixed Version (none)

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

May 24, 2015 8:39 AM

matth2

New Member

After running upgrade script it came back online - but quite a ugly upgrade. Any advice for preventing this in the future?

Reply
May 24, 2015 9:11 AM

pegasus

VaultWiki Team

If the files are not fully uploaded, you will have errors when users access one file from your old version and another file from the new version at the same time. You might have better luck if you upload the file with the version info first, then upload the rest of the ZIP: vault/core/model/vw.php. You might also consider proactively deactivating the wiki via the wiki settings (which is done automatically whenever the version is detected as wrong).

You will not have errors once the file transfer is complete. There is no way to prevent this fully. VaultWiki is designed to prevent these kinds of errors itself with a built-in version-check mechanism, but there is usually a window of time when this has not kicked in yet, i.e. before PHP recognizes the updated version info.

The best way to limit the time window when this might occur is to upload the ZIP itself to your server, then have your server unzip it and copy it to the correct locations using command line functions. This would reduce the potential window from minutes to seconds.

Reply

+ Reply

All times are GMT -4. The time now is 4:50 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: Error on Upgrade

Issue Tools