Upgrading to 4.0.9 Step 4
Update stops at step 4:
Code:
Updating data in table: vw_area
An exception occurred: Database Error: SELECT `l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*,`area`.*,`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`,NULL AS `edit_parentid`,`page`.`pageid`,`area`.`parentid` AS `parentid`,`area`.`pageid` FROM `vw_area` `area` LEFT JOIN `vw_page` `page` ON (`page`.`pageid` = `area`.`pageid`) LEFT JOIN `vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1) LEFT JOIN `vw_counter` `c` ON (`c`.`pageid` = `page`.`pageid`) 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` = 3) LEFT JOIN `vw_subscribe` `sub` ON (`sub`.`nodetypeid` = 1 AND `sub`.`nodeid` = `page`.`pageid` AND `sub`.`userid` = 3) LEFT JOIN `vw_likes` `likes` ON (`likes`.`itemtypeid` = 1 AND `likes`.`itemid` = `page`.`pageid`) WHERE 0 < `page`.`areaid` ORDER BY `area`.`displayorder` ASC, `area`.`areaid` ASC Mysqli prepare error: Unknown column 'c.pageid' in 'on clause' in /var/www/vhosts/regio-portal.wiki/httpdocs/vault/core/controller/db/xf.php on line 169
vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 183
vw_DB_Controller_XF->query_read() in vault/core/model/db/mysql/vw.php at line 27
vw_DB_MySQL_Model->select() in vault/core/controller/fetch/vw.php at line 211
vw_Fetch_Controller->get() in vault/core/model/area/vw.php at line 215
vw_Area_Model->get_area_cache() in vault/core/model/area/vw.php at line 110
vw_Area_Model->get_icache() in vault/core/model/rebuild/vw.php at line 138
vw_Rebuild_Model->areas() in vault/install/lib/upgradepath/steps/4/0/9/base/vw.php at line 390
vw_Install_UpgradePath_Steps_409_base_Controller->{closure}() in vault/core/controller/progress/steps/vw.php at line 76
vw_Progress_Steps_Controller->call() in vault/core/controller/progress/steps/vw.php at line 49
vw_Progress_Steps_Controller->execute() in vault/install/lib/upgradepath/vw.php at line 60
vw_Install_UpgradePath_Controller->exec_script() in vault/core/controller/progress/vw.php at line 74
vw_Progress_Controller->execute() in vault/core/controller/cp/progress/vw.php at line 36
vw_CP_Progress_Controller->process() in vault/core/controller/cp/install/vw.php at line 271
vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 57
vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 119
vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 176
vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 351
XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
XenForo_FrontController->run() in admin.php at line 13