Easy Populate with Group Price Per Item

[zcrt12345mm]

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')]

[zcrt12345mm]

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 ?

[JimmyV]

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/showth...t=63993&page=2

The workaround could likely be modified to your setup.

[ml2011]

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', ...