« Return to Thread: 1.4.15 and sql based user_prefs not working ?

Re: 1.4.15 and sql based user_prefs not working ?

by Tomas Kuliavas :: Rate this Message:

Reply to Author | View in Thread

Benny Pedersen wrote:
well i found this is the problem, when i use filebased user prefs all is
working with the identity, but when i add sql based user_prefs i get
multiple  pref_key and pref_val pr user

INSERT INTO `userprefs` VALUES('me@junc.org', 'trash_folder', 'Trash');
INSERT INTO `userprefs` VALUES('me@junc.org', 'trash_folder', 'Trash');
INSERT INTO `userprefs` VALUES('me@junc.org', 'trash_folder', 'Trash');
INSERT INTO `userprefs` VALUES('me@junc.org', 'trash_folder', 'Trash');
INSERT INTO `userprefs` VALUES('me@junc.org', 'trash_folder', 'Trash');
INSERT INTO `userprefs` VALUES('me@junc.org', 'trash_folder', 'Trash');
INSERT INTO `userprefs` VALUES('me@junc.org', 'sent_folder', 'Sent');
INSERT INTO `userprefs` VALUES('me@junc.org', 'sent_folder', 'Sent');
INSERT INTO `userprefs` VALUES('me@junc.org', 'sent_folder', 'Sent');
INSERT INTO `userprefs` VALUES('me@junc.org', 'sent_folder', 'Sent');
INSERT INTO `userprefs` VALUES('me@junc.org', 'sent_folder', 'Sent');
INSERT INTO `userprefs` VALUES('me@junc.org', 'mailfetch_newlog', 'on');
INSERT INTO `userprefs` VALUES('me@junc.org', 'mailfetch_newlog', 'on');

something like this above :/

i dont know if this olso goes for older versions of squirrelmail, but
1.4.15 is the first that shows me the problem in identity :(

i tryed to find info on how to configure sql prefs but no info in the
tarball about it :(
See http://www.squirrelmail.org/docs/admin/admin-5.html#ss5.7

You haven't set primary key for userprefs table.


 « Return to Thread: 1.4.15 and sql based user_prefs not working ?

LightInTheBox - Buy quality products at wholesale price!