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
9 Apr 2014 12:15 PM
Thanks Vera and support team
Last modified: 9 Apr 2014 12:15 PM
TOCDCO
9 Apr 2014 3:11 PM
ALTER TABLE va_order_statuses ADD COLUMN affiliate_mail_type TINYINT DEFAULT '0'
You'll need the extra apostrophe at the end.
Vera
9 Apr 2014 7:53 PM
You are right TOCDCO. I've updated the description.