+ Reply to Thread
Results 1 to 7 of 7

Thread: Problems with hmail_password and hmail_spamfilter

  1. #1
    bagu is offline Registered User
    Join Date
    Jan 2010
    Posts
    97
    Downloads
    15
    Uploads
    0

    Default Problems with hmail_password and hmail_spamfilter

    Hello,

    I have two problem with these plugin :
    Code:
    [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:
    [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)

  2. #2
    rosali's Avatar
    rosali is offline Super Moderator
    Join Date
    Dec 2007
    Location
    Germany
    Posts
    2,394
    Downloads
    36
    Uploads
    0

    Default

    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.
    Regards,
    Rosali

    __________________
    MyRoundcube Project http://myroundcube.googlecode.com
    MyRoundcube Online Demo - Free Email Address http://mail4us.net
    MyRoundcube Plugins Generic Installation Guide http://mail4us.net/myroundcube/index.php
    Mailing List http://mail4us.net/?_action=plugin.nabble

  3. #3
    bagu is offline Registered User
    Join Date
    Jan 2010
    Posts
    97
    Downloads
    15
    Uploads
    0

    Default

    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)

  4. #4
    rosali's Avatar
    rosali is offline Super Moderator
    Join Date
    Dec 2007
    Location
    Germany
    Posts
    2,394
    Downloads
    36
    Uploads
    0

    Default

    #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';
    Regards,
    Rosali

    __________________
    MyRoundcube Project http://myroundcube.googlecode.com
    MyRoundcube Online Demo - Free Email Address http://mail4us.net
    MyRoundcube Plugins Generic Installation Guide http://mail4us.net/myroundcube/index.php
    Mailing List http://mail4us.net/?_action=plugin.nabble

  5. #5
    bagu is offline Registered User
    Join Date
    Jan 2010
    Posts
    97
    Downloads
    15
    Uploads
    0

    Default

    #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.

  6. #6
    rosali's Avatar
    rosali is offline Super Moderator
    Join Date
    Dec 2007
    Location
    Germany
    Posts
    2,394
    Downloads
    36
    Uploads
    0

    Default

    #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.
    Regards,
    Rosali

    __________________
    MyRoundcube Project http://myroundcube.googlecode.com
    MyRoundcube Online Demo - Free Email Address http://mail4us.net
    MyRoundcube Plugins Generic Installation Guide http://mail4us.net/myroundcube/index.php
    Mailing List http://mail4us.net/?_action=plugin.nabble

  7. #7
    bagu is offline Registered User
    Join Date
    Jan 2010
    Posts
    97
    Downloads
    15
    Uploads
    0

    Default

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts