Change System E-Mail Address?

[Steven F]

Our system seems to be sending from @our-ip and this is causing e-mails to fail. I can't figure out how to change this so it sends from @ourdomain.com. Any ideas? I've gone through most of the settings and I'm thinking I'll need to pop into MySQL to find this.

[Michael]

Our system seems to be sending from @our-ip and this is causing e-mails to fail. I can't figure out how to change this so it sends from @ourdomain.com. Any ideas? I've gone through most of the settings and I'm thinking I'll need to pop into MySQL to find this.

 

What's the email addresses on the templates? Settings > Company > Emails > edit.

If they are all incorrect you can do the following: https://licensecart.com/billing/plugin/support_manager/knowledgebase/view/267/how-to-change-all-the-emails-from-subdomains/11/

[Steven F]

What's the email addresses on the templates? Settings > Company > Emails > edit.

If they are all incorrect you can do the following: https://licensecart.com/billing/plugin/support_manager/knowledgebase/view/267/how-to-change-all-the-emails-from-subdomains/11/

 

We have a winner.

[Steven F]

Just a small update, you also need sales@domain.com to update.

 

Also, using PHPMyAdmin on production is probably a bad idea.

[Michael]

Just a small update, you also need sales@domain.com to update.

 

Also, using PHPMyAdmin on production is probably a bad idea.

 

yeah you can edit the templates as you need, but that's easier than updating every one straight away

[Steven F]

yeah you can edit the templates as you need, but that's easier than updating every one straight away

 

One more thing. from is a reserved word in MySQL. @Paul, bad Paul.

 

You'll need to use `from` to properly edit them.

 

Edit:

UPDATE emails SET `from`="sales@domain.com" WHERE `from`="sales@whatever"

Edited March 15, 2015 by Steven F

[Michael]

 

One more thing. from is a reserved word in MySQL. @Paul, bad Paul.

 

You'll need to use `from` to properly edit them.

 

Edit:

UPDATE emails SET `from`="sales@domain.com" WHERE `from`="sales@whatever"

 

Ah so you did sales@whatever to the sales@domain.com and billing@whatever to billing@domain.com that's a good way to do it

[serge]

yes, off topic, I found Blesta use a lot of mysql reserved terms