Where Are The Email Templates

[snake]

in what table are the email templates in the database ? I need to bulk update them, but cannot find where they are stored.

[Blesta Addons]

the table name is emails .

make a backup before any change .

[Michael]

Why not just update them one by one? you can break stuff in the database if it's not done probably?

[snake]

because there are loads of them to do one by one, would take me a few seconds in the db.

it should be a straight forward query to replace value a with valueb, so I don;t think there is must chance of breaking anyhting

[snake]

so does anyone know what table they are in ?

they are clearly not in something obvious like "email_templates"

[Michael]

so does anyone know what table they are in ?

they are clearly not in something obvious like "email_templates"

 

Not being cocky but I just looked just for you and when you say not in something obvious.. how obvious would "emails" be?

[snake]

yes I just discovered this about 10 mins ago..

I had looked at this table several times, but I had assumed that "EMAILS" was copies of emails sent to users, which is what the name implies, and is generally the convention I have found in other billing systems I have used which save copies of all outgoing emails. 

Email_templates would be more obvious :-)

[snake]

ok got all that sorted and have made my bulk updates.

 

However the support email templates do not seem to be in this table, are they stored somewhere else ? 

Specifically I want to edit the default email  that goes out when a user opens a ticket, and add a signature and change the from address so that users can actually tell where it is from, otherwise it just looks like spam.

I have searched through the admin but couldn't find this anywhere.

[Blesta Addons]

the template email for support is in the config folder . but after the install it go to the database , same table .

[snake]

thanks for confirming, is there no place in the admin to edit this one then ?

[Paul]

Support emails are under Settings > Company > Emails, under "Plugins" as it's a plugin. Look for templates in this section labeled "Support Manager".

[snake]

thanks Paul, I had in fact already looked here and only had client emails and staff emails.

so I tried disabling and re-enabling the support plugin, and now the support templates are showing.

got there in the end :-)