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

Gerjan:

True! Sorry, I was to quick with my conclusion that is could be the same problem... you should indeed check your cache first!
They may be the same problem..:smile: but the error message he got says that an error log file was generated, and having it might provide some insight..:yes:

DivaVocals:

Also it would help a GREAT deal if you looked at your cache folder and tell us what the error log that is created when you see this message says..

It was the language/swedish.php - file that caused it.
But i guess i still got the error-log if you need to look further in to the problem.

Lets see. If i got the right error-log it says something like this:

[09-Apr-2012 23:14:27] 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 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 /XXX/includes/classes/db/mysql/query_factory.php on line 101

Gerjan:

Ok, thx. I did encouter the same problem with a Dutch language pack. However, I 'luckely' found an older Dutch language pack version for Zen-Cart 1.5. I replaced my admin/includes/languages/dutch.php and then IH4 installed succesfully.

So in my case there is something wrong with this language file that causes the IH4 to fail the install.

I did compare both files changed a few things and tested again without result. So far I did not manage to find the cause of this problem. But my problem is that I'm not a programmer and I have just little knowledge of php.

If anyone is interested to compare my two dutch files, please PM me. Maybe you can find the problem... and maybe help my Swedish friend :wink:

This may sound weird, but maybe you could try to temporary replace the swedish.php by the english version and rename that to swedish.php (and rename your original swedish.php to swedish.bak so you can can switch back quickly when done).

I know it's not a fix, but for a "test" you can determin if this swedish.php is causing he problem AND you ca move on first.

incredible, it worked! I can live with english admin as long as ewerything works. Thank you for your help!

Luftkaffe:

incredible, it worked! I can live with english admin as long as ewerything works. Thank you for your help!
Glad I could 'help'. You can resore your swedish.php if you want, everything will working normally. It's just a temporary workaround, but now we know it might not just be my Dutch language-file...

installer won't start.
no menu at all.

english zc1.5+ spainish language pack

installer won't start.
no menu at all.

english zc1.5+ spainish language pack

well. i find the problem. the "images" menu not the same in spainish.

the way that ih4 install, well once i had installed ih4. then i re-install the zen cart,
the ih4 install will never start....

weber:

well. i find the problem. the "images" menu not the same in spainish.
I asume this is a language related problem...

weber:

the way that ih4 install, well once i had installed ih4. then i re-install the zen cart, the ih4 install will never start....
So you managed to install IH4 succesfully? Or not?

From what I understand you did install IH4, and then re-installed Zen-Cart? Why? If you reinstall ZC you should also re-install modules... I think you need to explain more or give more details.

Gerjan:

I asume this is a language related problem...

So you managed to install IH4 succesfully? Or not?

From what I understand you did install IH4, and then re-installed Zen-Cart? Why? If you reinstall ZC you should also re-install modules... I think you need to explain more or give more details.

YES. the ih installer locate the images menu, change to your languages. or like me, just set the groud id=4. or if you don't want to modify the ih4 files. just change the spainish.php, set the menu title to "images", after IH4 install, change it back.

One bug: once i install IH4 and then re-install the zen cart, the installer will never activate....i had to re-upload ih4 even they are right there. any way to let the install re-install?

weber:

One bug: once i install IH4 and then re-install the zen cart, the installer will never activate....i had to re-upload ih4 even they are right there. any way to let the install re-install?NOT a bug at all.. this is by design.. If you want to re-install IH4 you need to reload the whole kit and caboodle.. IH4's install does some cleanup after the install.. I'm not gonna "fix" this because it's not broken..

