SQL error when installing
Did clean install of 3.1b1 to ubuntu 16.04 and it seems that all tables are not created. Tried manually creating database from ispconfig3.sql and got error:
CREATE TABLE IF NOT EXISTS openvz_traffic
(
veid
int(11) NOT NULL DEFAULT '0',
traffic_date
date NULL DEFAULT NULL,
traffic_bytes
bigint(32) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (veid
,traffic_date
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
MySQL said: Documentation #1171 (closed) - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
CREATE TABLE web_traffic
(
hostname
varchar(255) NOT NULL DEFAULT '',
traffic_date
date NULL DEFAULT NULL,
traffic_bytes
bigint(32) unsigned NOT NULL default '0',
PRIMARY KEY (hostname
,traffic_date
)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
MySQL said: Documentation #1171 (closed) - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead