1
Older versions / og1.6-beta3 og_mail_contents field uid is to small -> Got new mail everytime
« on: November 19, 2009, 04:59:30 pm »
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!
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!