[geeklog-devel] [geeklog-users] Geeklog 2.0.0b1 installation error (syntax error at or near "s" at character 275)
dirk at haun-online.de
Wed May 30 15:37:55 EDT 2012
FWIW, I'm getting a different error, but that seems to be from much later in the install (first call of COM_siteHeader / COM_showBlocks, according to the call stack):
pg_query(): Query failed: ERROR: operator does not exist: character varying = integer LINE 1: ..._assignments ta WHERE ta.type = 'block' AND ta.id = bid AND ... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. @ .../postgres/system/databases/pgsql.class.php line 350
That's with PostgreSQL 8.4.11 and I think it's complaining about comparing a topic_assignment id (a varchar(40)) with the block bid (a SERIAL).
Looks like the Postgres support needs some more testing ...
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
>> From Postgres log:
> ERROR: syntax error at or near "s" at character 275
> STATEMENT: INSERT INTO gl_blocks (bid, is_enabled, name, type, title,
> blockorder, content, rdfurl, rdfupdated, onleft, phpblockfn, group_id,
> owner_id, perm_owner, perm_group, perm_members, perm_anon) VALUES
> ((SELECT NEXTVAL('gl_blocks_bid_seq')),1,'whats_new_block','gldefault','What\'s
> System specs:
> Geeklog 2.0.0b1
> OpenBSD 5.1 i386
> PostgreSQL 9.1.2
> PHP 5.3.10 / Zend Engine v2.3.0
> This request in installer was the one that triggered the DB failure:
> GET http://<site>/portal/admin/install/index.php?mode=install&step=3&dbconfig_path=/var/www/geeklog-2.0.0b1/db-config.php&install_plugins=&language=english&site_name=XXX&site_slogan=XXX&site_url=http%3A%2F%2FXXX%2Fportal&site_admin_url=http%3A%2F%2FXXX%2Fportal%2Fadmin&site_mail=XXX&noreply_mail=XXX
> Known issue?
> Darren Spruell
> phatbuckett at gmail.com
> geeklog-users mailing list
> geeklog-users at lists.geeklog.net
More information about the geeklog-devel