[dev] Error in preferences/database?

Michael Bull mbull@uoguelph.ca
Tue, 14 Nov 2000 09:44:55 -0500


At 04:11 PM 13/11/2000 -0600, you wrote:
>Mine was already set this way, and I'm getting the same error (Warning:
>PostgreSQL query failed: ERROR: Cannot insert a duplicate key into a unique
>index in DB/pgsql.php on line 163).  I get the error whenever I try to change
>any value in the preferences in IMP 2.3 (CVS checked out less than 20 minutes
>ago).  For instance, I can enter my full name, but whenever I try to 
>change one
>of those, I get that error.  I set my database up according to
>horde/imp/scripts/db/prefs.sql (save the pref_value line: I had to change it
>to "pref_value text," as Postgres didn't like the "null" after the word
>"text") and I am using Postgres 6.5.3.  If I do a list of that database, 
>here is
>the output:
>
>  +------------------+----------------------------------+----------+
>  |  Owner           |             Relation             |   Type   |
>  +------------------+----------------------------------+----------+
>  | postgres         | auth                             | table    |
>  | postgres         | auth_pkey                        | index    |
>  | postgres         | user_webmail_prefs               | table    |
>  | postgres         | user_webmail_prefs_pkey          | index    |
>  +------------------+----------------------------------+----------+
>
>I'd like to get this resolved also but the above suggestion doesn't 
>work/apply
>to me...?

It didn't for me either, in the end; I feel a bit better now knowing that 
the problem wasn't on my end.  I'm going to try and poke around today and 
see if I can figure anything more about it, but Max did some looking 
earlier and confirmed it exists, though he feels it's with PEAR;

BTW -- I tried changing the driver to pgsql, I still recieved the same 
error.   Can you confirm if the same thing happens with your install, Keith?