
Originally Posted by
ideasgirl
1366 Incorrect integer value: '' for column 'configuration_group_id' at row 1 in
[INSERT INTO zen_configuration_group VALUES ('', 'Cross Sell Settings', 'Set Cross Sell Options', '1', '1')]
I have this module installed on my store in same server, with same parameters:
Zen Cart Version 1.5.4
Apache Version 2.4.18
PHP Version 5.6.22
MySQL Version 5.5.50-cll
Your MySQL is apparently configured to disallow the (old) use of an empty string to denote a 0 value. In the past we got away with using '' or 0 or null to trigger an autoincrement field, but newer MySQL versions (depending on their configuration) disallow the string option.
So simply changing that first '' to null should work. Sometimes 0 will still work.
ie:
Code:
INSERT INTO zen_configuration_group VALUES (null, 'Cross Sell Settings', 'Set Cross Sell Options', '1', '1')
Bookmarks