@weber
Nice one. Yes that is a good work around. The IH code will be updated next time round I am sure. For the time being people installing in a language other than english can make a small alteration to the file includes/init_includes/init_image_handler.php. Find where it says:

    /* 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 change this to:

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

This is an error in the code.

For those of you who are going to ask 'why not just set it to 4 in the first place?' the aim was to cover the rare occurence that someone had changed the configuration id of images. It was meant well but was an error.

Finally, if you find yourself in a position where you cannot get into admin because this error is always stopping you then you need to delete a single file which is includes/auto_loaders/config.image_handler.php . That will stop the installer trying to run every time and allow you to make the changes detailed above and solve the problem.

Finally, finally, for those who are saying that the auto-installer is a bad idea the thought is that it just does exactly what you would do if you installed manually. It doesn't do anything new or different. It finds the active template and installs into that. In the same way as one would do by manually. The only difference between this installer and installing manually is that it always creates back-ups of overwriten files. Which has been a source of many many problems on the support threads.

@weber
Sorry, to disagree with Diva just a little bit, but you can get the installer to run again just by re-uploading the includes/auto_loaders/config.image_handler.php file.

This file is deleted after a successful install. Which stops the installer running again and again and again. It is this file that triggers the installation process. (Which is why if you get into problems with the installer it is the one to delete to stop the process)

If you re-upload it and all the other files are in the right place then the installer will run again. It will overwrite the core files again and create new back-ups.

BUT

what Diva says is still the best way of proceeding. Upload the whole thing again and off you go.

niccol:

@weber
Nice one. Yes that is a good work around. The IH code will be updated next time round I am sure. For the time being people installing in a language other than english can make a small alteration to the file includes/init_includes/init_image_handler.php. Find where it says:

/* 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'];

> 
> ```
       /* Find Config ID of Images */
    $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;
