Problems with prefs sql.php driver and Postgresql

[Edwin Chiu]

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'


--
Edwin Chiu             | Principal Consultant  | tel: (416)260-9625 x247
Edwin.Chiu@e-wares.com | E-wares Inc.          | http://www.e-wares.com