[imp] change settings as user

[Metee Khanongnuch]

How do  you create table horde_prefs, are you use file "prefs.sql" in directory horde/scripts/db for
create it or not ?
I think primary key of horde_prefs may be wrong, it should be has primary key (pref_uid, pref_scope,
pref_name) but if I don't miss mysql 3.22.xx can't create primary longer than 256
(pref_uid+pref_scope+pref_name = 255+16+32 = too long)

Solution:
1. Use mysql new version (mysql 3.23.xx) or
2. modify file "prefs.sql", reduce size of prefs_uid to 200 and recreate this table again.

---
create table horde_prefs (
    pref_uid           char(255) not null,       <----- Change value 255 to 200
    pref_scope      char(16) not null default '',
----

----- Original Message -----
From: "Lars Kirchhoff" <lkirchhoff@ieb.net>
To: <imp@lists.horde.org>
Sent: Tuesday, January 22, 2002 7:57 PM
Subject: [imp] change settings as user


> hello,
>
> i'm sorry to annoy you again, but i still run against a wall. I'm setup
> imp 3 with the new horde and nearly everything is running fine apart the
> setting/preference system.
> As user I could change my identity settings. This worked as well after a
> new login. But every other setting is only changed within the session. For
> example, i would like to change the the last login setting. After settings
> this, i was looking in the horde_prefs table, but didn't found anything that
> showed me that this setting was saved in the db. I was doublechecking
> this with the identity settings, where I could see a change in the db.
>
> so what can be wrong with the db or preference interface?
>
> i'm using mysql 3.22.32 and php 4.1.1 on a suse 6.4 system.
>
> Lars Kirchhoff
>
> ------------------------------------------------------------
> Institute of Electronic Business e.V.
> An-Institut der Universtität der Künste Berlin
> Chausseestr. 8, Aufgang E
> 10115 Berlin
> Tel.: 030/ 72 62 983-20
> Fax:  030/ 72 62 983-9
> E-Mail: lkirchhoff@ieb.net
>
> --------------------- http://www.ieb.net -------------------