Saving preferences in PostgreSql

René Jensen lundeman@tbkol.dk
Wed, 15 Aug 2001 09:55:40 +0200


Hi There

I'm having some problems saving my preferences in IMP 2.3.7-cvs
(I updated pear yesterday from CVS)

If I edit an identity and press Create postgres logs the following:

DEBUG:  query: insert into horde_prefs (uid, scope, pref_name, pref_value)
values(lundeman@tbkol.dk, horde, identities,
a:1:{i:0;a:7:{s:2:"id";s:16:"Default identity";s:8:"fullname";s:11:"René
Jensen";s:9:"from_addr";s:0:"";s:12:"replyto_addr";s:0:"";s:9:"signature";s:
0:"";s:10:"sig_dashes";i:0;s:9:"sig_first";i:0;}})
ERROR:  parser: parse error at or near ":"
DEBUG:  AbortCurrentTransaction
DEBUG:  StartTransactionCommand
DEBUG:  query: update horde_prefs set pref_value =
a:1:{i:0;a:7:{s:2:"id";s:16:"Default identity";s:8:"fullname";s:11:"René
Jensen";s:9:"from_addr";s:0:"";s:12:"replyto_addr";s:0:"";s:9:"signature";s:
0:"";s:10:"sig_dashes";i:0;s:9:"sig_first";i:0;}} where uid =
lundeman@tbkol.dk and pref_name = identities and scope = horde
ERROR:  parser: parse error at or near ":"
DEBUG:  AbortCurrentTransaction
DEBUG:  StartTransactionCommand
DEBUG:  query: BEGIN;ROLLBACK;


I have NO idea of what all these s-numbers are doing there, but I expect
they are there for a reason. But shouldn't all the value-parameters be
enclosed in '' ..??

This is the last thing I need to get working before my IMP is working
perfekt.
But then again database support, I think, is a very importent thing to IMP,
even though it can run without it...

Once again.. I really like this new IMP.

               _\|/_
               (@ @)
-----------oOOo-(_)-oOOo-----------
If you have to get used to it...
           ...it's not good enough.
-----------------------------------
            René Jensen
         lundeman@tbkol.dk