Page 57 of 59 FirstFirst ... 7475556575859 LastLast
Results 561 to 570 of 583
  1. #561
    Join Date
    Apr 2008
    Location
    Qld, Australia
    Posts
    250
    Plugin Contributions
    6

    Default Re: Image Handler installation SQL error

    Wow! 3 backslashes. I had already tried 2 \\ and '' as per SQL manuals but not 3.

    Thanks again.
    OldNGrey
    ZC158a PHP 8.2.15
    MySQL 10.6.16-MariaDB

  2. #562
    Join Date
    Apr 2011
    Posts
    369
    Plugin Contributions
    0

    Default Re: Image Handler installation SQL error

    I just upgraded from 5.3.0 to 5.3.3

    Not sure what happened or if it was like this before the update but my Image handler page ( Image manager tab) is blank.

    Only the category are being displayed. No matter which category i select in the dropdown, it won't move from the first one. There is no product being displayed after that.

    Name:  Clipboard01.jpg
Views: 208
Size:  22.7 KB

    I uninstall/install the plugin but same thing. Also no error logs are present

    Any help would be appreciated.

    Thank you

  3. #563
    Join Date
    Jun 2008
    Location
    Japan
    Posts
    115
    Plugin Contributions
    5

    Default Re: Image Handler installation SQL error

    I got problems with a new install of V5.3.3 on an 'old' site running ZC 1.5.8a with Japanese pack.
    After install 'IH resize images' option is set to 'no'. When I change it to 'yes', all categories images are missing on catalog side and some product ones too...
    When setting back to 'no' everything works fine.

    I then installed IH v5.3.3 on a default ZC 1.5.8a with only demo data and it is better. Problem occurs only on subcategories thumbnail (small image) display.
    For example, clicking on DVD movies displays subcategories and all images are fines. But when clicking on a subcategory you got a product listing with all there images but subcategories image on top is gone. Same on a product page.
    There are no log or error at all. But looking at Apache log, call for image return a 500 error like this:
    "GET /bmz_cache/c/categories-subcategory_cartoonsgif.image.57x32.gif HTTP/2.0" 500 ...
    It looks to me that resizing is failing and only images already at the right size are displayed.

    I have PHP 8.1.20 with gd extension 2.1.0 that is installed and seems to work.

    Imagick 3.7.0 is installed too but IH doc mentioned a convert binary that I can't find and was not able to test it.

    Any idea welcomed...

  4. #564
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Image Handler installation SQL error

    It would help to understand what your IH configuration settings are.

    When you indicate that the image-retrieval is receiving "GET /bmz_cache/c/categories-subcategory_cartoonsgif.image.57x32.gif HTTP/2.0" 500 ... without an accompanying PHP error log, I'm confused as I don't understand what kind of server configuration would make that happen.

    I've got Image Handler installed on my Zen Cart 1.5.8a demo site (https://zc158.vinosdefrutastropicales.com/zc158/) and am not "seeing" the issue.

    Any additional bits of configuration information would help me help you.

  5. #565
    Join Date
    Jun 2008
    Location
    Japan
    Posts
    115
    Plugin Contributions
    5

    Default Re: Image Handler installation SQL error

    Quote Originally Posted by lat9 View Post
    It would help to understand what your IH configuration settings are.

    When you indicate that the image-retrieval is receiving "GET /bmz_cache/c/categories-subcategory_cartoonsgif.image.57x32.gif HTTP/2.0" 500 ... without an accompanying PHP error log, I'm confused as I don't understand what kind of server configuration would make that happen.

    I've got Image Handler installed on my Zen Cart 1.5.8a demo site (https://zc158.vinosdefrutastropicales.com/zc158/) and am not "seeing" the issue.

    Any additional bits of configuration information would help me help you.
    Because it was not a PHP error, it was due to the .htaccess in bmz_cache folder. I found another error in Apache log that I missed before:
    '..testcart/bmz_cache/.htaccess: Invalid command 'Order', perhaps misspelled or defined by a module not included in the server configuration,..'
    I run on Apache 2.4.57 and the .htaccess commands are for Apache 2.2 ... They are deprecated but still work if you use only 2.2 type commands but should not be mixed with 2.4 type ones.
    I changed :
    Code:
    # deny *everything*
    <FilesMatch ".*">
      Order Allow,Deny
      Deny from all
    </FilesMatch>
    
    # but now allow just *certain* necessary files:
    <FilesMatch "(?i).*\.(jpe?g|gif|webp|png|swf)$" >
      Order Allow,Deny
      Allow from all
    </FilesMatch>
    TO:
    Code:
    # deny *everything*
    <FilesMatch ".*">
        Require all denied
    </FilesMatch>
    
    # but now allow just *certain* necessary files:
    <FilesMatch "(?i).*\.(jpe?g|gif|webp|png|swf)$" >
        Require all granted
    </FilesMatch>
    And it fix it!

    Use of old Apache 2.2 style for compatibility should be done using if condition together with 2.4 style.

  6. #566
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Image Handler installation SQL error

    Thanks for that update! I'll need to update the IH distribution to supply both the older and now-current Apache directives. GitHub issue forthcoming.

    GitHub tracking issue: https://github.com/lat9/zen_Image-Handler/issues/15
    Last edited by lat9; 2 Jul 2023 at 05:42 PM. Reason: Added GitHub issue

  7. #567
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Image Handler installation SQL error

    Image Handler 5, v5.3.4, is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2169

    This release corrects GitHub issue #15, updating bmz_cache/.htaccess for installations that use Apache 2.4.

    Thanks to @pilou2 for the correction!

  8. #568
    Join Date
    Jun 2008
    Location
    Japan
    Posts
    115
    Plugin Contributions
    5

    Default Re: Image Handler installation SQL error

    Quote Originally Posted by lat9 View Post
    Image Handler 5, v5.3.4, is now available for download: https://www.zen-cart.com/downloads.php?do=file&id=2169

    This release corrects GitHub issue #15, updating bmz_cache/.htaccess for installations that use Apache 2.4.

    Thanks to @pilou2 for the correction!
    Happy to be helpful!
    You were very quick to release an update!

  9. #569
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Image Handler installation SQL error

    Quote Originally Posted by pilou2 View Post
    Happy to be helpful!
    You were very quick to release an update!
    IH has been stable over the past couple of months and this felt like an issue that needed to get "squashed" ASAP!

  10. #570
    Join Date
    Mar 2007
    Location
    Oregon
    Posts
    152
    Plugin Contributions
    0

    Default Re: Image Handler installation SQL error

    Pictures not showing up after install of new database.

    Upgraded Zen to 1.5.7d from 1.5.7b. Installed new database but none of my pictures are showing up. On the product page it says the image is not found. When I look at the server, it is there. If I go to Image Handler, says No images. No error logs. Help....

    site: https://test.fantasycostume.com/1890-stripe-man_costume
    17 Years and still just a "Follower." :P

 

 

Similar Threads

  1. v150 Image Handler 4 (for v1.5.x) Support Thread
    By DivaVocals in forum All Other Contributions/Addons
    Replies: 1684
    Last Post: 2 Oct 2022, 06:55 AM
  2. Attribute image replaces main product image on select [Support Thread]
    By exoticcorpse in forum All Other Contributions/Addons
    Replies: 158
    Last Post: 24 Aug 2020, 05:07 PM
  3. v139h Image Handler 3 Support Thread (for ZC v1.3.9)
    By DivaVocals in forum All Other Contributions/Addons
    Replies: 1095
    Last Post: 2 Oct 2017, 12:42 PM
  4. v138a Image Handler 2 (for ZC v1.3.8 ONLY) Support
    By timkroeger in forum All Other Contributions/Addons
    Replies: 7098
    Last Post: 12 Oct 2014, 03:48 AM
  5. Image Handler Support Please
    By nadinesky in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 30 Sep 2013, 03:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR