(11-01-2017, 04:15 AM)TGates Wrote: Did you check the database to make sure that table already exists? (postfix_vacation_notification)
If it does, than no worries, the installer may be trying to add it a second time (Was a bug fix from a while back.)
DB: sentora > sentora_postfix > vacation_notification
Under that I cud see a table name vacation but not vacation_notification. So something is wrong over here or its normal.
when I searched online, one of the page mentioned to run the below sql manually. Should I run this or the vacation table is ok ?
Postfix notification table
Code:
CREATE TABLE `vacation_notification` (`on_vacation` varchar(255) NOT NULL, notified` varchar(255) CHARACTER SET latin1 NOT NULL, `notified_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`on_vacation`,`notified`), CONSTRAINT `vacation_notification_pkey` FOREIGN KEY (`on_vacation`) REFERENCES `vacation` (`email`) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Postfix Admin - Virtual Vacation Notifications';