Fatal DB error after VW Beta 5 Upgrade
two fatal db errors @ access of site and setup
When i try to open the site (Setup is not possible pls find below)
Code:
Invalid SQL:
SELECT IF(`sub`.`userid`, 1, 0) AS `issubscribed`,`mk`.`readtime`,`gi`.*,`gi`.`userid` AS `group_userid`,`l`.*,`l`.`userid` AS `translate_userid`,`ch`.*,`ch`.`userid` AS `chapter_userid`,`c`.*,`r`.*,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`i`.*,`page`.*,`page`.`pageid`,`area`.*,`area`.`pageid` FROM `VB4_vw_area` `area` LEFT JOIN `VB4_vw_page` `page` ON (`page`.`pageid` = `area`.`pageid`)
LEFT JOIN `VB4_vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1)
LEFT JOIN `VB4_vw_counter` `c` ON (`c`.`pageid` = `page`.`pageid`)
LEFT JOIN `VB4_vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`)
LEFT JOIN `VB4_vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`)
LEFT JOIN `VB4_vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`)
LEFT JOIN `VB4_vw_groupitem` `gi` ON (`page`.`pageid` = `gi`.`pageid`)
LEFT JOIN `VB4_vw_markread` `mk` ON (`mk`.`itemtypeid` = 1 AND `mk`.`itemid` = `page`.`pageid` AND `mk`.`userid` = 1)
LEFT JOIN `VB4_vw_subscribe` `sub` ON (`sub`.`nodetypeid` = 1 AND `sub`.`nodeid` = `page`.`pageid` AND `sub`.`userid` = 1) WHERE 0 < `area`.`areaid` ORDER BY `area`.`displayorder` ASC, `area`.`areaid` ASC;
MySQL-Fehler : Unknown column 'gi.userid' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Monday, 09.09.2013 @ 20:42:25
Datum : Monday, 09.09.2013 @ 20:42:28
Skript : http://www.xxx.info/system/forum.php
Referrer : http://www.xx.info/system/admincp/index.php?do=head
IP-Adresse : xxx
Benutzername : aLpHa
Klassenname : vB_Database
MySQL-Version : 5.1.66-0+squeeze1
Setup/upgrade ERROR:
Code:
Database error vBulletin 4.2.1:
Invalid SQL:
SELECT IF(`sub`.`userid`, 1, 0) AS `issubscribed`,`mk`.`readtime`,`gi`.*,`gi`.`userid` AS `group_userid`,`l`.*,`l`.`userid` AS `translate_userid`,`ch`.*,`ch`.`userid` AS `chapter_userid`,`c`.*,`r`.*,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`i`.*,`page`.*,`page`.`pageid` FROM `VB4_vw_page` `page` LEFT JOIN `VB4_vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1)
LEFT JOIN `VB4_vw_counter` `c` ON (`c`.`pageid` = `page`.`pageid`)
LEFT JOIN `VB4_vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`)
LEFT JOIN `VB4_vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`)
LEFT JOIN `VB4_vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`)
LEFT JOIN `VB4_vw_groupitem` `gi` ON (`page`.`pageid` = `gi`.`pageid`)
LEFT JOIN `VB4_vw_markread` `mk` ON (`mk`.`itemtypeid` = 1 AND `mk`.`itemid` = `page`.`pageid` AND `mk`.`userid` = 1)
LEFT JOIN `VB4_vw_subscribe` `sub` ON (`sub`.`nodetypeid` = 1 AND `sub`.`nodeid` = `page`.`pageid` AND `sub`.`userid` = 1) WHERE `page`.`areaid` = 0;
MySQL-Fehler : Unknown column 'gi.userid' in 'field list'
Fehler-Nr. : 1054
Fehler-Zeit : Monday, 09.09.2013 @ 20:38:56
Datum : Monday, 09.09.2013 @ 20:38:59
Skript : http://www.xxx.info/system/login.php?do=login
Referrer : http://www.xxx.info/system/vault/install/index.php
IP-Adresse : xxx
Benutzername : aLpHa
Klassenname : vB_Database
MySQL-Version : 5.1.66-0+squeeze1