i upgrade to 3.1 and everything is ok. just a mistype in creat table sql query:
original
ALTER TABLE xoops_priv_msgs ADD from_delete TINYINT( 1 ) UNSIGNED NOT NULL default '0' , ADD to_delete TINYINT( 1 ) UNSIGNED NOT NULL default '0', ADD to_save TINYINT( 1 ) UNSIGNED NOT NULL default '0', ADD from_save TINYINT( 1 ) UNSIGNED NOT NULL default '0';
# wanipmhack ver3.0
# Table structure for table `priv_msgs_config`
#
CREATE TABLE xoops_priv_msgs_config (
conf_id mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
filter_ok tinyint(1) unsigned NOT NULL default '0',
filter_word tinytext NOT NULL default '',
reject_ok tinyint(1) unsigned NOT NULL default '0',
reject_reason tinytext NOT NULL default '',
blacklist tinytext NOT NULL default '',
pmsort tinyint(1) unsigned NOT NULL default '0',
pmorder tinyint(1) unsigned NOT NULL default '0',
pmlimit tinyint(3) unsigned NOT NULL default '10',
trashbox_ok tinyint(1) unsigned NOT NULL default '0',
popup_ok tinyint(1) unsigned NOT NULL default '0',
newpopup tinyint(1) unsigned NOT NULL default '0',
mail_ok tinyint(1) unsigned NOT NULL default '0',
rbox_max mediumint(8) unsigned NOT NULL default '5000',
pbox_max mediumint(8) unsigned NOT NULL default '5000',
PRIMARY KEY (conf_id),
KEY uid (uid),
) TYPE=MyISAM;
# --------------------------------------------------------
correct:
ALTER TABLE xoops_priv_msgs ADD from_delete TINYINT( 1 ) UNSIGNED NOT NULL default '0' , ADD to_delete TINYINT( 1 ) UNSIGNED NOT NULL default '0', ADD to_save TINYINT( 1 ) UNSIGNED NOT NULL default '0', ADD from_save TINYINT( 1 ) UNSIGNED NOT NULL default '0';
# wanipmhack ver3.0
# Table structure for table `priv_msgs_config`
#
CREATE TABLE xoops_priv_msgs_config (
conf_id mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
filter_ok tinyint(1) unsigned NOT NULL default '0',
filter_word tinytext NOT NULL default '',
reject_ok tinyint(1) unsigned NOT NULL default '0',
reject_reason tinytext NOT NULL default '',
blacklist tinytext NOT NULL default '',
pmsort tinyint(1) unsigned NOT NULL default '0',
pmorder tinyint(1) unsigned NOT NULL default '0',
pmlimit tinyint(3) unsigned NOT NULL default '10',
trashbox_ok tinyint(1) unsigned NOT NULL default '0',
popup_ok tinyint(1) unsigned NOT NULL default '0',
newpopup tinyint(1) unsigned NOT NULL default '0',
mail_ok tinyint(1) unsigned NOT NULL default '0',
rbox_max mediumint(8) unsigned NOT NULL default '5000',
pbox_max mediumint(8) unsigned NOT NULL default '5000',
PRIMARY KEY (conf_id),
KEY uid (uid)
) TYPE=MyISAM;
# --------------------------------------------------------