2 problems really, but both on the same platform (Linux, bitnami "LAPP" image) .
1) First 2.4.1
I get everything set up fine, create the database and the install.php sees that postgres is a valid option, but then ....
[Warning] pg_query() [function.pg-query]: Query failed: ERROR: relation "SiteTree_versions" does not exist LINE 2: FROM "SiteTree_versions" GROUP BY "RecordID", "Version... ^
POST /silverstripe-v2.4.1/install.php
Line 174 in /opt/bitnami/apache2/htdocs/silverstripe-v2.4.1/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
* pg_query(Resource id #1078,SELECT MIN("ID") AS "ID", "RecordID", "Version" FROM "SiteTree_versions" GROUP BY "RecordID", "Version" HAVING COUNT(*) > 1)
Line 174 of PostgreSQLDatabase.php
* PostgreSQLDatabase->query(SELECT MIN("ID") AS "ID", "RecordID", "Version" FROM "SiteTree_versions" GROUP BY "RecordID", "Version" HAVING COUNT(*) > 1,256)
Line 127 of DB.php
* DB::query(SELECT MIN("ID") AS "ID", "RecordID", "Version" FROM "SiteTree_versions" GROUP BY "RecordID", "Version" HAVING COUNT(*) > 1)
Line 303 of Versioned.php
* Versioned->augmentDatabase(,,,,,,)
Line 963 of Object.php
* Object->extend(augmentDatabase,)
Line 3011 of DataObject.php
* DataObject->requireTable()
Line 209 of DatabaseAdmin.php
* DatabaseAdmin->doBuild(1)
Line 1056 of install.php
* Installer->install(Array)
Line 201 of install.php
Am I guessing right that this is a case sensitivity problem on CREATE TABLE? I'm not really experienced with PHP so not sure where to look in the code foe the table names etc.
2) Seond on silverstripe.2.0.DailyBuild.2010-08-12
I don't get the option of postgresql, but then I'm not sure what module I need to load, and only tried this in the hope that it fixed (1).
Happy to be testing this out for you guys, but I think I need some help!