Duplicate email templates

HI,
I had some trouble with the last update that I finally got worked out. Everything seems fine except for the email templates. They have retained their customization, but have duplicated themselves. I have three of each email template showing up. Is there a safe and easy way to get rid of the duplicates?
Thanks!

Hi @sheardln,

What software are you using, what version did you upgrade from, what version did you upgrade to?

Regards,
Alec Smecher
Public Knowledge Project Team

Sorry I was a little vague. I am using OJS with two journals. I upgraded to 2.4.8.0.
thanks Alec!

Hi @sheardln,

What version did you upgrade from?

Regards,
Alec Smecher
Public Knowledge Project Team

I started having trouble with 2.4.6 but I went from that to 2.4.7 and then 2.4.8 in the end. So it appeared to update sequentially.

Hi @sheardln,

Hmm, strange. Can you send me a private message with a link to a database dump?

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @sheardln,

At a glance, it looks like there are duplicate entires for email templates in the email_templates_default table. There should be a single entry only per template.

The upgrade process shouldn’t cause this; the only recent upgrade step that affects this table is the selective installation of a few new email templates for added features. We don’t have any other reports of mass duplication of email templates there, and it didn’t turn up during our own testing, so I don’t think that’s the cause.

I suspect something happened that’s peculiar to your system – maybe you were experimenting with importing emails from XML or something similar?

In any case, the solution is to remove the duplicates from the email_templates_default table, leaving one entry per email template. If you’re not handy with SQL, then a tool like phpMyAdmin may help.

Regards,
Alec Smecher
Public Knowledge Project Team

Thanks Alec,
It does seem to be a very odd problem - and most likely a one off result of
something that happened when I was working on fixing the upgrade when it
failed the first time. I definitely was not intentionally importing
anything or creating new. I will delete the duplicates in the mysql table
and hope it doesn’t happen again.
Thanks for taking a look!
Lisa