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.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Installing SilverStripe /

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

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

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


Go to End


7 Posts   2196 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, 5523 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, 5523 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.

These should work. They pass continuous integration builds at buildbot.silverstripe.org

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