[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'
>