```This is an error in the code.  
> 
> For those of you who are going to ask 'why not just set it to 4 in the first place?'  the aim was to cover the rare occurence that someone had changed the configuration id of images.  It was meant well but was an error.
Thanks for posting this niccol.. I was holding off on posting this fix  because I wanted to properly QA the fix and confirm it with my testers..  (color me thorough and cautious!:smile:) Just got confirmation form my testers this morning.. (Tested with both Dutch and Swedish language packs)

There is one other tip for those folks who are using a language other than  English in their stores: 
You MUST copy all of the   language files in             **YOUR_ADMIN/includes/languages/english** to **            YOUR_ADMIN/includes/languages/YOUR_LANGUAGE**

I have updated the install instructions in the readme accordingly and will be submitting an update for IH4 this weekend. (for those who've already gotten IH4 installed there is NO NEED to update your successful IH4 install with this updated version)

Included in this update is a slight change to the naming convention used for the backup files created by the IH4 auto-installer. It was pointed out to me by a community member that some servers restrict the upload of .BAK files.. So I've modified the IH4 package files and supporting code accordingly. 

> **niccol:**
>
> Finally, if you find yourself in a position where you cannot get into admin because this error is always stopping you then you need to delete a single file which is includes/auto_loaders/config.image_handler.php .  That will stop the installer trying to run every time and allow you to make the changes detailed above and solve the problem.Good tip.. I will also add this to the readme file!

> **niccol:**
>
> Finally, finally, for those who are saying that the auto-installer is a bad idea the thought is that it just does exactly what you would do if you installed manually.  It doesn't do anything new or different. It finds the active template and installs into that.  In the same way as one would do by manually.  The only difference between this installer and installing manually is that it always creates back-ups of overwriten files.  Which has been a source of many many problems on the support threads.The auto-installer is a GREAT idea, and it is NOT going away!!!! 

I firmly believe it will cut down on the number of support questions related to faulty installs (the most COMMON reason for support questions in the IH2 and IH3 thread can be DIRECTLY attributed to faulty installs)

Not only does the auto installer do all the things you normally would do in an install it does all the things that most shopowners DO NOT do (and should) during an install.. The backup and restore features of the auto-installer are what makes this INVALUABLE to shopowners..

Actually niccol just re-uploading the includes/auto_loaders/config.image_handler.php file alone doesn't work.. The install fails at the point where the install function attempts to create the backup files.. (hence the reason for my advice to weber)

The errors seem to indicate that the install function can't find some of the files needed during the install. I assume this is because of the cleanup that happens during the initial auto-install..

niccol:

@weber
Sorry, to disagree with Diva just a little bit, but you can get the installer to run again just by re-uploading the includes/auto_loaders/config.image_handler.php file.

This file is deleted after a successful install. Which stops the installer running again and again and again. It is this file that triggers the installation process. (Which is why if you get into problems with the installer it is the one to delete to stop the process)

If you re-upload it and all the other files are in the right place then the installer will run again. It will overwrite the core files again and create new back-ups.

BUT

what Diva says is still the best way of proceeding. Upload the whole thing again and off you go.

:smile: I'll check that.

niccol:

:smile: I'll check that.Cool.. I might as well tell you the WHOLE story on how I made this discovery..:laugh::laugh:

I was installing IH4 on an upgraded store with older Image Handler image configuration settings in the DB (IH2). I ran the install and noticed that the install did not remove the deprecated image settings..

Now I know we both looked at and updated that section of the code (with the list of deprecated configuration settings), but darned if it didn't work the way I expected..:dontgetit

For me of course it was no biggie. So I manhandled those entries out of the configuration table and started my IH4 install over..:laugh: I re-uploaded the includes/auto_loaders/config.image_handler.php clicked on the Admin Home link and got the message that install failed at the point where the install function attempts to create the backup files..

So I uploaded everything again and clicked the Admin Home link and FINALLY my install worked..

Downloaded the current version as of today and followed the install directions word by word (seemed strange not renaming your_template) did the ftp as instructed and

PERFECTO!!!

:bigups::bigups::bigups:

@stuff4toys
that's what we like to hear :-)

@diva
Ha ha! you are right. The template files get cleaned up. One 'dumbass idiot point' for me. :clap::clap:

So, the way to re-install is definitely to re-install the whole thing!

niccol:

@diva
Ha ha! you are right. The template files get cleaned up. One 'dumbass idiot point' for me. :clap::clap:

So, the way to re-install is definitely to re-install the whole thing!:laugh: 'dumbass idiot' are the last words I'd use to describe you!! :laugh:

I only use IH for resizing and watermarks and upgraded to 1.5 without bothering to implement the admin side. Works fine.

So, if there is no admin page (which contains the IH3 install/uninstall control) how do you uninstall IH3 prior to IH4.?

Answer: with this script, pasted and run in Admin->Install SQL Patches:

DELETE FROM configuration WHERE 
configuration_key = 'LARGE_IMAGE_MAX_WIDTH' OR 
configuration_key = 'LARGE_IMAGE_MAX_HEIGHT' OR 
configuration_key = 'SMALL_IMAGE_FILETYPE' OR 
configuration_key = 'SMALL_IMAGE_BACKGROUND' OR 
configuration_key = 'WATERMARK_SMALL_IMAGES' OR
configuration_key = 'ZOOM_SMALL_IMAGES' OR 
configuration_key = 'ZOOM_IMAGE_SIZE' OR 
configuration_key = 'SMALL_IMAGE_HOTZONE' OR 
configuration_key = 'SMALL_IMAGE_QUALITY' OR 
configuration_key = 'MEDIUM_IMAGE_FILETYPE' OR 
configuration_key = 'MEDIUM_IMAGE_BACKGROUND' OR 
configuration_key = 'WATERMARK_MEDIUM_IMAGES' OR 
configuration_key = 'ZOOM_MEDIUM_IMAGES' OR 
configuration_key = 'MEDIUM_IMAGE_HOTZONE' OR 
configuration_key = 'MEDIUM_IMAGE_QUALITY' OR 
configuration_key = 'LARGE_IMAGE_FILETYPE' OR 
configuration_key = 'LARGE_IMAGE_BACKGROUND' OR 
configuration_key = 'WATERMARK_LARGE_IMAGES' OR 
configuration_key = 'LARGE_IMAGE_QUALITY' OR 
configuration_key = 'WATERMARK_GRAVITY' OR 
configuration_key = 'ZOOM_GRAVITY' OR 
configuration_key = 'IH_RESIZE' OR 
configuration_key = 'SHOW_UPLOADED_IMAGES';
```Maybe this should be in the readme too!

Actually if you look at the my post just above to niccol, the auto-install is supposed to take care of this (removing old deprecated IH image settings and properly registering the IH4 menu).. The part of the aut-installer which removes the deprecated image settings is not working right now when you are installing over a previous version of Image Handler and niccol has generously offered to take a looksee to see why that might be.. The auto-installer does install the IH4 menu just fine when you are installing over a previous version of Image Handler.

For now I'd rather leave this tip in the support thread until we can get the auto-installer working. In the meantime if it becomes an issue for folks I can refer them to your thread..

torvista:

I only use IH for resizing and watermarks and upgraded to 1.5 without bothering to implement the admin side. Works fine.

So, if there is no admin page (which contains the IH3 install/uninstall control) how do you uninstall IH3 prior to IH4.?

Answer: with this script, pasted and run in Admin->Install SQL Patches:

Maybe this should be in the readme too!

the auto-install is supposed to take care of this (removing old deprecated IH image settings and properly registering the IH4 menu)

The instructions say

You MUST do a complete uninstall of the hacked up version of Image Handler3
I found no mention that the IH4 installer cleans up old db entries.