[imp] Problems with prefs sql.php driver and Postgresql

Edwin Chiu Edwin.Chiu@e-wares.com
Wed, 18 Jul 2001 16:01:54 -0400


Fix by using rev 1.18 of horde-cvs/lib/Prefs/sql.php
Current rev is 1.20

Ed

Edwin Chiu wrote:
> 
> Hi,
> 
> I'm using php-4.0.6, PEAR.php from CVS and postgresql 7.1.x
> 
> I'm getting this in my postgresql debug log:
> 
> DEBUG:  connection: host=127.0.0.1 user=hordemgr_cvs database=horde_cvs
> DEBUG:  InitPostgres
> DEBUG:  StartTransactionCommand
> DEBUG:  query: insert into horde_prefs (uid, scope, pref_name, pref_value)
> values(dns, imp, max_msgs, 25)
> ERROR:  Attribute 'dns' not found
> DEBUG:  AbortCurrentTransaction
> DEBUG:  StartTransactionCommand
> DEBUG:  query: update horde_prefs set pref_value = 25 where uid = dns and
> pref_name = max_msgs and scope = imp
> ERROR:  Attribute 'dns' not found
> DEBUG:  AbortCurrentTransaction
> DEBUG:  StartTransactionCommand
> DEBUG:  query: BEGIN;ROLLBACK;
> DEBUG:  parse tree:
> 
> Magic quotes are off.... I think some of the values have to be quoted...
> 
> i.e.
> 
> update horde_prefs set pref_value = 25 where uid = 'dns' and
>  pref_name = 'max_msgs' and scope = 'imp'
>