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   1433 Views

Avatar
stephf

19 September 2010 at 2:49pm Community Member, 3 Posts

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

19 September 2010 at 4:27pm Forum Moderator, 5511 Posts

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

20 September 2010 at 3:15am Community Member, 3 Posts

Thanks Will,

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

Avatar
Willr

20 September 2010 at 7:39pm Forum Moderator, 5511 Posts

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

CREATE TABLE "SiteTree_versions";

Avatar
Sean

20 September 2010 at 8:04pm (Last edited: 20 September 2010 8:05pm), Forum Moderator, 921 Posts

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

21 September 2010 at 6:51am Community Member, 3 Posts

Hi Sean,

You're the man!

The install went through without any issue.

THANK YOU!

Stephf

Avatar
Sean

21 September 2010 at 9:21am (Last edited: 21 September 2010 9:21am), Forum Moderator, 921 Posts

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

Sean