Change type of group field in sys_user table to text
ALTER TABLE sys_user
CHANGE groups
groups
TEXT CHARACTER SET
utf8 COLLATE utf8_general_ci NOT NULL;
CREATE TABLE IF NOT EXISTS sys_user
(
userid
int(11) unsigned NOT NULL AUTO_INCREMENT,
sys_userid
int(11) unsigned NOT NULL DEFAULT '1',
sys_groupid
int(11) unsigned NOT NULL DEFAULT '1',
sys_perm_user
varchar(5) NOT NULL DEFAULT 'riud',
sys_perm_group
varchar(5) NOT NULL DEFAULT 'riud',
sys_perm_other
varchar(5) NOT NULL DEFAULT '',
username
varchar(64) NOT NULL DEFAULT '',
passwort
varchar(64) NOT NULL DEFAULT '',
modules
varchar(255) NOT NULL DEFAULT '',
startmodule
varchar(255) NOT NULL DEFAULT '',
app_theme
varchar(32) NOT NULL DEFAULT 'default',
typ
varchar(16) NOT NULL DEFAULT 'user',
active
tinyint(1) NOT NULL DEFAULT '1',
language
varchar(2) NOT NULL DEFAULT 'de',
groups
text NOT NULL,
default_group
int(11) unsigned NOT NULL DEFAULT '0',
client_id
int(11) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (userid
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;