Author Topic: Remove all emails  (Read 1933 times)

Blinkiz

  • Freshman
  • *
  • Posts: 24
    • View Profile
Remove all emails
« on: September 22, 2010, 02:58:44 am »
I tested the email module (1.7.2) and imported to many folders. So I now want to remove 1500 emails. How can I do this?

I removed the email account when I realized the email count was +400. There was an option to delete all emails so I choose that one. But the emails are still there.

Blinkiz

  • Freshman
  • *
  • Posts: 24
    • View Profile
Re: Remove all emails
« Reply #1 on: September 22, 2010, 03:18:50 am »
Added the account again and the email module got empty. Removed that account and now I do not see any emails in the email module.

But I can still see them in the Overview panel as unread emails. Clicking on one email and I can see all it's content. How can I remove them?

maybe doing some mysql editing?
og_mail_account_imap_folder Is empty
og_mail_account_users Is empty
og_mail_accounts Is empty
og_mail_contents Lots of data
og_mail_conversations Contains ~1100 ID numbers only
og_mail_datas Lots of data

So I did this:
Code: [Select]
mysql> delete from og_mail_contents;
Query OK, 1182 rows affected (0.15 sec)

mysql> delete from og_mail_conversations;
Query OK, 1111 rows affected (0.02 sec)

mysql> delete from og_mail_datas;
Query OK, 1184 rows affected (0.15 sec)
Everything seems to work in the GUI. have I done something wrong now? I have made a backup of the database before doing this..
« Last Edit: September 22, 2010, 03:34:07 am by Blinkiz »

franponce87

  • Administrator
  • Hero Member
  • *****
  • Posts: 1819
    • View Profile
    • Email
Re: Remove all emails
« Reply #2 on: September 24, 2010, 05:19:51 pm »
Hello, we will check it out later on to know what is going on.
Best regards,
Francisco
Would you like to install Feng Office Professional or Enterprise Edition in your servers? No problem! Read this article!