I tried to install SpiceCRM, and I received a message near the end of the install. All the tables (that I checked) have null values (even though this is my second try and I checked I want demo data).
This is the contents of the sugarcrm.log file:
Mon Jan 15 20:37:54 2018 [-none-][FATAL] Error creating table: sysfts Query Failed: CREATE TABLE sysfts (module varchar(255) NULL ,index_priority int NULL ,ftsfields text NULL ,activated_date date NULL ,activated_fields text NULL ,settings text NULL , PRIMARY KEY (module)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1171: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
Any ideas on what I should do? It’s my second attempt and while I would like to kick the tires and perform a comparison with my current solution, I’m not able to.
I have ubuntu 16.04 running php7 and mysql database.
Thanks in advance