4649 Posts in 1402 Topics by 1394 members
Installing SilverStripe
SilverStripe Forums » Installing SilverStripe » Problem installing with Postgres, fails[Warning] pg_query(): Query failed: ERROR:
Getting SilverStripe up and running on your computer and on your web server.
Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 1186 Views |
-
Problem installing with Postgres, fails[Warning] pg_query(): Query failed: ERROR:

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.4I can start the installation but it fails see below the page I got.
Please help!
Stephf
-
Re: Problem installing with Postgres, fails[Warning] pg_query(): Query failed: ERROR:

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.
-
Re: Problem installing with Postgres, fails[Warning] pg_query(): Query failed: ERROR:

20 September 2010 at 3:15am
Thanks Will,
Tried that but still with error, see the attachment...
-
Re: Problem installing with Postgres, fails[Warning] pg_query(): Query failed: ERROR:

20 September 2010 at 7:39pm
Try perhaps creating it manually by executing the following SQL on your database.
CREATE TABLE "SiteTree_versions";
-
Re: Problem installing with Postgres, fails[Warning] pg_query(): Query failed: ERROR:

20 September 2010 at 8:04pm Last edited: 20 September 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 buildbot.silverstripe.org
Cheers,
Sean - SilverStripe 2.4.2 RC2: http://www.silverstripe.org/assets/downloads/SilverStripe-v2.4.2-rc2.tar.gz
-
Re: Problem installing with Postgres, fails[Warning] pg_query(): Query failed: ERROR:

21 September 2010 at 6:51am
Hi Sean,
You're the man!
The install went through without any issue.
THANK YOU!
Stephf
-
Re: Problem installing with Postgres, fails[Warning] pg_query(): Query failed: ERROR:

21 September 2010 at 9:21am Last edited: 21 September 2010 9:21am
Awesome, great to hear it works for you.
Sean
| 1186 Views | ||
|
Page:
1
|
Go to Top |



