Mantis Bug Tracker - Forums

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.

I *think* I got it...

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

I'm testing it today.

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

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

Thank you.

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.