sentora-installers icon indicating copy to clipboard operation
sentora-installers copied to clipboard

Table creation error

Open hrace009 opened this issue 9 years ago • 1 comments

Seems there is a little problem on sentora Installer http://sentora.org/install On the install log, i seen ERROR 1005 (HY000) at line 98: Can't create table 'sentora_postfix.vacation_notification' (errno: 150) The error showon at installaing postfix. Overall, everything is fine, and the panel run normal, but that error really disturbing me :dancer:

hrace009 avatar Dec 05 '15 21:12 hrace009

I created the table manually post install::

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';

The SQL for the postfix tables is here for Sentora: https://github.com/sentora/sentora-installers/blob/master/preconf/sentora-install/sql/sentora_postfix.sql

mrpinks avatar Sep 25 '16 23:09 mrpinks

Don’t see any current issues. Closing.

Dukecitysolutions avatar Dec 31 '23 09:12 Dukecitysolutions