Environment Builder

http://localhost:8080/SilverStripe-v2.4.5/

dev→ build

Building database productiondb using PostgreSQL 8.4.8

Creating database tables

  • PageComment
  • SiteConfig
  • SiteTree
  • Field SiteTree.ClassName: changed to varchar(255) default 'SiteTree' check ("ClassName" in ('SiteTree', 'Page', 'FCategoryPage', 'FProductPage', 'FTopCategoryPage', 'FishTankHolder', 'HomePage', 'ErrorPage', 'RedirectorPage', 'VirtualPage', 'FishTankPage')) (from varchar(255) default 'SiteTree' check ("ClassName" in ('SiteTree', 'Page', 'FCategoryPage', 'FProductPage', 'FTopCategoryPage', 'FishTankHolder', 'HomePage', 'ErrorPage', 'RedirectorPage', 'VirtualPage', 'BlogEntry', 'BlogTree', 'FishTankPage', 'SubsitesVirtualPage', 'BlogHolder')))
  • Field SiteTree_Live.ClassName: changed to varchar(255) default 'SiteTree' check ("ClassName" in ('SiteTree', 'Page', 'FCategoryPage', 'FProductPage', 'FTopCategoryPage', 'FishTankHolder', 'HomePage', 'ErrorPage', 'RedirectorPage', 'VirtualPage', 'FishTankPage')) (from varchar(255) default 'SiteTree' check ("ClassName" in ('SiteTree', 'Page', 'FCategoryPage', 'FProductPage', 'FTopCategoryPage', 'FishTankHolder', 'HomePage', 'ErrorPage', 'RedirectorPage', 'VirtualPage', 'BlogEntry', 'BlogTree', 'FishTankPage', 'SubsitesVirtualPage', 'BlogHolder')))
  • Field SiteTree_versions.ClassName: changed to varchar(255) default 'SiteTree' check ("ClassName" in ('SiteTree', 'Page', 'FCategoryPage', 'FProductPage', 'FTopCategoryPage', 'FishTankHolder', 'HomePage', 'ErrorPage', 'RedirectorPage', 'VirtualPage', 'FishTankPage')) (from varchar(255) default 'SiteTree' check ("ClassName" in ('SiteTree', 'Page', 'FCategoryPage', 'FProductPage', 'FTopCategoryPage', 'FishTankHolder', 'HomePage', 'ErrorPage', 'RedirectorPage', 'VirtualPage', 'BlogEntry', 'BlogTree', 'AccountPage', 'CartPage', 'CheckoutPage', 'Product', 'ProductGroup', 'FishTankPage', 'SubsitesVirtualPage', 'BlogHolder')))
  • Email_BounceRecord
  • QueuedEmail
  • File
  • Field File.ClassName: changed to varchar(255) default 'File' check ("ClassName" in ('File', 'Image', 'Folder', 'Image_Cached')) (from varchar(255) default 'File' check ("ClassName" in ('File', 'Image', 'Folder', 'Image_Cached', 'Product_Image')))
  • Group
  • LoginAttempt
  • Member
  • MemberPassword
  • Permission
  • PermissionRole
  • PermissionRoleCode
  • Widget
  • Field Widget.ClassName: changed to varchar(255) default 'Widget' check ("ClassName" in ('Widget')) (from varchar(255) default 'Widget' check ("ClassName" in ('Widget', 'ArchiveWidget', 'BlogManagementWidget', 'RSSWidget', 'SubscribeRSSWidget', 'TagCloudWidget')))
  • WidgetArea
  • Page
  • FCategoryPage
  • FProductPage
  • Field FProductPage.ProductResume: changed to varchar(200) (from varchar(50))
  • Field FProductPage.ProductVolume: created as decimal(9,2) default 0
  • Field FProductPage.ProductWeight: created as decimal(9,2) default 0
  • Field FProductPage_Live.ProductResume: changed to varchar(200) (from varchar(50))
  • Field FProductPage_Live.ProductVolume: created as decimal(9,2) default 0
  • Field FProductPage_Live.ProductWeight: created as decimal(9,2) default 0
  • Field FProductPage_versions.ProductResume: changed to varchar(200) (from varchar(50))
  • Field FProductPage_versions.ProductVolume: created as decimal(9,2) default 0
  • Field FProductPage_versions.ProductWeight: created as decimal(9,2) default 0
  • FTopCategoryPage
  • FishTankHolder
  • HomePage
  • ErrorPage
  • RedirectorPage
  • VirtualPage
  • FishTankPage
  • Image
  • Folder
  • Image_Cached
    • GET /SilverStripe-v2.4.5/dev/build/

    [Warning] pg_query(): Query failed: ERROR: check constraint "SiteTree_ClassName_check" is violated by some row

    GET /SilverStripe-v2.4.5/dev/build/

    Line 187 in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\SilverStripe-v2.4.5\postgresql\code\PostgreSQLDatabase.php

    Source

    178 		if(isset($_REQUEST['previewwrite']) && in_array(strtolower(substr($sql,0,strpos($sql,' '))), array('insert','update','delete','replace'))) {
179 			Debug::message("Will execute: $sql");
180 			return;
181 		}
182 
183 		if(isset($_REQUEST['showqueries'])) { 
184 			$starttime = microtime(true);
185 		}
186 
187 		$handle = pg_query($this->dbConn, $sql);
188 		
189 		if(isset($_REQUEST['showqueries'])) {
190 			$endtime = round(microtime(true) - $starttime,4);
191 			Debug::message("\n$sql\n{$endtime}ms\n", false);
192 		}
193

    Trace