Environment Builder

http://localhost/solr-test/

dev → build

Building database solr-test using PostgreSQL 9.1.9

Creating database tables

  • Email_BounceRecord
  • File
  • Folder
  • Image
  • Image_Cached
  • Group
  • LoginAttempt
  • Member
  • MemberPassword
  • Permission
  • PermissionRole
  • PermissionRoleCode
  • SiteConfig
  • SiteTree
  • Field SiteTree.ClassName: changed to varchar(255) default 'Page' check ("ClassName" in ('Page', 'ErrorPage', 'SiteTree', 'RedirectorPage', 'VirtualPage', 'SolrSearchPage')) (from varchar(255) default 'Page' check ("ClassName" in ('Page', 'ErrorPage', 'SiteTree', 'RedirectorPage', 'VirtualPage')))
  • Field SiteTree_Live.ClassName: changed to varchar(255) default 'Page' check ("ClassName" in ('Page', 'ErrorPage', 'SiteTree', 'RedirectorPage', 'VirtualPage', 'SolrSearchPage')) (from varchar(255) default 'Page' check ("ClassName" in ('Page', 'ErrorPage', 'SiteTree', 'RedirectorPage', 'VirtualPage')))
  • Field SiteTree_versions.ClassName: changed to varchar(255) default 'Page' check ("ClassName" in ('Page', 'ErrorPage', 'SiteTree', 'RedirectorPage', 'VirtualPage', 'SolrSearchPage')) (from varchar(255) default 'Page' check ("ClassName" in ('Page', 'ErrorPage', 'SiteTree', 'RedirectorPage', 'VirtualPage')))
  • Page
  • ErrorPage
  • RedirectorPage
  • VirtualPage
  • SolrSearchPage
  • Table SolrSearchPage: created
  • Field SolrSearchPage.ID: created as serial8 not null
  • Field SolrSearchPage.ResultsPerPage: created as integer default 0
  • Field SolrSearchPage.SortBy: created as varchar(64)
  • Field SolrSearchPage.SortDir: created as varchar(255) default 'Ascending' check ("SortDir" in ('Ascending', 'Descending'))
  • Field SolrSearchPage.QueryType: created as varchar(50)
  • Field SolrSearchPage.StartWithListing: created as smallint default 0
  • Field SolrSearchPage.MinFacetCount: created as integer default 0
  • Field SolrSearchPage.GeoRestrictionField: created as varchar(64)
  • Field SolrSearchPage.GeoRadius: created as float
  • Field SolrSearchPage.DistanceSort: created as varchar(255) default 'asc' check ("DistanceSort" in ('', 'asc', 'desc'))
  • Field SolrSearchPage.ListingTemplateID: created as integer default 0
  • Field SolrSearchPage.SearchTypeValue: created as text
  • Field SolrSearchPage.SearchOnFieldsValue: created as text
  • Field SolrSearchPage.BoostFieldsValue: created as text
  • Field SolrSearchPage.BoostMatchFieldsValue: created as text
  • Field SolrSearchPage.FacetFieldsValue: created as text
  • Field SolrSearchPage.FacetMappingValue: created as text
  • Field SolrSearchPage.FacetQueriesValue: created as text
  • Field SolrSearchPage.FilterFieldsValue: created as text
  • Field SolrSearchPage.GeoCentre: created as point
  • Table SolrSearchPage_SearchTrees: created
  • Field SolrSearchPage_SearchTrees.ID: created as serial8 not null
  • Field SolrSearchPage_SearchTrees.SolrSearchPageID: created as integer default 0
  • Field SolrSearchPage_SearchTrees.PageID: created as integer default 0
  • Index SolrSearchPage_SearchTrees.SolrSearchPageID: created as ("SolrSearchPageID")
  • Index SolrSearchPage_SearchTrees.PageID: created as ("PageID")
  • Table SolrSearchPage_Live: created
  • Field SolrSearchPage_Live.ID: created as serial8 not null
  • Field SolrSearchPage_Live.ResultsPerPage: created as integer default 0
  • Field SolrSearchPage_Live.SortBy: created as varchar(64)
  • Field SolrSearchPage_Live.SortDir: created as varchar(255) default 'Ascending' check ("SortDir" in ('Ascending', 'Descending'))
  • Field SolrSearchPage_Live.QueryType: created as varchar(50)
  • Field SolrSearchPage_Live.StartWithListing: created as smallint default 0
  • Field SolrSearchPage_Live.MinFacetCount: created as integer default 0
  • Field SolrSearchPage_Live.GeoRestrictionField: created as varchar(64)
  • Field SolrSearchPage_Live.GeoRadius: created as float
  • Field SolrSearchPage_Live.DistanceSort: created as varchar(255) default 'asc' check ("DistanceSort" in ('', 'asc', 'desc'))
  • Field SolrSearchPage_Live.ListingTemplateID: created as integer default 0
  • Field SolrSearchPage_Live.SearchTypeValue: created as text
  • Field SolrSearchPage_Live.SearchOnFieldsValue: created as text
  • Field SolrSearchPage_Live.BoostFieldsValue: created as text
  • Field SolrSearchPage_Live.BoostMatchFieldsValue: created as text
  • Field SolrSearchPage_Live.FacetFieldsValue: created as text
  • Field SolrSearchPage_Live.FacetMappingValue: created as text
  • Field SolrSearchPage_Live.FacetQueriesValue: created as text
  • Field SolrSearchPage_Live.FilterFieldsValue: created as text
  • Field SolrSearchPage_Live.GeoCentre: created as point
  • Table SolrSearchPage_versions: created
  • Field SolrSearchPage_versions.ID: created as serial8 not null
  • Field SolrSearchPage_versions.RecordID: created as integer default 0
  • Field SolrSearchPage_versions.Version: created as integer default 0
  • Field SolrSearchPage_versions.ResultsPerPage: created as integer default 0
  • Field SolrSearchPage_versions.SortBy: created as varchar(64)
  • Field SolrSearchPage_versions.SortDir: created as varchar(255) default 'Ascending' check ("SortDir" in ('Ascending', 'Descending'))
  • Field SolrSearchPage_versions.QueryType: created as varchar(50)
  • Field SolrSearchPage_versions.StartWithListing: created as smallint default 0
  • Field SolrSearchPage_versions.MinFacetCount: created as integer default 0
  • Field SolrSearchPage_versions.GeoRestrictionField: created as varchar(64)
  • Field SolrSearchPage_versions.GeoRadius: created as float
  • Field SolrSearchPage_versions.DistanceSort: created as varchar(255) default 'asc' check ("DistanceSort" in ('', 'asc', 'desc'))
  • Field SolrSearchPage_versions.ListingTemplateID: created as integer default 0
  • Field SolrSearchPage_versions.SearchTypeValue: created as text
  • Field SolrSearchPage_versions.SearchOnFieldsValue: created as text
  • Field SolrSearchPage_versions.BoostFieldsValue: created as text
  • Field SolrSearchPage_versions.BoostMatchFieldsValue: created as text
  • Field SolrSearchPage_versions.FacetFieldsValue: created as text
  • Field SolrSearchPage_versions.FacetMappingValue: created as text
  • Field SolrSearchPage_versions.FacetQueriesValue: created as text
  • Field SolrSearchPage_versions.FilterFieldsValue: created as text
  • Field SolrSearchPage_versions.GeoCentre: created as point
  • Index SolrSearchPage_versions.RecordID_Version: created as unique ("RecordID","Version")
  • Index SolrSearchPage_versions.RecordID: created as ("RecordID")
  • Index SolrSearchPage_versions.Version: created as ("Version")
  • SolrServerConfig
  • Table SolrServerConfig: created
  • Field SolrServerConfig.ID: created as serial8 not null
  • Field SolrServerConfig.ClassName: created as varchar(255) default 'SolrServerConfig' check ("ClassName" in ('SolrServerConfig'))
  • Field SolrServerConfig.Created: created as timestamp
  • Field SolrServerConfig.LastEdited: created as timestamp
  • Field SolrServerConfig.RunLocal: created as smallint default 0
  • Field SolrServerConfig.InstanceID: created as varchar(64)
  • Field SolrServerConfig.LogPath: created as varchar(128)
  • Index SolrServerConfig.ClassName: created as ("ClassName")
  • SolrTypeConfiguration
  • Table SolrTypeConfiguration: created
  • Field SolrTypeConfiguration.ID: created as serial8 not null
  • Field SolrTypeConfiguration.ClassName: created as varchar(255) default 'SolrTypeConfiguration' check ("ClassName" in ('SolrTypeConfiguration'))
  • Field SolrTypeConfiguration.Created: created as timestamp
  • Field SolrTypeConfiguration.LastEdited: created as timestamp
  • Field SolrTypeConfiguration.Title: created as varchar(50)
  • Field SolrTypeConfiguration.FieldMappingsValue: created as text
  • Index SolrTypeConfiguration.ClassName: created as ("ClassName")
  • Creating database records

  • Email_BounceRecord
  • File
  • Folder
  • Image
  • Image_Cached
  • Group
  • LoginAttempt
  • Member
  • MemberPassword
  • Permission
  • PermissionRole
  • PermissionRoleCode
  • SiteConfig
  • SiteTree
  • Page
  • ErrorPage
  • RedirectorPage
  • VirtualPage
  • SolrSearchPage
  • GET /solr-test/dev/build

    [Warning] pg_query(): Query failed: ERROR: column "geocentre" does not exist LINE 1: ...ue", "SolrSearchPage"."FilterFieldsValue", AsText(GeoCentre)... ^

    GET /solr-test/dev/build

    Line 241 in /var/www/solr-test/postgresql/code/PostgreSQLDatabase.php

    Source

    232 		if(isset($_REQUEST['previewwrite']) && in_array(strtolower(substr($sql,0,strpos($sql,' '))), array('insert','update','delete','replace'))) {
    233 			Debug::message("Will execute: $sql");
    234 			return;
    235 		}
    236 
    237 		if(isset($_REQUEST['showqueries'])) {
    238 			$starttime = microtime(true);
    239 		}
    240 
    241 		$handle = pg_query($this->dbConn, $sql);
    242 
    243 		if(isset($_REQUEST['showqueries'])) {
    244 			$endtime = round((microtime(true) - $starttime) * 1000, 1);
    245 			Debug::message("\n$sql\n{$endtime}ms\n", false);
    246 		}
    247 
    

    Trace

    GET /solr-test/dev/build

    [User Error] Couldn't run query: SELECT DISTINCT "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"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."ParentID", "SolrSearchPage"."ResultsPerPage", "SolrSearchPage"."SortBy", "SolrSearchPage"."SortDir", "SolrSearchPage"."QueryType", "SolrSearchPage"."StartWithListing", "SolrSearchPage"."MinFacetCount", "SolrSearchPage"."GeoRestrictionField", "SolrSearchPage"."GeoRadius", "SolrSearchPage"."DistanceSort", "SolrSearchPage"."ListingTemplateID", "SolrSearchPage"."SearchTypeValue", "SolrSearchPage"."SearchOnFieldsValue", "SolrSearchPage"."BoostFieldsValue", "SolrSearchPage"."BoostMatchFieldsValue", "SolrSearchPage"."FacetFieldsValue", "SolrSearchPage"."FacetMappingValue", "SolrSearchPage"."FacetQueriesValue", "SolrSearchPage"."FilterFieldsValue", AsText(GeoCentre) AS "GeoCentre", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "SolrSearchPage" ON "SolrSearchPage"."ID" = "SiteTree"."ID" WHERE ("SiteTree"."ClassName" IN ('SolrSearchPage')) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 | ERROR: column "geocentre" does not exist LINE 1: ...ue", "SolrSearchPage"."FilterFieldsValue", AsText(GeoCentre)... ^

    GET /solr-test/dev/build

    Line 693 in /var/www/solr-test/framework/model/Database.php

    Source

    684 	/**
    685 	 * Error handler for database errors.
    686 	 * All database errors will call this function to report the error.  It isn't a static function;
    687 	 * it will be called on the object itself and as such can be overridden in a subclass.
    688 	 * @todo hook this into a more well-structured error handling system.
    689 	 * @param string $msg The error message.
    690 	 * @param int $errorLevel The level of the error to throw.
    691 	 */
    692 	public function databaseError($msg, $errorLevel = E_USER_ERROR) {
    693 		user_error($msg, $errorLevel);
    694 	}
    695 	
    696 	/**
    697 	 * Enable supression of database messages.
    698 	 */
    699 	public function quiet() {
    

    Trace

    GET /solr-test/dev/build

    [Warning] pg_fetch_assoc() expects parameter 1 to be resource, boolean given

    GET /solr-test/dev/build

    Line 2242 in /var/www/solr-test/postgresql/code/PostgreSQLDatabase.php

    Source

    2233 	public function seek($row) {
    2234 		return pg_result_seek($this->handle, $row);
    2235 	}
    2236 
    2237 	public function numRecords() {
    2238 		return pg_num_rows($this->handle);
    2239 	}
    2240 
    2241 	public function nextRecord() {
    2242 		if($data = pg_fetch_assoc($this->handle)) {
    2243 			return $data;
    2244 		} else {
    2245 			return false;
    2246 		}
    2247 	}
    2248 
    

    Trace

  • Search page created
  • SolrServerConfig
  • SolrTypeConfiguration
  • Database build completed!