Re: [SM-PLUGINS] 1.4.15 and sql based user_prefs not working ?

[<me...@ju...>]

> See http://www.squirrelmail.org/docs/admin/admin-5.html#ss5.7
> You haven't set primary key for userprefs table.

this link solved my problem, thanks, after i see this link i remember it
was when i changed from mysql 4.0.x to 4.1.x and again later to 5.0.x that
i got problem with it and newer solved it becurse of unicode setup in
mysql :/

so at that time i deletede the keys bad thinked from me, now i got it done
this time, its olso like playing in lotto with

CREATE TABLE userprefs (
  user varchar(128) DEFAULT '' NOT NULL,
  prefkey varchar(64) DEFAULT '' NOT NULL,
  prefval BLOB DEFAULT '' NOT NULL,
  PRIMARY KEY (user,prefkey)
);

this is 4.0.x

in 4.1.x mysql is like this

CREATE TABLE `userprefs` (
  `username` varchar(128) NOT NULL,
  `prefkey` varchar(64) NOT NULL,
  `prefval` blob NOT NULL,
  PRIMARY KEY  (`username`,`prefkey`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='squirrelmail prefs setings';

user is restricted in postgresql thats why i chenged it in mysql