Unable to save campaign - Unknown column 'web_version_lang' in 'field list'

pde10d

how to solve this problem?

i got this message:

Unable to save campaign
Unknown column 'web_version_lang' in 'field list'

Or check https://sendy.co/troubleshooting#403-forbidden-error-when-clicking-save-and-next as you may have "mod_security" enabled on your server.

Ben

Hi,

This is likely due to some columns not being created.

Login to your MySQL database directly via phpmyadmin or any other method you like, then run the following MySQL queries:

ALTER TABLE campaigns ROW_FORMAT=DYNAMIC;
ALTER TABLE lists ROW_FORMAT=DYNAMIC;
ALTER TABLE apps ROW_FORMAT=DYNAMIC;
ALTER TABLE campaigns ADD web_version_lang VARCHAR(50);
ALTER TABLE lists ADD hide INT(1) DEFAULT 0;
ALTER TABLE apps ADD hide_lists INT(1) DEFAULT 1;
ALTER TABLE apps ADD COLUMN opens_tracking INT (1) DEFAULT '1', ADD COLUMN links_tracking INT (1) DEFAULT '1'

Then try again.

Best regards,
Ben