Hi Bruno, On Fri, May 31, 2002 at 01:00:22PM +0200, Bruno Arliguy wrote:
in the file "OpenTRS-schema.mysql.sql", the table "user_preferences" is describe like this : [...] it's better to describe like this :
CREATE TABLE user_preferences ( user_id INTEGER NOT NULL, preferences_key VARCHAR (100) NOT NULL, preferences_value VARCHAR (250), PRIMARY KEY(user_id,preferences_key) );
else we can't save user preference because there is an "ERROR 1062: Duplicate entry '2' for key 1" in this table
You are right. It's a bug. It will be fixed in Beta6. Thanks a lot. Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972