fobes77:
INSERT INTO configuration ('configuration_title', 'configuration_key', 'configuration_value', 'configuration_description', 'configuration_group_id', 'sort_order', 'last_modified', 'date_added', 'use_function', 'set_function') VALUES ('IH version', 'IH_VERSION', '4.3.2', 'IH Version is stored but not shown on configuration menus', '6', '10000', NULL, '0001-01-01 00:00:00.000000', NULL, NULL);
>
> Cheers Design75. I tried inserting that SQL (above) through the Zen Cart admin and got a 'WARNING: An Error occurred, please refresh the page and try again.' message.
>
> Checking my logs it says that there is a syntax error in the SQL code? I'm not great with SQL syntax, is there an obvious error?
>
> Also I am using Image Handler v4.3.2 - it seems to be the latest version?
>
> Thanks for your help!
> **fobes77:**
>
> Just to add to the above -
>
> I have entered the code into the database manually via phpMyadmin...
>
> ```
INSERT INTO `MYDATABASENAME`.`configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`, `configuration_tab`) VALUES (NULL, 'IH version', 'IH version', '4.3.2', 'IH Version is stored but not shown on configuration menus', '6', '10000', NULL, '0001-01-01 00:00:00.000000', NULL, NULL, 'General');
Which seemed to work ok but I still get the "No Image Handler information found." message when going to the IH Zen admin page!
Very strange?! :huh:
Looks like your "successful" SQL was in error... The configuration_key that you have is incorrect as IH version instead of IH_VERSION. Try the below in the admin->tools->Install SQL Patches window.
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('IH version', 'IH_VERSION', '4.3.2', 'IH Version is stored but not shown on configuration menus', '6', '10000', NULL, now(), NULL, NULL);
as for configuration_tab being a field? What version of ZC again? That's not a standard field in the configuration table.
