Could you please post plugin version and lines 24 - 33 of your hmail_spamfilter.php?
Also please post the structure of hmail_rule_actions table (hmailserver database).
Mine is:
`actionid` int(11) NOT NULL auto_increment,
`actionruleid` int(11) NOT NULL,
`actiontype` tinyint(4) NOT NULL,
`actionimapfolder` varchar(255) NOT NULL,
`actionsubject` varchar(255) NOT NULL,
`actionfromname` varchar(255) NOT NULL,
`actionfromaddress` varchar(255) NOT NULL,
`actionto` varchar(255) NOT NULL,
`actionbody` text NOT NULL,
`actionfilename` varchar(255) NOT NULL,
`actionsortorder` int(11) NOT NULL,
`actionscriptfunction` varchar(255) NOT NULL,
`actionheader` varchar(80) NOT NULL,
`actionvalue` varchar(255) NOT NULL,
`actionrouteid` int(11) NOT NULL,
Do you use the change posted by fabiosergio above?
Do you run hMailserver on an external MySQL Database?
Ok, no problem. Thanks a lot for the support.
The lines are:
public $task = 'login|mail|settings';
private $sql_select_account = 'SELECT accountid FROM hm_accounts WHERE accountaddress=%u';
private $sql_select_rule = 'SELECT ruleid, ruleaccountid, rulename, ruleactive, ruleuseand, rulesortorder FROM hm_rules WHERE ruleaccountid=%u AND rulename =%r';
private $sql_select_rule_criteria = 'SELECT criteriamatchvalue FROM hm_rule_criterias WHERE criteriaruleid=%id';
private $sql_update_rule = 'UPDATE hm_rules SET ruleactive=%b WHERE ruleid=%id';
private $sql_update_criteria = 'UPDATE hm_rule_criterias SET criteriamatchvalue=%v WHERE criteriaruleid=%id';
private $sql_update_action = 'UPDATE hm_rule_actions SET actionimapfolder=%f WHERE actionruleid=%id';
private $sql_insert_rule = "INSERT INTO hm_rules (ruleaccountid,rulename,ruleactive,ruleuseand,rulesortorder) VALUES(%id,%r,%b,'1','1')";
private $sql_insert_rule_criteria = "INSERT INTO hm_rule_criterias (criteriaruleid,criteriausepredefined,criteriapredefinedfield,criteriaheadername,criteriamatchtype,criteriamatchvalue) VALUES(%id,'0','1',%n,'4',%s)";
private $sql_insert_rule_action = "INSERT INTO hm_rule_actions (actionruleid,actiontype,actionimapfolder,actionsortorder,actionrouteid) VALUES(%id,'4',%f,'0','0')";
You can find the structure of the database here:
http://www.patriarchi.info/images/hmailserver.jpgI don't understand what fabiosergio means, please can you explain to me what i must to do?
I've changed in the config file rule_name and the header_field, but it doesn't functions.
I run hmailserver into the same server of the mysql database.
Thank you, Niccolò Patriarchi.