Invalid SQL:
SELECT `gi`.*,`l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*, IF(`sub`.`userid`, 1, 0) AS `issubscribed`,`mk`.`readtime`,`gi`.`userid` AS `group_userid`,`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` 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`.`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_groupitem` `gi` ON (`page`.`pageid` = `gi`.`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) WHERE `page`.`areaid` = 0;
MySQL Error : Unknown column 'c.pageid' in 'on clause'
Error Number : 1054
Request Date : Friday, December 11th 2015 @ 10:08:53 PM
Error Date : Friday, December 11th 2015 @ 10:08:53 PM
Classname : vB_Database_MySQLi
MySQL Version : 5.5.46-MariaDB-log
I've made some changes - there was more than 1 issue upgrading to 4.0.7 from 4.0.3 directly. I would recommend downloading the ZIP again with these changes, then reupload the vault/core/controller/install directory from the ZIP.
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.