Environment Builder

http://192.168.0.207/silverstripe/

dev→ build

Building Database ss_mysite

Creating database tables

  • PageComment
  • Table PageComment: created
  • Field PageComment.ID: created as serial8 not null
  • Field PageComment.ClassName: created as varchar(255) default 'PageComment' check ("ClassName" in ('PageComment'))
  • Field PageComment.Created: created as timestamp
  • Field PageComment.LastEdited: created as timestamp
  • Field PageComment.Name: created as varchar(200)
  • Field PageComment.Comment: created as text
  • Field PageComment.IsSpam: created as smallint default 0
  • Field PageComment.NeedsModeration: created as smallint default 0
  • Field PageComment.CommenterURL: created as varchar(255)
  • Field PageComment.SessionID: created as varchar(255)
  • Field PageComment.ParentID: created as integer default 0
  • Field PageComment.AuthorID: created as integer default 0
  • Index PageComment.ParentID: created as (ParentID)
  • Index PageComment.AuthorID: created as (AuthorID)
  • Index PageComment.ClassName: created as (ClassName)
  • SiteConfig
  • Table SiteConfig: created
  • Field SiteConfig.ID: created as serial8 not null
  • Field SiteConfig.ClassName: created as varchar(255) default 'SiteConfig' check ("ClassName" in ('SiteConfig'))
  • Field SiteConfig.Created: created as timestamp
  • Field SiteConfig.LastEdited: created as timestamp
  • Field SiteConfig.Title: created as varchar(255)
  • Field SiteConfig.Tagline: created as varchar(255)
  • Field SiteConfig.Theme: created as varchar(255)
  • Field SiteConfig.CanViewType: created as varchar(255) default 'Anyone' check ("CanViewType" in ('Anyone', 'LoggedInUsers', 'OnlyTheseUsers'))
  • Field SiteConfig.CanEditType: created as varchar(255) default 'LoggedInUsers' check ("CanEditType" in ('LoggedInUsers', 'OnlyTheseUsers'))
  • Field SiteConfig.CanCreateTopLevelType: created as varchar(255) default 'LoggedInUsers' check ("CanCreateTopLevelType" in ('LoggedInUsers', 'OnlyTheseUsers'))
  • Index SiteConfig.ClassName: created as (ClassName)
  • Table SiteConfig_ViewerGroups: created
  • Field SiteConfig_ViewerGroups.ID: created as serial8 not null
  • Field SiteConfig_ViewerGroups.SiteConfigID: created as integer default 0
  • Field SiteConfig_ViewerGroups.GroupID: created as integer default 0
  • Index SiteConfig_ViewerGroups.SiteConfigID: created as (SiteConfigID)
  • Index SiteConfig_ViewerGroups.GroupID: created as (GroupID)
  • Table SiteConfig_EditorGroups: created
  • Field SiteConfig_EditorGroups.ID: created as serial8 not null
  • Field SiteConfig_EditorGroups.SiteConfigID: created as integer default 0
  • Field SiteConfig_EditorGroups.GroupID: created as integer default 0
  • Index SiteConfig_EditorGroups.SiteConfigID: created as (SiteConfigID)
  • Index SiteConfig_EditorGroups.GroupID: created as (GroupID)
  • Table SiteConfig_CreateTopLevelGroups: created
  • Field SiteConfig_CreateTopLevelGroups.ID: created as serial8 not null
  • Field SiteConfig_CreateTopLevelGroups.SiteConfigID: created as integer default 0
  • Field SiteConfig_CreateTopLevelGroups.GroupID: created as integer default 0
  • Index SiteConfig_CreateTopLevelGroups.SiteConfigID: created as (SiteConfigID)
  • Index SiteConfig_CreateTopLevelGroups.GroupID: created as (GroupID)
  • SiteTree
  • Table SiteTree: created
  • Field SiteTree.ID: created as serial8 not null
  • Field SiteTree.ClassName: created as varchar(255) default 'SiteTree' check ("ClassName" in ('SiteTree', 'Page', 'ErrorPage', 'RedirectorPage', 'VirtualPage'))
  • Field SiteTree.Created: created as timestamp
  • Field SiteTree.LastEdited: created as timestamp
  • Field SiteTree.URLSegment: created as varchar(255)
  • Field SiteTree.Title: created as varchar(255)
  • Field SiteTree.MenuTitle: created as varchar(100)
  • Field SiteTree.Content: created as text
  • Field SiteTree.MetaTitle: created as varchar(255)
  • Field SiteTree.MetaDescription: created as text
  • Field SiteTree.MetaKeywords: created as varchar(255)
  • Field SiteTree.ExtraMeta: created as text
  • Field SiteTree.ShowInMenus: created as smallint default 0
  • Field SiteTree.ShowInSearch: created as smallint default 0
  • Field SiteTree.HomepageForDomain: created as varchar(100)
  • Field SiteTree.ProvideComments: created as smallint default 0
  • Field SiteTree.Sort: created as integer default 0
  • Field SiteTree.HasBrokenFile: created as smallint default 0
  • Field SiteTree.HasBrokenLink: created as smallint default 0
  • Field SiteTree.Status: created as varchar(50)
  • Field SiteTree.ReportClass: created as varchar(50)
  • Field SiteTree.CanViewType: created as varchar(255) default 'Inherit' check ("CanViewType" in ('Anyone', 'LoggedInUsers', 'OnlyTheseUsers', 'Inherit'))
  • Field SiteTree.CanEditType: created as varchar(255) default 'Inherit' check ("CanEditType" in ('LoggedInUsers', 'OnlyTheseUsers', 'Inherit'))
  • Field SiteTree.ToDo: created as text
  • Field SiteTree.Version: created as integer default 0
  • Field SiteTree.Priority: created as varchar(5)
  • Field SiteTree.ParentID: created as integer default 0
  • Index SiteTree.ParentID: created as (ParentID)
  • Index SiteTree.URLSegment: created as (URLSegment)
  • Index SiteTree.ClassName: created as (ClassName)
  • Table SiteTree_LinkTracking: created
  • Field SiteTree_LinkTracking.ID: created as serial8 not null
  • Field SiteTree_LinkTracking.SiteTreeID: created as integer default 0
  • Field SiteTree_LinkTracking.ChildID: created as integer default 0
  • Field SiteTree_LinkTracking.FieldName: created as varchar(50)
  • Index SiteTree_LinkTracking.SiteTreeID: created as (SiteTreeID)
  • Index SiteTree_LinkTracking.ChildID: created as (ChildID)
  • Table SiteTree_ImageTracking: created
  • Field SiteTree_ImageTracking.ID: created as serial8 not null
  • Field SiteTree_ImageTracking.SiteTreeID: created as integer default 0
  • Field SiteTree_ImageTracking.FileID: created as integer default 0
  • Field SiteTree_ImageTracking.FieldName: created as varchar(50)
  • Index SiteTree_ImageTracking.SiteTreeID: created as (SiteTreeID)
  • Index SiteTree_ImageTracking.FileID: created as (FileID)
  • Table SiteTree_ViewerGroups: created
  • Field SiteTree_ViewerGroups.ID: created as serial8 not null
  • Field SiteTree_ViewerGroups.SiteTreeID: created as integer default 0
  • Field SiteTree_ViewerGroups.GroupID: created as integer default 0
  • Index SiteTree_ViewerGroups.SiteTreeID: created as (SiteTreeID)
  • Index SiteTree_ViewerGroups.GroupID: created as (GroupID)
  • Table SiteTree_EditorGroups: created
  • Field SiteTree_EditorGroups.ID: created as serial8 not null
  • Field SiteTree_EditorGroups.SiteTreeID: created as integer default 0
  • Field SiteTree_EditorGroups.GroupID: created as integer default 0
  • Index SiteTree_EditorGroups.SiteTreeID: created as (SiteTreeID)
  • Index SiteTree_EditorGroups.GroupID: created as (GroupID)
  • Table SiteTree_Live: created
  • Field SiteTree_Live.ID: created as serial8 not null
  • Field SiteTree_Live.ClassName: created as varchar(255) default 'SiteTree' check ("ClassName" in ('SiteTree', 'Page', 'ErrorPage', 'RedirectorPage', 'VirtualPage'))
  • Field SiteTree_Live.Created: created as timestamp
  • Field SiteTree_Live.LastEdited: created as timestamp
  • Field SiteTree_Live.URLSegment: created as varchar(255)
  • Field SiteTree_Live.Title: created as varchar(255)
  • Field SiteTree_Live.MenuTitle: created as varchar(100)
  • Field SiteTree_Live.Content: created as text
  • Field SiteTree_Live.MetaTitle: created as varchar(255)
  • Field SiteTree_Live.MetaDescription: created as text
  • Field SiteTree_Live.MetaKeywords: created as varchar(255)
  • Field SiteTree_Live.ExtraMeta: created as text
  • Field SiteTree_Live.ShowInMenus: created as smallint default 0
  • Field SiteTree_Live.ShowInSearch: created as smallint default 0
  • Field SiteTree_Live.HomepageForDomain: created as varchar(100)
  • Field SiteTree_Live.ProvideComments: created as smallint default 0
  • Field SiteTree_Live.Sort: created as integer default 0
  • Field SiteTree_Live.HasBrokenFile: created as smallint default 0
  • Field SiteTree_Live.HasBrokenLink: created as smallint default 0
  • Field SiteTree_Live.Status: created as varchar(50)
  • Field SiteTree_Live.ReportClass: created as varchar(50)
  • Field SiteTree_Live.CanViewType: created as varchar(255) default 'Inherit' check ("CanViewType" in ('Anyone', 'LoggedInUsers', 'OnlyTheseUsers', 'Inherit'))
  • Field SiteTree_Live.CanEditType: created as varchar(255) default 'Inherit' check ("CanEditType" in ('LoggedInUsers', 'OnlyTheseUsers', 'Inherit'))
  • Field SiteTree_Live.ToDo: created as text
  • Field SiteTree_Live.Version: created as integer default 0
  • Field SiteTree_Live.Priority: created as varchar(5)
  • Field SiteTree_Live.ParentID: created as integer default 0
  • Index SiteTree_Live.ParentID: created as (ParentID)
  • Index SiteTree_Live.URLSegment: created as (URLSegment)
  • Index SiteTree_Live.ClassName: created as (ClassName)
  • [Warning] pg_query(): Query failed: ERROR: relation "SiteTree_versions" does not exist LINE 2: FROM "SiteTree_versions" GROUP BY "RecordID", "Version... ^

    GET /silverstripe/dev/build?flush=1

    Line 174 in /var/www/silverstripe/postgresql/code/PostgreSQLDatabase.php

    Source

    165 		if(isset($_REQUEST['previewwrite']) && in_array(strtolower(substr($sql,0,strpos($sql,' '))), array('insert','update','delete','replace'))) {
    166 			Debug::message("Will execute: $sql");
    167 			return;
    168 		}
    169 
    170 		if(isset($_REQUEST['showqueries'])) { 
    171 			$starttime = microtime(true);
    172 		}
    173 
    174 		$handle = pg_query($this->dbConn, $sql);
    175 		
    176 		if(isset($_REQUEST['showqueries'])) {
    177 			$endtime = round(microtime(true) - $starttime,4);
    178 			Debug::message("\n$sql\n{$endtime}ms\n", false);
    179 		}
    180 		
    

    Trace