Author Topic: Data Configuration error  (Read 9151 times)

Offline kok

  • Newbie
  • *
  • Posts: 48
  • Karma: +3/-1
    • View Profile
Data Configuration error
« 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.
« Last Edit: January 13, 2016, 02:04:00 AM by Basara »

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Data Configuration error
« Reply #1 on: January 11, 2016, 07:38:44 AM »
what version of mysql do you use?
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline kok

  • Newbie
  • *
  • Posts: 48
  • Karma: +3/-1
    • View Profile
Re: Data Configuration error
« Reply #2 on: January 12, 2016, 08:29:32 PM »
Hi abolabo,

I m using MYSQL 5.6.x.

Thank you.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Data Configuration error
« Reply #3 on: January 13, 2016, 06:42:37 AM »
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.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline kok

  • Newbie
  • *
  • Posts: 48
  • Karma: +3/-1
    • View Profile
Re: Data Configuration error
« Reply #4 on: January 13, 2016, 10:34:34 PM »
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

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Data Configuration error
« Reply #5 on: January 14, 2016, 05:20:56 PM »
recreate your database.. looks like conflict with old install attempts data
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline kok

  • Newbie
  • *
  • Posts: 48
  • Karma: +3/-1
    • View Profile
Re: Data Configuration error
« Reply #6 on: January 14, 2016, 10:03:33 PM »
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

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Data Configuration error
« Reply #7 on: January 15, 2016, 03:03:53 AM »
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
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline kok

  • Newbie
  • *
  • Posts: 48
  • Karma: +3/-1
    • View Profile
Re: Data Configuration error
« Reply #8 on: January 15, 2016, 03:33:34 AM »
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

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: Data Configuration error
« Reply #9 on: January 15, 2016, 10:54:04 AM »
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
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline kok

  • Newbie
  • *
  • Posts: 48
  • Karma: +3/-1
    • View Profile
Re: Data Configuration error
« Reply #10 on: January 17, 2016, 10:19:05 PM »
Hi abolabo,

Noted. Thanks your help.

Thank you.

 

Powered by SMFPacks Social Login Mod