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.
Purge all "unsent" email data
Moderators: Developer, Contributor
Re: Purge all "unsent" email data
I *think* I got it...
Truncating table mantis_email_table seems to have done the job...
I'm testing it today.
Truncating table mantis_email_table seems to have done the job...
I'm testing it today.
Re: Purge all "unsent" email data
You got it!pitto wrote:I *think* I 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
-
- Posts: 9
- Joined: 16 May 2013, 10:14
Re: Purge all "unsent" email data
hi, can pitto, may i know how did you truncate mantis_email_table ?
Thank you.
Thank you.
-
- Posts: 9
- Joined: 16 May 2013, 10:14
Re: Purge all "unsent" email data
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.
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.