[imp] change settings as user

[Lars Kirchhoff]

thank you for this hint. this worked out. I created this table by myself and
made only the pref_uid as primary key, after the described problems with the 
db scripts and mysql 3.22.xx with primary key longer than 255. After switching 
to the varchar(200) and setting the pref_scope and pref_name primary as well, 
the settings are now beeing saved in the db with the right pref_scope, 
pref_name and pref_uid.

Quoting Metee Khanongnuch <may@yipintsoi.com>:

> 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 -------------------
> 
> 
> 
> -- 
> IMP mailing list: http://horde.org/imp/
> Archive: http://marc.theaimsgroup.com/?l=imp&r=1&w=2
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> 
> 




-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/