Forums / All Other Contributions/Addons / Easy Populate with Group Price Per Item

Easy Populate with Group Price Per Item

Views: 1,839

Results 1 to 4 of 4
31 Dec 2010, 1:16 AM
#1
zcrt12345mm avatar

zcrt12345mm

New Zenner

Join Date:
Dec 2010
Posts:
17
Plugin Contributions:
0

Easy Populate with Group Price Per Item

Getting this error not sure what it means

1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1')]

31 Dec 2010, 5:01 AM
#2
zcrt12345mm avatar

zcrt12345mm

New Zenner

Join Date:
Dec 2010
Posts:
17
Plugin Contributions:
0

Re: Easy Populate with Group Price Per Item

I get this message

Easy Populate Configuration Missing. Please install your configuration by clicking here

then when I click 'here' I get

1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1')]

I tried sql patches from install_sql.txt

INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1');

and get this error

1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1
in:
[INSERT INTO configuration_group VALUES ('', 'Easy Populate', 'Config options for Easy Populate', '1', '1');]

How do I fix this ?

3 Jan 2011, 7:18 PM
#3
jimmyv avatar

jimmyv

Zen Follower

Join Date:
Feb 2008
Location:
Philadelphia
Posts:
292
Plugin Contributions:
2

Re: Easy Populate with Group Price Per Item

Are you still having this problem?

Check this out regarding integer values with specific server setups as it seems to be related.
http://www.zen-cart.com/forum/showthread.php?t=63993&page=2

The workaround could likely be modified to your setup.

21 Feb 2011, 7:58 PM
#4
ml2011 avatar

ml2011

New Zenner

Join Date:
Feb 2011
Posts:
1
Plugin Contributions:
0

Re: Easy Populate with Group Price Per Item

I had the same problem. MySQL (5?) apparently doesn't like null strings('') for integers on auto_increment fields. Add the 0's below and it should install without an error.

Install Easy Populate Configuration v1.2.5.4

INSERT INTO configuration_group VALUES ('0', 'Easy Populate', 'Config options for Easy Populate', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
INSERT INTO configuration VALUES
('0', 'Uploads Directory', ...
('0', 'Upload File Date Format',...
('0', 'Default Raw Time', ...
('0', 'Split File On # Records',...
('0', 'Maximum Category Depth', ...
('0', 'Upload/Download Prices Include Tax',...
('0', 'Make Zero Qty Products Inactive', ...
('0', 'Smart Tags Replacement of Newlines', ...
('0', 'Advanced Smart Tags', ...
('0', 'Debug Logging', ...