Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
Vera
Vera
Description
When trying to open Edit Status page in Settings > Orders > Orders Statuses there is a Database error: Invalid SQL.
 
Solution
Open Tools > DB Management > Run SQL Query and run the following query:
ALTER TABLE va_order_statuses ADD COLUMN affiliate_mail_type TINYINT DEFAULT '0'
 
Last modified: 9 Apr 2014 7:52 PM
 
dmOZ
dmOZ
Thanks Vera and support team Smile
Last modified: 9 Apr 2014 12:15 PM
 
TOCDCO
TOCDCO
ALTER TABLE va_order_statuses ADD COLUMN affiliate_mail_type TINYINT DEFAULT '0'
 
You'll need the extra apostrophe at the end.
 
Vera
Vera
You are right TOCDCO. I've updated the description.