X-Cart forums

[DanielleHoyt]

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]

Try this? (tested on v4.6.4, but use with caution)

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...

,'text','');

to...

,'email','');

[DanielleHoyt]

PhilJ,
This worked, thank you so much!