the latest changeset in the repo adds a little more logging for when a save fails, that might help you track down whats wrong.
also i'm assuming that as well as creating the database you created the tables with the proper structure and put the field names in the plugin config right?
Thanks :-)
Well, I followed:
UsingSQL - Spamassassin Wiki - more particular the
CREATE TABLE `userpref` (
`id` int(8) unsigned NOT NULL auto_increment,
`username` varchar(128) NOT NULL default '',
`preference` varchar(64) NOT NULL default '',
`value` varchar(128) default NULL,
`descript` varchar(128) default NULL,
`added` datetime NOT NULL default '2003-01-01 00:00:00',
`added_by` varchar(128) NOT NULL default '',
`modified` timestamp(14) NOT NULL,
UNIQUE KEY `id` (`id`),
KEY `type` (`preference`),
KEY `added_by` (`added_by`),
KEY `preference` (`preference`),
KEY `username` (`username`)
) TYPE=MyISAM COMMENT='Spamassassin Preferences';
I have checked config.inc.php and they apply the defaults of: userpref, username, preference and value.
I downloaded the new sauserprefs.php from github and put it on my virtual machine.
The following output was then saved to the errors log:
[13-May-2011 11:38:15 +0200]: sauserprefs error: cannot update "ok_languages" = "af sq am ar hy eu bs bg be ca zh hr cs da nl en eo et fi fr fy ka de el he hi hu is id ga it ja ko la lv lt ms mr ne no fa pl pt ru th" for anders
[13-May-2011 11:39:05 +0200]: sauserprefs error: cannot update "ok_languages" = "af sq am ar hy eu bs bg be ca zh hr cs da nl en eo et fi fr fy ka de el he hi hu is id ga it ja ko la lv lt ms mr ne no fa pl pt qu rm ro ru sa sco gd sr sk sl es sw sv tl ta th tr uk vi cy yi" for anders
[13-May-2011 11:50:14 +0200]: sauserprefs error: cannot update "ok_languages" = "af sq am ar hy eu bs bg be ca zh hr cs da nl en eo et fi fr fy ka de el he hi hu is id ga it ja ko la lv lt ms mr ne no fa pl pt ru th" for anders
[13-May-2011 11:52:19 +0200]: sauserprefs error: cannot update "ok_languages" = "af sq am ar hy eu bs bg be ca zh hr cs da nl en eo et fi fr fy ka de el he hi hu is id ga it ja ko la lv lt ms mr ne no fa pl pt ru th" for anders
[13-May-2011 11:52:29 +0200]: sauserprefs error: cannot update "ok_languages" = "af sq am ar hy eu bs bg be ca zh hr cs da nl en eo et fi fr fy ka de el he hi hu is id ga it ja ko la lv lt ms mr ne no fa pl pt qu rm ro ru sa sco gd sr sk sl es sw sv tl ta th tr uk vi cy yi" for anders
1. It seems to be a problem saving the ok_languages.
2. The db gets updated with content ok_languages.
3. Well, besides the errors I found out that if I choose no languages to be selected/accepted at all it did not give any error. Also if I only selected english and danish I could save without errors.
So I guessed that one or more of the languages led to this error (message).
Now, I checked each language almost one by one. When I came to the language "Quechua" then the error came! However I boiled down to that the "value" varchar(128) of userpref table was too short, but thanks to your errors log entries I could find that out.
So sorry that I did not think of the obvious when I look back. :-) So please state that in the readme that value entry should set accordingly to the max amount of languages times 3 or 4 (for spaces and chars). I set it to 512 and it worked like a charm.
Thank you for your help and efforts!!! :-)