Feng Forum
Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News:
Feng Office 3.1 has been released!!
Home
Help
Search
Login
Register
Feng Forum
»
Support
»
Feng Office 2
»
Mail storage in MySQL
« previous
next »
Print
Pages: [
1
]
Author
Topic: Mail storage in MySQL (Read 3887 times)
MacGyver
Freshman
Posts: 11
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.
Logged
MacGyver
Freshman
Posts: 11
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
Logged
MacGyver
Freshman
Posts: 11
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)
Logged
MacGyver
Freshman
Posts: 11
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
Logged
franponce87
Administrator
Hero Member
Posts: 1819
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
Logged
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem!
Read this article!
Print
Pages: [
1
]
« previous
next »
Feng Forum
»
Support
»
Feng Office 2
»
Mail storage in MySQL