Empty email to all users when we create a new announcements

Hi Alec

Resetting is not problem. Because we use english and don’t need any special template.
Meanwhile I have resetted just. But noting changed. There is still not “NOTIFICATION_MAILLIST” in the template list.

Can you send me xml template that I upload?

Hi @birkok,

Why not just create it using the “Create Email” link there?

Regards,
Alec Smecher
Public Knowledge Project Team

OK. Sure
But would you please send me what I should put in the template?

Selamlar,
M. Cüneyt Birkök

www.J-HumanSciences.com

Hi @birkok,

That’s in the content I quoted above:

Regards,
Alec Smecher
Public Knowledge Project Team

Thank you for your patience , I am not programmer.

I created following template, but didn’t work. (I sent new announcements, users received empty mail)

And also following explanation written in “edit email” page of NOTIFICATION_MAILLIS template

“This email is sent to unregistered users on the notification mailing list.”
There must be a mistake, because this NOTIFICATION_MAILLIS should send to registered users.

You’ll also want to check the NOTIFICATION template. It is cut off on your screenshot, but also appears to be empty.

There are two ways to subscribe to notifications. Unregistered users can subscribe to a mailing list by submitting their email address. They will receive NOTIFICATION_MAILLIST on publication of a new announcement. Registered users can subscribe when logged in. They will receive NOTIFICATION on publication of a new announcement. The difference is that NOTIFICATION_MAILLIST contains an unsubscribe link in the email body.

  1. I have created those three template:.

NOTIFICATION

NOTIFICATION MAILLIST WELCOME

NOTIFICATION MAILLIST

  1. problem solved. Now when we put new announcement, notification mail sent

  2. why did I experienced this problem? There must be a mysql problem. How
    can I repair it?

Thanks a lot

,
M. Cüneyt Birkök

www.J-HumanSciences.com

Hi @birkok,

Those email templates were introduced with OJS 2.3.0, but should’ve been added by the upgrade script during the upgrade process. If you upgraded from pre-2.3.0, then something must’ve happened there; if not, the templates should’ve been installed when the journal was created.

Regards,
Alec Smecher
Public Knowledge Project Team

Is there any way to recover default settings including all of missing
things?

Or how can I repair my current installation? Any script pr similar (easy)
way for non professional?

Selamlar,
M. Cüneyt Birkök

www.J-HumanSciences.com

Hi @birkok,

Without knowing the installation’s history, I can only guess at how this happened – but if everything else seems to be working OK, I’d continue using it. A missing email template is not necessarily indicative of more widespread problems.

Regards,
Alec Smecher
Public Knowledge Project Team

Actually we have two problems as I mentioned somewhere in this forum
earlier.

  1. “Submission acknowledgment” mail is not send when new submission made.
    We solved this problem temporarily as replaced old
    “AuthorSubmitStep5Form.inc.php”
  2. there is following error message in Journal “Management/Stats &
    Reports”…
    http://www.j-humansciences.com/ojs/index.php/IJHS/manager/statistics
    We still couldn’t solve this problem. We want to solve because it is
    important to show some statistics in about page.

“DB Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check
your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the
SELECT is okay”

  1. I think no way to solve them, as I am not expert.

Thank all of you, helped much

​Regards,
M. Cüneyt Birkök

www.J-HumanSciences.com

Hi @birkok,

Rather than discussing those here, could you find the previous threads that dealt with the issues and continue there? That would help to keep the forum organized.

Regards,
Alec Smecher
Public Knowledge Project Team

Thank you Alec. I give these two problems threads titles in the forum here:
I haven’t still solved problems due to probably I haven’t enough programming knowledge. That beats me.

  1. Upgraded to 2.4.6 and Submission Acknowledgement email is not sent anymore
    Upgraded to 2.4.6 and Submission Acknowledgement email is not sent anymore

  2. Error in “Stats & Reports” page.
    Error in "Stats & Reports" page - #5 by ctgraham

Hello. I want to add that blank subscription notifications are also an issue on our instance. We are on 2.4.8.1; I am not sure which of the upgrades did not carry the templates over.

Manually creating 3 email templates as recommended above does resolve the issue. However in our case it will mean doing so for 37+ hosted journals.

Is there a patch available or plans to make one? Thank you.

Hi @MariyaM,

I don’t believe it’s necessary to enter these templates for all journals – if you create the entry in the email_templates_default and email_templates_default_data tables, it should be sufficient to do it once for the entire site.

Regards,
Alec Smecher
Public Knowledge Project Team

Hi @asmecher

Adding to Mariya’s post; we are trying to retroactively add those templates.
Correct me if I’m wrong, but changing the default only affects new journals and old ones with reset?
I’m judging from the assoc_id column in email_templates

Best,

Sean

Hi @SeanXiaoZhao,

The .xml files are installed into the database when the system is first installed (and some upgrade tasks will add additional templates from XML files); they’re installed into the email_templates_default and email_templates_default_data tables, which are not journal-specific. When a journal needs to look up an email template it first checks the journal-specific email_templates_data and email_templates tables; if nothing is present (representing a journal-specific template customization), then it’ll fall back to the email_templates_default and email_templates_default_data templates for the system-wide defaults.

Regards,
Alec Smecher
Public Knowledge Project Team

Thanks for the info; we’ll add the NOTIFICATION, NOTIFICATION_MAILLIST_WELCOME and NOTIFICATION_MAILLIST to email_templates_default and their text into email_templates_default_data.
I’m curious as to why the XML files did not update the database when we upgraded - will investigate. Thanks!

Hi @asmecher,

I have the same problem here. There were no NOTIFICATION, NOTIFICATION MAILLIST WELCOME and NOTIFICATION MAILLIST entries in emails_templates_default_data table in english language (although i had those entries in my native language). So i tried 2 scenarios. I created those templates from OJS GUI for one journal and it worked fine (not sure why HTML line breaks are in those templates, because mail is sent as plain text so in mail client i get those br’s visible as text). However, i have many journals in one OJS installation so i thought that adding those 3 templates to the emails_templates_default_data table would be solution for all - but it didn’t work. I tried resetting templates from OJS GUI after i made those changes to the table but it still didn’t work. Can you please explain how should this work and what are my options - is it really necessary for all journals to create those 3 templates from OJS GUI? Thx.

Regards,

Nino

Ok, i think i solved this by inserting those 3 templates in email_templates_default table. Now i get those templates as default templates for all journals.

Regards,

Nino