Author Topic: og1.6-beta3 og_mail_contents field uid is to small -> Got new mail everytime  (Read 1868 times)

zensursula

  • Newbie
  • *
  • Posts: 9
    • View Profile
The field "uid" in the table "og_mail_contents" is of type varchar(100).
I would suggest increasing it to a minimum of 250 characters.

My mailserver classifies mail with a really long UID. In several cases it was above 100 and up to 120 characters long.

The method MailContents::mailRecordExists will fail for those mails.
The result is, that those mails will be fetched as new mails, every time I press "Check Mails".

Having a look at some other field in this table, I think they are a bit to small also. I would suggest to increase the following ones to a minimum of 250 characters:
uid                             varchar(100) 
from                           varchar(100) 
imap_folder_name       varchar(100) 
account_email            varchar(100) 
message_id                varchar(150) 
in_reply_to_id              varchar(150) 

Looking at my sample mail folder, some of the above fields of my test mails are already in the range of up to 120 characters.


For those who need a fast solution: Use a tool like phpMyAdmin and simply increase the values to 250. I am unfamiliar with the internals, but I can't see any problem with that. But it may be possible that future updates may fail.

Apart from that: Great tool! Thanks for that!

ignacio

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
Thank you very much! We'll change it for next version to 255.