[geeklog-users] Geeklog 2.0.0b1 installation error (syntax error at or near "s" at character 275)

[Dirk Haun]

Darren Spruell wrote:

> Ran into an error in the 2.0.0b1 installer setting up DB:
> 
> Warning: pg_query(): Query failed: ERROR: syntax error at or near "s"
> LINE 1: ...bid_seq')),1,'whats_new_block','gldefault','What\'s
> New',30,... ^ in
> /var/www/geeklog-2.0.0b1/system/databases/pgsql.class.php on line 350
(…)
> PostgreSQL 9.1.2


Finally figured this one out (I'm not a Postgres expert …):

As of Postgres 9.1, the option standard_conforming_strings defaults to "on", which means that Postgres will not recognise the backslash as an escape symbol. I tried fixing this in the install data, but ran into similar problems later on.

So, currently, Geeklog requires that standard_conforming_strings = off in Postgres. Doesn't look like we can get that fixed in time for the 2.0.0 release, sorry.

Once you're over that hurdle, there are more Postgres-specific problems lurking. I'm trying to fix what I can for the second 2.0.0 beta, but we could really need some help here from someone who's more familiar with Postgres. Any takers?

bye, Dirk


-- 
http://www.themobilepresenter.com/