[support] Drupal-Postgres-LDAP-FreeBSD

[Greg Knaddison - GVS]

On 6/22/06, David King <dking at ketralnis.com> wrote:
> I tried upgrading to postgres 8.1 instead of 8.0 to no avail. Does
> anyone have any ideas? I can do additional debugging

I´m just guess here, but it appears to me that the query it is
executing is malformed in some way.  Were I you, I´d redo the
installation on a test site and try executing this query that has the
problem.  The DB may give you a more explicit explanation (maybe not)
and then you can just try deleting sections of the query until it
works and then dive into the section that you removed last (i.e. the
offending bit) until you see the syntax error.


> > query: UPDATE users SET uid = '2', name = 'dking', pass =
> > '47c6b15aca93873f58522f26300d181d', mail =
> > 'dking@<censored=domain>', mode = '0', sort = '0', threshold = '0',
> > theme = '', signature = '', created = '1150424378', changed =
> > '1150424378', status = '1', timezone = '', language = '', picture =
> > '', init = '', data = 'a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s:
> > 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=dn>";}',
> > data = 'a:3:{s:5:"roles";a:1:{i:0;s:1:"2";}s:
> > 17:"ldap_authentified";b:1;s:7:"ldap_dn";s:38:"<censored=dn>";}',
> > changed = 1150424379 WHERE uid = 2 in /usr/local/www/drupal/
> > includes/database.pgsql.inc on line 62.
> >
> > The errors seem to alternate between those two.
> >


If you are still having trouble after that exercise, you may have
better luck asking a pgsql expert or on a pgsql list because drupal
users are mostly mysql folks so it´s hard to find a pgsql debugger
around these parts...

Best luck,
Greg

-- 
Greg Knaddison | Growing Venture Solutions
Denver, CO | http://growingventuresolutions.com
Technology Solutions for Communities, Individuals, and Small Businesses