Problems with hmail_password and hmail_spamfilter

[bagu]

Hello,

I have two problem with these plugin :

Code: [Select]

[10-Jun-2010 19:21:16] PHP Fatal error:  Cannot redeclare class hmail_password in E:\services\roundcube\plugins\hmail_password\hmail_password.php on line 212

[10-Jun-2010 19:29:52] MDB2 Error: null value violates not-null constraint (-29): _doQuery: [Error message: Could not execute statement]
[Last executed query: INSERT INTO hm_rule_criterias (criteriaruleid,criteriausepredefined,criteriapredefinedfield,criteriaheadername,criteriamatchtype,criteriamatchvalue)  VALUES('29','0','1','X-hMailServer-Reason-Score','4',NULL)]
[Native code: 1048]
[Native message: Column 'criteriamatchvalue' cannot be null]
So, i can't change the spam detection level and hmail_password fill my log with this when many of my users use it.

Roundcube is 0.4beta
Php 5.2.13
Apache 2.2.15
Mysql 5.1.47
Roundcube database is Innodb
Hmailserver database is Myisam
Hmailserver version is 5.3.3-B1879

Can you help me to correct these bugs ?

Edit : i don't know if it can help, but i have also this error in roundcube error log

Code: [Select]

[10-Jun-2010 22:46:27 +0200]: DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_4f29f5e7e1b09d31a3f4d7044a15054285911b7f5 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '22-INBOX.msg-179851' for key 'uniqueness']  in E:\services\roundcube\program\include\rcube_mdb2.php on line 658 (GET /rm/?_task=mail&_action=get&_uid=179851&_mbox=INBOX&_part=3)

[bagu]

No one ?:confused:

[rosali]

Looks like you use an outdated hmail_password plugin. Recent version ends on line 213. The second error log line does not have to do anything with the hmail_password plugin.

[bagu]

Hmail_password come from your trunk r3649

The second error come from hmail_spamfilter usage (i also can activate spamfilter, but i can't select an other detection level...after i clic on save button, detection level it alway set on very_low)

[rosali]

#1
This is the recent code of hmail_password.php: hmail_password.php - myroundcube - Project Hosting on Google Code

#2
hmail_spamfilter.php
Please check if you still get the error when changing ...
private $sql_select_rule_criteria = 'SELECT criteriamatchvalue FROM hm_rule_criterias WHERE criteriaruleid=%id';

[bagu]

#1 I already use this version My file and file on your repository are exactly the same. (winmerge confirm it)

#2 No more problem. The fix work fine.

Thanks.

[rosali]

#1
The error message states that class hmail_password is redeclared. May be you have enabled 'hmail_password' in plugins array twice? No other idea yet.

[bagu]

Ok, that's it.

I had an old config.inc.php merged with the new one...
After reset it, it work without error.

Thanks again.