[geeklog-users] Geeklog 2.0.0b1 installation error (syntax error at or near "s" at character 275)
Darren Spruell
phatbuckett at gmail.com
Wed May 30 14:04:20 EDT 2012
Hi,
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
New',30,'','','epoch',0,'',4,2,3,3,2,2)
System specs:
Geeklog 2.0.0b1
OpenBSD 5.1 i386
PostgreSQL 9.1.2
PHP 5.3.10 / Zend Engine v2.3.0
php-pgsql-5.3.10
Apache/1.3.29
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
More information about the geeklog-users
mailing list