in the file "OpenTRS-schema.mysql.sql", the table "user_preferences" is
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)
);
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
