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

[niccol]

@makenoiz

yes.

[makenoiz]

Great... will install tonite!

[RodG]

Hi Guys,

I've just been doing an upgrade to a Zen 1.3.7 site to V1.5.1, and have run into a problem I've not experienced before even though I've done many of these.

The problem is with when I install IH4 I can no longer log into the admin of the site. Greeted with 'an error occurred please refresh the page'.

The log files reveal:

[20-Feb-2013 00:36:53] PHP 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 zen_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 <strong>convert</strong> binary in <em>includes/extra_configures/bmz_image_handler_conf.php
</em>.', , 1001, now(), now(), NULL, 'zen_cfg_select_option(array(''yes'',''no''),') in
/home/spotty/public_html_dev/includes/classes/db/mysql/query_factory.php on line 120

Any ideas what would cause this? Its been bugging me for several hours and need to call it a night. Hopefully with some fresh ideas in the morning.


Cheers
Rod

[niccol]

It is the installer not finding the configuration group id for whatever reason.

Find this bit of code in your_admin/includes/init_includes/init_image_handler.php

    /* Find Config ID of Images */
    $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'];

And override it by adding this directly after it.

$im_configuration_id = '4';

Probably '4' is the configuration id of your images menu item but you could check that before hand if you are feeling perky.

[RodG]

It is the installer not finding the configuration group id for whatever reason.
<snip>

$im_configuration_id = '4';

Probably '4' is the configuration id of your images menu item but you could check that before hand if you are feeling perky.

Thanks Nick. You were right, the $im_configuration_id wasn't being set, but when manually setting this it led to even further problems, so I figured it was time for me to backout of things and start the upgrade afresh. This time it worked just fine, no errors reported at all and the upgrade completed with about as much ease as any others I've done.

I can only guess something went amiss with my 1st set of uploads. A little embarrassing to admit to really, but then again, it is quite often these 'simple' problems/solutions that seem to cause the most headaches.

Thanks again,
Rod

[DivaVocals]

Thanks Nick. You were right, the $im_configuration_id wasn't being set, but when manually setting this it led to even further problems, so I figured it was time for me to backout of things and start the upgrade afresh. This time it worked just fine, no errors reported at all and the upgrade completed with about as much ease as any others I've done.

I can only guess something went amiss with my 1st set of uploads. A little embarrassing to admit to really, but then again, it is quite often these 'simple' problems/solutions that seem to cause the most headaches.

Thanks again,
Rod

Nah wasn't you at all.. I have been busy as heck and dragging my heels on submitting an update to IH4 which includes among other things the fix niccol posted.. Will get on it right now.. Glad you are all sorted now..

[DivaVocals]

Changelog includes:

• Backup files generated by the auto-installer are now given the OLD.IH4 extension instead of the BAK extension (which some server configurations disallowed)
• Configuration settings are now consistently and correctly appended to the default Images configuration section
• Updates to the readme file.

I'll post an update in this support thread when the new version is available..