Email translations No subject was found in the database

[vzex]

Unable to use html edit orderchanged to remove powered by PS "No subject was found for orderchanged in the database"

The following were blank:

[vargstrom]

I confirm.

[Occam]

Seems there was a problem with the installation process. Can you confirm that there exists a subdirectory /mails/ at all? I'd guess no. If the subdirectory would exist, tb will accept the changes and clone the changed mails directory to /themes//mails/, where it will be searched automatically in case of further changes. Solution: Go to localization --> translations --> section: Add / Update a language and import your language. Then try again to modify the mails.

[vzex]

@Occam said in Email translations No subject was found in the database:

Seems there was a problem with the installation process. Can you confirm that there exists a subdirectory /mails/ at all? I'd guess no.

Mine does exist: mails/en

My installation was a clean install via cpanel

If the subdirectory would exist, tb will accept the changes and clone the changed mails directory to /themes//mails/, where it will be searched automatically in case of further changes. Solution: Go to localization --> translations --> section: Add / Update a language and import your language. Then try again to modify the mails.

Will this solution overwrite all the "powered by prestashop" I've already edited out?

If it will should I just replace the three emails from a new copy of TB? orderchanged orderconfproductlist orderconfcat_rules

[Occam]

Why so complicated? How about this?

1. Copy the folder /mails/en to your locale computer.
2. Open all html files at once with notepad++.
3. Choose Replace from menu, then
4. Replace with option in all open files the following: {shop_name} powered by PrestaShop™
5. Click on Save all
6. Repeat this with the phrase powered by PrestaShop(tm) [http://www.prestashop.com/] for the txt files in this folder.
7. Upload the folder to /themes//mails

[vzex]

I like your thinking @Occam! We need a tips and tricks thread :)

Was already through them all one by one, have a mac so no notepad++ and thought it could be a bug not sure why it happened.

[Occam]

Then take JEdit, TextWrangler or TextMate instead. All 3 run on OS X.

[vzex]

Thanks! will check them out

[vzex]

Back to translations...while editing out powered by PS I tried to change it to thirtybees using the icon image for the link but editor gave me a 500 error for the file source lookup to add image

[alwayspaws]

I hope someone comes along and offers some help. I'm going to be doing this soon, also.

[vzex]

Hi sorry for not responding sooner, took a time out from frustration :) How can I do that? @mdekker

[alwayspaws]

We all understand! I'm on the brink of taking a timeout now. Maybe.

[vzex]

Had to do a rollback so now need to restore what I lost.

The only bad part about frustration timeout is you loose the tempo and have to get it back :)

Two days was good, now I just want to steam ahead, until the rain stops and sun comes out at least!

[alwayspaws]

Very sorry. I have a test site for all the screwups I make. It's hard to regain the momentum, but once you do ... the sky's the limit! Can you please (I hope I'm right!) update your reply to Michael with his ID so he knows to come back here? We usually try not to bother him but he asked you for something I don't know how to do, either.

[vzex]

It's actually good practice, frustrating but good :) I've been using tbupdater as my backup method since it's quick to do and offers rollback. PS didn't have that option unless there was an actual update so I hope TB stays this way!

Same with the test site. My plan is to move directory to main domain once working.

Updated for access info, thanks for the hint.

[alwayspaws]

This is news to me! I need to check it out but there is an overwhelming amount of work involved with setting up a new a site. YW for the hint. :)

[30knees]

I'd like to piggy back on this thread, as I'd have the same thread title.

I would like to change the subject of an order status email. I get the same "No Subject was found for bankwire in the database" error when I click the order status to translate. I have it in my themes/theme/mails/language folder.

Where can I change the order status? I am assuming I can change the name of the order status in Orders>Statuses, but I'd like to keep that one shorter/different (for usability purposes in the backend) than in the email subject.

[DaoKakao]

Finally i've found a solution for that issue: https://github.com/thirtybees/mailalerts/issues/3

Template editing still impossible however :disappointed_face:

[30knees]

On 7/25/2018 at 3:53 PM, DaoKakao said:

Finally i've found a solution for that issue: https://github.com/thirtybees/mailalerts/issues/3

The mailalert.php is correct in my store but I am still unable to edit some subjects. What is the solution?

I get:

No Subject was found for bankwire in the database.

[datakick]

On 11/11/2023 at 12:53 PM, 30knees said:

The mailalert.php is correct in my store but I am still unable to edit some subjects. What is the solution?

I get:

No Subject was found for bankwire in the database.

Email subjects for order status emails are not translatable in the same way as other emails.

Thirty bees collects information about email subject by parsing source code, and looking for pattern

Mail::Send($languageId, 'email_template', Mail::l('Email Subject'))

When it sees such code, it can associate email template 'email_template' with default subject 'Email Subject', and offer translation for it. The important think is that the email_template and Email Subject are literals - constant values.

This works for static emails only, the one that are know at the time when developer writes code. For order status that's very different. You can specify which email template should be sent dynamically (edit order status). The code to send email looks like this (using variables)

Mail::Send($languageId, $status->template, $status->name);

The translation system can't work with that, so nothing is offered for translation.

When sending emails for order statuses, order status name is always used as email subject.  Bleeding edge (1.6) contains new enhancement that let you have explicit email subject for each order status.