Purge all "unsent" email data

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
pitto
Posts: 14
Joined: 11 Jan 2011, 20:48

Purge all "unsent" email data

Post by pitto »

Hi all!

I have Mantis 1.2.8 and recently I've had a problem with email notification.
I've solved it and now Mantis tries to send a LOT of useless (old) email everytime I open a new issue (or close it or trigger any kind of event that involves email notification).
It is such a big amount of email that it gets error 500 in browser and Mantis starts sending all those email from the start at the next email notification trigger.

How can I delete all "past" unsent email notification and start afresh from today?

Thanks,
D.
pitto
Posts: 14
Joined: 11 Jan 2011, 20:48

Re: Purge all "unsent" email data

Post by pitto »

I *think* I got it...

Truncating table mantis_email_table seems to have done the job...

I'm testing it today.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Purge all "unsent" email data

Post by atrol »

pitto wrote:I *think* I got it...
You got it!

There is a script email_queue.php in admin directory which helps for such kind of issues.
I know, you are recommend to remove admin directory after installation ;-)
Please use Search before posting and read the Manual
rubencamacho
Posts: 9
Joined: 16 May 2013, 10:14

Re: Purge all "unsent" email data

Post by rubencamacho »

hi, can pitto, may i know how did you truncate mantis_email_table ?

Thank you.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Purge all "unsent" email data

Post by atrol »

Please use Search before posting and read the Manual
rubencamacho
Posts: 9
Joined: 16 May 2013, 10:14

Re: Purge all "unsent" email data

Post by rubencamacho »

Thanks, i finally found how to do it on my scenario.

on my setup, import function on phpmyadmin is always resulting to error 1604 so this is what i did:

1. i copied the mantis database on my mantis server
2. i manually imported the mantis database to the data folder under mysql
3. on phpmyadmin, i selected mantis_email_table then truncated it
4. after truncating, i copied mantis_email_table MYD and MYI file to my mantis database

after doing the above steps, mantis is not sending outdated issues and report issue also speed up.

Thanks. :D :D :D
Post Reply