Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Problem installing with Postgres, fails[Warning] pg_query(): Query failed: ERROR:


Reply


7 Posts   1486 Views

Avatar
stephf

Community Member, 3 Posts

19 September 2010 at 2:49pm

Hi,

I am struggling with the installation using Postgres.
I had no problem with mySQL though.
I am using Ubuntu Server i386 10.4, with packaged postgresql 8.4

I can start the installation but it fails see below the page I got.

Please help!

Stephf

Avatar
Willr

Forum Moderator, 5513 Posts

19 September 2010 at 4:27pm

ERROR: relation "SiteTree_versions" does not exist

Sounds like it is trying to query a table before it has been created. Try leaving the install and running a /dev/build?flush=1 directly.

Avatar
stephf

Community Member, 3 Posts

20 September 2010 at 3:15am

Thanks Will,

Tried that but still with error, see the attachment...

Avatar
Willr

Forum Moderator, 5513 Posts

20 September 2010 at 7:39pm

Try perhaps creating it manually by executing the following SQL on your database.

CREATE TABLE "SiteTree_versions";

Avatar
Sean

Forum Moderator, 922 Posts

20 September 2010 at 8:04pm

Edited: 20/09/2010 8:05pm

I suggest trying the latest SilverStripe 2.4.2 RC2 with the latest postgresql/trunk version.

  • SilverStripe 2.4.2 RC2: http://www.silverstripe.org/assets/downloads/SilverStripe-v2.4.2-rc2.tar.gz
  • PostgreSQL/trunk module (at r106192): http://silverstripe.org/assets/modules/trunk/postgresql-trunk-r106192.tar.gz

These should work. They pass continuous integration builds at [url=http://buildbot.silverstripe.org]buildbot.silverstripe.org[/url]

Cheers,
Sean

Avatar
stephf

Community Member, 3 Posts

21 September 2010 at 6:51am

Hi Sean,

You're the man!

The install went through without any issue.

THANK YOU!

Stephf

Avatar
Sean

Forum Moderator, 922 Posts

21 September 2010 at 9:21am

Edited: 21/09/2010 9:21am

Awesome, great to hear it works for you. :-)

Sean