1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

AtMail and SpamDB - Error in apache2 error.log

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by TRANCEMANIAC, Jul 16, 2009.

  1. TRANCEMANIAC

    TRANCEMANIAC Guest

    0
     
    Hi @ all,

    we have a Ubuntu 8.04 LTS with Plesk 9.2.1 installed.
    As webmail we use "AtMail 1.02".

    We've check the "/var/log/apache2/error.log" and there a many entries like this

    Code:
    SQL Error = (select SpamEmail from SpamDB_j where Account=?)DB Error: no such table - select SpamEmail from SpamDB_j where Account='mailname@domain.ltd' [nativecode=1146 ** Table 'atmail.SpamDB_j' doesn't exist]
    SQL Error = (select SpamEmail from SpamDB_e where Account=?)DB Error: no such table - select SpamEmail from SpamDB_e where Account='mailname@domain.ltd' [nativecode=1146 ** Table 'atmail.SpamDB_e' doesn't exist]
    Ok i understand, that the tables not exist, but the question is: "How can we fix it?"

    There are only the following tables in the DB atmail:
    Code:
    atmail (210)
    
    * AbookGroup_a
    * AbookGroup_b
    * AbookGroup_c
    * AbookGroup_d
    * AbookGroup_e
    * AbookGroup_f
    * AbookGroup_g
    * AbookGroup_h
    * AbookGroup_i
    * AbookGroup_j
    * AbookGroup_k
    * AbookGroup_l
    * AbookGroup_m
    * AbookGroup_n
    * AbookGroup_o
    * AbookGroup_other
    * AbookGroup_p
    * AbookGroup_q
    * AbookGroup_r
    * AbookGroup_s
    * AbookGroup_shared
    * AbookGroup_t
    * AbookGroup_u
    * AbookGroup_v
    * AbookGroup_w
    * AbookGroup_x
    * AbookGroup_y
    * AbookGroup_z
    * AbookPermissions
    * Abook_a
    * Abook_b
    * Abook_c
    * Abook_d
    * Abook_e
    * Abook_f
    * Abook_g
    * Abook_h
    * Abook_i
    * Abook_j
    * Abook_k
    * Abook_l
    * Abook_m
    * Abook_n
    * Abook_o
    * Abook_other
    * Abook_p
    * Abook_q
    * Abook_r
    * Abook_s
    * Abook_shared
    * Abook_t
    * Abook_u
    * Abook_v
    * Abook_w
    * Abook_x
    * Abook_y
    * Abook_z
    * Accounts
    * Domains
    * EmailDatabase_a
    * EmailDatabase_b
    * EmailDatabase_c
    * EmailDatabase_d
    * EmailDatabase_e
    * EmailDatabase_f
    * EmailDatabase_g
    * EmailDatabase_h
    * EmailDatabase_i
    * EmailDatabase_j
    * EmailDatabase_k
    * EmailDatabase_l
    * EmailDatabase_m
    * EmailDatabase_n
    * EmailDatabase_o
    * EmailDatabase_other
    * EmailDatabase_p
    * EmailDatabase_q
    * EmailDatabase_r
    * EmailDatabase_s
    * EmailDatabase_t
    * EmailDatabase_u
    * EmailDatabase_v
    * EmailDatabase_w
    * EmailDatabase_x
    * EmailDatabase_y
    * EmailDatabase_z
    * EmailMessage_a
    * EmailMessage_b
    * EmailMessage_c
    * EmailMessage_d
    * EmailMessage_e
    * EmailMessage_f
    * EmailMessage_g
    * EmailMessage_h
    * EmailMessage_i
    * EmailMessage_j
    * EmailMessage_k
    * EmailMessage_l
    * EmailMessage_m
    * EmailMessage_n
    * EmailMessage_o
    * EmailMessage_other
    * EmailMessage_p
    * EmailMessage_q
    * EmailMessage_r
    * EmailMessage_Reply
    * EmailMessage_s
    * EmailMessage_t
    * EmailMessage_u
    * EmailMessage_v
    * EmailMessage_w
    * EmailMessage_x
    * EmailMessage_y
    * EmailMessage_z
    * EmailUIDL_a
    * EmailUIDL_b
    * EmailUIDL_c
    * EmailUIDL_d
    * EmailUIDL_e
    * EmailUIDL_f
    * EmailUIDL_g
    * EmailUIDL_h
    * EmailUIDL_i
    * EmailUIDL_j
    * EmailUIDL_k
    * EmailUIDL_l
    * EmailUIDL_m
    * EmailUIDL_n
    * EmailUIDL_o
    * EmailUIDL_other
    * EmailUIDL_p
    * EmailUIDL_q
    * EmailUIDL_r
    * EmailUIDL_s
    * EmailUIDL_t
    * EmailUIDL_u
    * EmailUIDL_v
    * EmailUIDL_w
    * EmailUIDL_x
    * EmailUIDL_y
    * EmailUIDL_z
    * Filter
    * Folders
    * Groups
    * Log_Error
    * Log_Login
    * Log_RecvMail
    * Log_SendMail
    * Log_SMS
    * Log_Spam
    * Log_Virus
    * MailSort_a
    * MailSort_b
    * MailSort_c
    * MailSort_d
    * MailSort_e
    * MailSort_f
    * MailSort_g
    * MailSort_h
    * MailSort_i
    * MailSort_j
    * MailSort_k
    * MailSort_l
    * MailSort_m
    * MailSort_n
    * MailSort_o
    * MailSort_other
    * MailSort_p
    * MailSort_q
    * MailSort_r
    * MailSort_s
    * MailSort_t
    * MailSort_u
    * MailSort_v
    * MailSort_w
    * MailSort_x
    * MailSort_y
    * MailSort_z
    * MailThreads
    * SpellCheck
    * UserPermissions
    * Users
    * UserSession
    * UserSettings_a
    * UserSettings_b
    * UserSettings_c
    * UserSettings_d
    * UserSettings_e
    * UserSettings_f
    * UserSettings_g
    * UserSettings_h
    * UserSettings_i
    * UserSettings_j
    * UserSettings_k
    * UserSettings_l
    * UserSettings_m
    * UserSettings_n
    * UserSettings_o
    * UserSettings_other
    * UserSettings_p
    * UserSettings_q
    * UserSettings_r
    * UserSettings_s
    * UserSettings_t
    * UserSettings_u
    * UserSettings_v
    * UserSettings_w
    * UserSettings_x
    * UserSettings_y
    * UserSettings_z
    
    The effect is that the spamdirectory in the webmailer is not working.

    Hope somebody can help.

    Geetings,

    TRANCEY
     
  2. TRANCEMANIAC

    TRANCEMANIAC Guest

    0
     
    Solved: AtMail and SpamDB - Error in apache2 error.log

    I solved it by my self.

    On Unbuntu you can reinstall the SpamAssasin on commandline to fix the problem.

    Code:
    aptitude reinstall psa-spamassassin
    After this the spamfolder in AtMail is working right.


    TRANCEY
     
  3. m0rpheu5

    m0rpheu5 Regular Pleskian

    27
     
    Joined:
    Jul 1, 2008
    Messages:
    120
    Likes Received:
    0
    i have the same problem, and i have spamassassin installed, and my plesk license doesn´t have support for spamassassin, if i install the psa-spamassassin, won´t get error with my spamassassin already installed?

    Thanks
     
  4. m0rpheu5

    m0rpheu5 Regular Pleskian

    27
     
    Joined:
    Jul 1, 2008
    Messages:
    120
    Likes Received:
    0
    don´t work for me, i remove the psa-spamassassin, and install it again using yum remove and yum install, and nothing changes.

    SQL Error = (select SpamEmail from SpamDB_m where Account=?)DB Error: no such ta ble - select SpamEmail from SpamDB_m where Account='moisesdias@radiomais.am' [na tivecode=1146 ** Table 'atmail.SpamDB_m' doesn't exist]
    SQL Error = (select SpamEmail from SpamDB_m where Account=?)DB Error: no such ta ble - select SpamEmail from SpamDB_m where Account='moisesdias@radiomais.am' [na tivecode=1146 ** Table 'atmail.SpamDB_m' doesn't exist]


    what i need to do to fix this?

    Thanks
     
  5. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    You can try to create this missing table with:
    But I'm not sure that it will help. Another possible reason can be fact that installed version of atmail did not fit to you OS.
    You can check it with

    and compare OS of this package with output of:

    Please install correct version of psa-atmail package if it is different. It will help.
     
  6. humpy

    humpy Basic Pleskian

    24
     
    Joined:
    Jul 23, 2008
    Messages:
    30
    Likes Received:
    0
    same problem

    Hi,
    I am experiencing the same problem,
    [root@vps01 ~]# rpm -qa | grep atmail
    psa-atmail-1.02-cos5.build95101209.05
    [root@vps01 ~]# cat /etc/redhat-release
    CentOS release 5.5 (Final)

    is that correct versions?
    thanks
    w.
     
  7. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
  8. humpy

    humpy Basic Pleskian

    24
     
    Joined:
    Jul 23, 2008
    Messages:
    30
    Likes Received:
    0
    thank you..
    would you have any suggestions for fixing the error in my case then please?
     
  9. humpy

    humpy Basic Pleskian

    24
     
    Joined:
    Jul 23, 2008
    Messages:
    30
    Likes Received:
    0
    also, randomly emails being opened in atmail in random accounts simply show as totally blank... any suggestions to fix THAT problem as well?
     
  10. humpy

    humpy Basic Pleskian

    24
     
    Joined:
    Jul 23, 2008
    Messages:
    30
    Likes Received:
    0
    Ignore the blank email querstion, that was found to be from OOM error. Howevr, despite having correct version of Atmail and OS together , and also after reinstaling both psa-spamassasin and atmail in hopes of fixing the problem, I am still getting the errors...

    SQL Error = (select SpamEmail from SpamDB_a where Account=?)DB Error: no such table - select SpamEmail from SpamDB_a where Account='aileen@drewinternational.com.au' [nativecode=1146 ** Table 'atmail.SpamDB_a' doesn't exist]
    SQL Error = (select SpamEmail from SpamDB_r where Account=?)DB Error: no such table - select SpamEmail from SpamDB_r where Account='royg@otechaustralia.com.au' [nativecode=1146 ** Table 'atmail.SpamDB_r' doesn't exist]
    SQL Error = (select SpamEmail from SpamDB_r where Account=?)DB Error: no such table - select SpamEmail from SpamDB_r where Account='royg@otechaustralia.com.au' [nativecode=1146 ** Table 'atmail.SpamDB_r' doesn't exist]
     
  11. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Try to fix it with attached file and following command:

    m
     

    Attached Files:

    • db.zip
      File size:
      312 bytes
      Views:
      32
  12. humpy

    humpy Basic Pleskian

    24
     
    Joined:
    Jul 23, 2008
    Messages:
    30
    Likes Received:
    0
    that seems to have fixed things!
    cheers
     
  13. humpy

    humpy Basic Pleskian

    24
     
    Joined:
    Jul 23, 2008
    Messages:
    30
    Likes Received:
    0
    Sorry, I was mistaken on the OOM issue causing blank emails. I have no longer any memory issues, but random emails in Atmail simply show as blank. About 1-2 a day... If i use mail2web.com to access the account, the emails showing as blank viewable. Go back to Atmail again.. they still open as totally blank...

    It is always the same email that is blank each time too, when returning and logging into ATMAil.. once a random email opens as blank, it forever after opens as blank..( it is not simply every an "every 10th email opened" type thing )

    The emails that stay blank however, ARE random in that its there is no pattern to who the email is sent from, it is a total lottery which one wont work..

    Correct version Atmail for the OS too.
     
Loading...