Missing Database fields after update

memoo89

Hi,

I have just updated to the Version 6.0.6 and now I am getting the following error message when I try to save a new template:

Unable to create template - Unknown column 'from_name' in 'field list'

Can you please have a look?

Thanks

Ben

Hi,

Please ensure you've granted FULL privileges to the MySQL database user for your MySQL database, so that Sendy can create any new and necessary columns in new updates.

Run the following queries and your issue should be resolved:

ALTER TABLE template ADD COLUMN from_name VARCHAR (100)
ALTER TABLE template ADD COLUMN from_email VARCHAR (100)
ALTER TABLE template ADD COLUMN reply_to VARCHAR (100)
ALTER TABLE apps ADD COLUMN opt_in INT (1) DEFAULT 0

Best regards,
Ben