Page 1 of 1

Purge all "unsent" email data

Posted: Jun 14, 2012 3:55 am
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.

Re: Purge all "unsent" email data

Posted: Jun 14, 2012 4:13 am
by pitto
I *think* I got it...

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

I'm testing it today.

Re: Purge all "unsent" email data

Posted: Jun 14, 2012 5:49 am
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 ;-)

Re: Purge all "unsent" email data

Posted: May 16, 2013 5:16 am
by rubencamacho
hi, can pitto, may i know how did you truncate mantis_email_table ?

Thank you.

Re: Purge all "unsent" email data

Posted: May 16, 2013 5:29 am
by atrol

Re: Purge all "unsent" email data

Posted: May 17, 2013 5:42 am
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