search

sentora / sentora-installers

Provides a central place to store, version and distribute the Sentora installer and upgrade scripts from.
GNU General Public License v3.0
154 stars 148 forks source link

Table creation error #83

Closed hrace009 closed 9 months ago

hrace009 commented 8 years ago

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:

mrpinks commented 8 years ago

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

Dukecitysolutions commented 9 months ago

Don’t see any current issues. Closing.