AbanteCart Community
eCommerce construction => Installation and Configuration => Topic started by: kok 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.
-
what version of mysql do you use?
-
Hi abolabo,
I m using MYSQL 5.6.x.
Thank you.
-
looks like your mysql works in strict mode.
Try to replace file public_html/install/abantecart_database.sql by attached and let us know about result.
-
Hi abolabo,
Still getting the error message as below and cannot complete:
Following error has occurred during installation:
OK:
Name Info
10000::database error
Error: Duplicate entry '1' for key 'PRIMARY'
Error No: 1062
INSERT INTO `addresses` VALUES (1,2,'','Juliana','Davis','9778 Golden Crescent','Apt 10','85804-7365','Humansville',223,3616), (2,3,'','Keely','Mccoy','5071 Misty Pond Farm','Suite #101','63406-9081','Bumble Bee',223,3648), (3,4,'BelfastCo','Zelda','Weiss','6944 Sleepy Fawn Abbey','Suite #31','86014-8121','Lawyers',223,3616), (4,5,'','Gloria','Macias','7590 Easy Robin Hollow','','73477-3842','Sandymush',223,3660), (5,6,'','Bernard','Horne','5607 Umber Branch Via','','86301-9785','Spook City',223,3616), (6,7,'','James','Curtis','6500 Arapahoe Road','','80303','Boulder',223,3634), (7,8,'','Bruce','Rosarini','61 Cumberland ST','','68624-2273','Skokie',223,3650), (8,9,'','Carlos','Compton','31 Capital Drive','','63142-0892','Fort Misery',223,3648), (9,10,'','Garrison','Baxter','Eddie Hoffman Highway','','64034-2948','Shell Pile',223,3648), (10,11,'','Anthony','Blair','104 Main Street','','29181-8284','Gassaway',223,3666), (11,12,'','Allen','Waters','110 Shenandoah Avenue','','86565-1710','Honohina',223,3616), (12,13,'','Tom','Kipling','100 Main Str','','64034-2948','Shell Pile',223,3648); in C:\Hosting*******\core\database\mysql.php on line 114
-
recreate your database.. looks like conflict with old install attempts data
-
Hi abolabo,
After I recreate the database, getting below error:
Following error has occurred during installation:
OK:
Name Info
10000::database error
Error: Column count doesn't match value count at row 1
Error No: 1136
INSERT INTO `order_options` VALUES (1,1,2,588,'Memory','8GB','99.0000','+'), (2,2,7,684,'Color','brown','10.0000','+'), (3,3,9,651,'Size','33.8 oz','49.0000','+'), (4,3,10,650,'Size','8 oz','19.0000','+'), (5,3,15,646,'Color','Brown','20.0000','-'), (6,4,16,613,'Color','Mandarin Sky','29.5000','+'), (7,4,18,664,'Fragrance Size','3.4 oz','84.0000','+'), (8,4,19,673,'Fragrance Size','6.7 oz','92.0000','+'), (9,4,21,661,'Fragrance Size','150ml','45.0000','+'), (10,5,23,627,'Color','Jade Fever','48.0000','+'), (11,5,24,626,'Color','Gris Fatale','48.0000','+'), (12,5,25,622,'Color','Shirelle','15.0000','+'), (13,5,26,619,'Color','Lacewood','27.0000','+'), (14,5,27,657,'Color','Light Bisque','30.5000','+'), (15,5,30,651,'Size','33.8 oz','49.0000','+'), (16,6,31,666,'Size','30 ml','30.0000','+'), (17,7,33,649,'Fragrance Size','1.7 oz','88.0000','+'), (18,7,34,660,'Fragrance Size','100ml','37.0000','+'), (19,8,35,646,'Color','Brown','20.0000','-'), (20,8,36,681,'Color','beige','10.0000','+'), (21,12,45,721,'Size','Eau de Toilette','78.5000','$'), (22,12,45,1,'Gift Wrapping','1','78.5000','$'), (23,12,47,738,'Size','30ml','90.0000','$'), (24,13,49,713,'Size','1.7 oz','72.0000','$'), (25,13,49,1,'Gift Wrapping','1','72.0000','$'); in C:\Hosting*******\core\database\mysql.php on line 114
-
you did something wrong with sql files..
i checked our sample data sql and database structure.. column count in this table is correct.
what package version of abantecart do you try to install?
Please downoad release pack here https://github.com/abantecart/abantecart-src and try again
-
Hi abolabo,
Thanks your help, can install completed now. But get another error message in admin login page as below:
"Your server is unable to create a session necessary for AbanteCart functionality. Check logs
for exact error details and contact your hosting support administrator to resolve this error."
Please advice check at which part?
Thank you
-
Hi abolabo,
Thanks your help, can install completed now. But get another error message in admin login page as below:
"Your server is unable to create a session necessary for AbanteCart functionality. Check logs
for exact error details and contact your hosting support administrator to resolve this error."
Please advice check at which part?
Thank you
I suggest you do not post different topics into one thread and search forum for solution first before posting.
See this http://forum.abantecart.com/index.php/topic,4242.msg18581.html#msg18581
-
Hi abolabo,
Noted. Thanks your help.
Thank you.