# Database Error upon installation, all Null values **URL:** \ **Category:** Installation\ **Created:** [January 16, 2018, 2:52am UTC](https://community.spicecrm.io/t/database-error-upon-installation-all-null-values/236 "2018-01-16T02:52:48Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![1reason](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/1reason/32/125_2.png) [@1reason](https://community.spicecrm.io/u/1reason)\ **Post date:** [January 16, 2018, 2:52am UTC](https://community.spicecrm.io/t/database-error-upon-installation-all-null-values/236/1 "2018-01-16T02:52:48Z")
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 [1863][-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 ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [January 16, 2018, 7:57am UTC](https://community.spicecrm.io/t/database-error-upon-installation-all-null-values/236/2 "2018-01-16T07:57:48Z")
Content for sysfts table is generated dynamically. It looks like there is a check missing there. Does the installation go through when you only click demo data and not fts data? ---
**Author:** ![1reason](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.spicecrm.io/1reason/32/125_2.png) [@1reason](https://community.spicecrm.io/u/1reason)\ **Post date:** [January 16, 2018, 1:18pm UTC](https://community.spicecrm.io/t/database-error-upon-installation-all-null-values/236/3 "2018-01-16T13:18:04Z")
Thanks for your reply. I’ve tried to install twice, once without demo data, and the second time with. Both times with the same result. The tables are made, and other than the small message of an error, it appears to have installed correctly. In the user table, all values are null and I can’t login. I just tried to login now (to the second attempted installation), and I receive the following message: _Url rewrite is not working. Please ensure you have enabled and configured url rewriting on this webserver._ Maybe that’s the issue? if so, any advice on how to solve that? And does that mean another reinstall? Also, I’m not sure if this matters, albeit I’m currently using a 192.168.x.x and not using a domain. Thanks again ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [January 16, 2018, 10:13pm UTC](https://community.spicecrm.io/t/database-error-upon-installation-all-null-values/236/4 "2018-01-16T22:13:39Z")
Which version of php7 and mysql are run exactly? PHP7.0? 7.1? 7.2? MySQL 5.7? Please check KREST installation guide for url rewrite issue: > **[KREST Installation Guide](https://www.spicecrm.io/download/krest-installation-guide/)** > > Visit the post for more. ---
**Author:** ![maretval](https://avatars.discourse-cdn.com/v4/letter/m/b38774/32.png) [@maretval](https://community.spicecrm.io/u/maretval)\ **Post date:** [January 16, 2018, 10:28pm UTC](https://community.spicecrm.io/t/database-error-upon-installation-all-null-values/236/5 "2018-01-16T22:28:37Z")
I re-run an installation with demo data, it worked. ![Installdemodata](https://canada1.discourse-cdn.com/flex030/uploads/spicecrm/original/1X/b4995b21cd2a4b49934c48675663acb5ff9573f6.PNG)