Image Handler 4 (for v1.5.x) Support Thread

[feedmysky]

I've read the 39page thread,No answered for this question.
Zencart 1.5.1 english version, MySQL 5.0.96, php:5.3.8 (Zend: 2.3.0) ,Self-built template
After my uploading the Image Handler 4 to my host, I can't get into my admn page,it shows the error message:

WARNING: An Error occurred, please refresh the page and try again.
Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1001, now(), now(), NULL, 'zen_cfg_select_option(array(''yes'',''no''),')' at line 1 :: INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'IH resize images', 'IH_RESIZE', 'no', 'Select either -no- which is old Zen-Cart behaviour or -yes- to activate automatic resizing and caching of images. --Note: If you select -no-, all of the Image Handler specific image settings will be unavailable including: image filetype selection, background colors, compression, image hover, and watermarking-- If you want to use ImageMagick you have to specify the location of the convert binary in includes/extra_configures/bmz_image_handler_conf.php.', , 1001, now(), now(), NULL, 'zen_cfg_select_option(array(''yes'',''no''),') in /home/easyoutl/public_html/includes/classes/db/mysql/query_factory.php on line 121

[feedmysky]

problem solved!
admin/includes/init_includes/init_image_handler.php
Replace

$sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".BOX_CONFIGURATION_IMAGES."' LIMIT 1";
    $result = $db->Execute($sql);
        $im_configuration_id = $result->fields['configuration_group_id'];

with

$sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='Images' LIMIT 1";
    $result = $db->Execute($sql);
        $im_configuration_id = $result->fields['configuration_group_id'];
   if($im_configuration_id == '') $im_configuration_id = 4;

[DivaVocals]

And I need to chime in that this is specific to your setup.. For most everyone else the code in IH4 works as is without needing to modify the auto-installer..

problem solved!
admin/includes/init_includes/init_image_handler.php
Replace

$sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".BOX_CONFIGURATION_IMAGES."' LIMIT 1";
    $result = $db->Execute($sql);
        $im_configuration_id = $result->fields['configuration_group_id'];

with

$sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='Images' LIMIT 1";
    $result = $db->Execute($sql);
        $im_configuration_id = $result->fields['configuration_group_id'];
   if($im_configuration_id == '') $im_configuration_id = 4;