Re: 1.4.15 and sql based user_prefs not working ?

> 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


-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
-----
squirrelmail-plugins mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-plugins@...
List archives: http://news.gmane.org/gmane.mail.squirrelmail.plugins
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-plugins