Author Topic: Mail storage in MySQL  (Read 3887 times)

MacGyver

  • Freshman
  • *
  • Posts: 11
    • View Profile
    • Email
Mail storage in MySQL
« on: August 03, 2013, 05:32:15 pm »
Question : i have set Feng Office to store items in the database (MySQL)
i looked at the mail storage ... this one puzzles me.
1 mail in mij feng mailbox 1 item in the tables below. So far so good.
fo_mail_contents
fo_mail_conversations
fo_mail_datas
now i delete 1 mail in feng office and i delete the mail from the bin.
Now the tables  fo_mail_contents and  fo_mail_conversations are empty
however : table fo_mail_datas still contains 1 item .. the mail i just deleted.

Somehow the deletion process does not clean records in table fo_mail_datas
This means that this table proably gets stuffed with data that does not belong there anymore.

MacGyver

  • Freshman
  • *
  • Posts: 11
    • View Profile
    • Email
Re: Mail storage in MySQL
« Reply #1 on: August 04, 2013, 06:14:45 am »
just found out .. when storage is set to filesystem, the mail tables al also used. Whenever mails are deleted, the directories on the filesystem are cleared, the sql tables fo_mail_datas and fo_mail_contents are not cleared

MacGyver

  • Freshman
  • *
  • Posts: 11
    • View Profile
    • Email
Re: Mail storage in MySQL
« Reply #2 on: August 04, 2013, 07:44:45 am »
also in fo_objects the mail-record does not get deleted (object type 21)

MacGyver

  • Freshman
  • *
  • Posts: 11
    • View Profile
    • Email
Re: Mail storage in MySQL
« Reply #3 on: August 04, 2013, 07:50:12 am »
When deleting a file, the corresponding record in fo_objects gets deleted. This works as expected

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Mail storage in MySQL
« Reply #4 on: August 09, 2013, 05:10:49 pm »
THanks for your report, we have already taken note of this issue for future improvements.

Best regards,
Francisco
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!