Related Products Plugin SQL Error 1366

[danielosko]

Hello Everyone,

I have installed the Related Products Plugin three times on my home server, and I get the following error in my cache file every time that I click on the "INSTALL" button in my admin panel.

[04-Nov-2013 14:20:42 America/New_York] PHP Fatal error: 1366:Incorrect integer value: '' for column 'configuration_id' at row 1 :: INSERT INTO zen_configuration VALUES ('', 'Related Products Columns per Row', 'SHOW_PRODUCT_INFO_COLUMNS_RELATED_PRODUCTS', '3', 'Related Products Columns per Row<br />0= off or set the sort order', '18', '100', NULL, now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\', \'4\', \'5\', \'6\', \'7\', \'8\', \'9\', \'10\', \'11\', \'12\'),') in C:\www\includes\classes\db\mysql\query_factory.php on line 201

I am using:
Zencart 1.5.0
phpMyAdmin 3.5.6
PHP Version 5.4.11

Any help or thoughts on this would be greatly appreciated.

Thanks,
Danny

[bislewl]

There are a couple things going on here.

1.) This mod doesn't say the columns that it should be going into.
2.) It's missing the value of the configuration id this statement should read something like:

INSERT INTO zen_configuration
(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
VALUES ('Related Products Columns per Row', 'SHOW_PRODUCT_INFO_COLUMNS_RELATED_PRODUCTS', '3', 'Related Products Columns per Row<br />0= off or set the sort order', '18', '100', NULL, now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\', \'4\', \'5\', \'6\', \'7\', \'8\', \'9\', \'10\', \'11\', \'12\'),')

[danielosko]

There are a couple things going on here.

1.) This mod doesn't say the columns that it should be going into.
2.) It's missing the value of the configuration id this statement should read something like:

INSERT INTO zen_configuration
(configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function)
VALUES ('Related Products Columns per Row', 'SHOW_PRODUCT_INFO_COLUMNS_RELATED_PRODUCTS', '3', 'Related Products Columns per Row<br />0= off or set the sort order', '18', '100', NULL, now(), NULL, 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\', \'4\', \'5\', \'6\', \'7\', \'8\', \'9\', \'10\', \'11\', \'12\'),')

Thanks MUCH!

That corrected the error.
Danny

[fcutler4]

Along this line, I'm not seeing the "Install" button at all after uploading the files for the related products plugin. I looked in my query_factory.php file and there is no Insert into Configuration code as described above, and, needless to say, I'm not seeing anything in my Product Info configuration file that refers to related products. Did I somehow miss this when I uploaded files? I upload both the standard and the optional files. Any guidance would be appreciated. It seems the functionality is there for related products, aside from the missing configuration ability to change the number showing up in the rows.

I'm using zencart 1.5.1
phpMyAdmin 3.5.5