https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7803
Bug ID: 7803
Summary: SQL schema of userpref table -> value
Product: Spamassassin
Version: 3.4.2
Hardware: Other
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: spamc/spamd
Assignee: dev@spamassassin.apache.org
Reporter: n...@waterend.net
Target Milestone: Undefined
The "value" column of the userpref table as defined in sql/userpref_mysql.sql
is varchar(100).
If you are looking to support a lot of potential languages (2-letter codes),
this may be > 100 characters (eg from Roundcube 1.4.3 / sauserprefs plugin).
Typical error message (from Roundcube):
DB Error: [1406] Data too long for column 'value' at row 1 (SQL Query: INSERT
INTO `userpref` (`username`, `preference`, `value`) VALUES ('neil',
'ok_languages', 'af sq am ar hy eu bs bg be ca zh zh.gb2312 zh.big5 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')) in
/var/www/html/roundcubemail-1.4.3/program/lib/Roundcube/rcube_db.php on line
543 (POST /roundcube/?_task=settings&_action=plugin.sauserprefs.save)
Workaround is to increase "value" to varchar(255)
--
You are receiving this mail because:
You are the assignee for the bug.
