I'm trying to upgrade a 2.3.2 installation to 2.4.0 and as usual I'm tearing my hair our with "there has been an error"
When I switch to dev mode I get:
[User Error] Couldn't run query: SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."CartLink", "NewsPage"."Date", CASE WHEN "SiteTree"."ClassName" IN ('SideBarPage') THEN "SideBarPage"."SideBarContent" WHEN "SiteTree"."ClassName" IN ('SideBarPageCart') THEN "SideBarPageCart"."SideBarContent" ELSE NULL END AS "SideBarContent", "ErrorPage"."ErrorCode", "RedirectorPage"."RedirectionType", "RedirectorPage"."ExternalURL", "RedirectorPage"."LinkToID", "VirtualPage"."VersionID", "VirtualPage"."CopyContentFromID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" LEFT JOIN "NewsPage" ON "NewsPage"."ID" = "SiteTree"."ID" LEFT JOIN "SideBarPage" ON "SideBarPage"."ID" = "SiteTree"."ID" LEFT JOIN "SideBarPageCart" ON "SideBarPageCart"."ID" = "SiteTree"."ID" LEFT JOIN "ErrorPage" ON "ErrorPage"."ID" = "SiteTree"."ID" LEFT JOIN "RedirectorPage" ON "RedirectorPage"."ID" = "SiteTree"."ID" LEFT JOIN "VirtualPage" ON "VirtualPage"."ID" = "SiteTree"."ID" WHERE ("HomepageForDomain" LIKE '%mysite.co.uk%') ORDER BY "Sort" Unknown column 'SiteTree.Priority' in 'field list'
GET /
Line 536 in /home/myso/public_html/sapphire/core/model/MySQLDatabase.php
Now a few things I'm confused about:
1. I can access /dev/ area and when I run build it reports table SiteConfig created, yet when I check database there is no table of that name.
2. Why does my old config file start with
global $databaseConfig;
$databaseConfig = array(
yet the default config file with 2.4 is
global $database;
$database = array(
I tried changing my config to just $database but then I then fail to even get default " there has been an error page". Is my existing config value ok?
Point 2 may not even be related, just trying to understand the issue here.
Also I'm not using any modules.
Any help appreciated
Thanks