6
« on: January 11, 2016, 12:09:47 AM »
Hi there,
I am getting the error message while installing as below, please advice how to solve it.
Following error has occurred during installation:
OK:
Name Info
10000::database error
Error: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
Error No: 1171
CREATE TABLE `fields` ( `field_id` int(11) NOT NULL NULL auto_increment, `form_id` int(11) NOT NULL DEFAULT '0', `field_name` varchar(40) NOT NULL, `element_type` char(1) NOT NULL DEFAULT 'I', `sort_order` int(3) NOT NULL, `attributes` varchar(255) NOT NULL, `settings` text COLLATE utf8_general_ci NOT NULL DEFAULT '', `required` char(1) NOT NULL DEFAULT 'N', `status` smallint(1) NOT NULL default '0', `regexp_pattern` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`field_id`), KEY `field_id` (`field_id`, `form_id`, `status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci; in C:\Hosting*******\core\database\mysql.php on line 114
Thank you.