X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)
-   -   Send order notification to multiple email addresses (https://forum.x-cart.com/showthread.php?t=65238)

DanielleHoyt 09-23-2014 11:20 AM

Re: Send order notification to multiple email addresses
 
Totaltec,
It says "SQL PATCH FAILED AT QUERY:
REPLACE INTO xcart_config VALUES ('orders_department','Orders department email address','orders@sign-mart.com, danielle@sign-mart.com, dhoytdesign@gmail.com','Company',330,'text','','','email')
PATCH LOG"

PhilJ 09-23-2014 12:08 PM

Re: Send order notification to multiple email addresses
 
Try this? (tested on v4.6.4, but use with caution)

Code:

REPLACE INTO xcart_config VALUES ('users_department','Users department email address','first@email.com,second@email.com','Company',320,'text','','','text','');
REPLACE INTO xcart_config VALUES ('orders_department','Orders department email address','first@email.com,second@email.com','Company',330,'text','','','text','');
REPLACE INTO xcart_config VALUES ('support_department','Help/Support department email address','first@email.com,second@email.com','Company',340,'text','','','text','');


If it doesn't work, try separating the email addresses with semi-colons instead of commas.

To reset, on each line change...
Code:

,'text','');

to...
Code:

,'email','');

DanielleHoyt 09-23-2014 12:17 PM

Re: Send order notification to multiple email addresses
 
PhilJ,
This worked, thank you so much!


All times are GMT -8. The time now is 11:21 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.