Results 1 to 9 of 9
  1. #1
    Join Date
    May 2006
    Location
    UK
    Posts
    28
    Plugin Contributions
    0

    help question Add-On Install Problem - Error 406 with sqlpatch.php

    Hi,

    I originally posted this in the Google Base Feeder Support Thread but was advised to start a new thread as it turns out not to be specific to that add-on. I wasn't sure which forum to post this in so, I hope this is OK.

    I'm trying to install Google Base Feeder v1.6.7 with Zen Cart 1.3.7 and Database Patch Level: 1.3.7

    The problem appears when I get to the following part of the install process:

    1. At Admin->Tools->Install SQL Patches I paste the code into the Enter the query to be executed box and click send.
    2. I then get the following error message in my browser:
      406 Not Acceptable

      An appropriate representation of the requested resource /admin/sqlpatch.php could not be found on this server.
    3. I checked on my server and the file exists in the admin directory and...
    4. I've tried changing its permissions to 777
    5. I've tried re-uploading the file and again switching it to 777

    But all I get is the 406 error message quoted above and I've run out of ideas.

    Please can anyone help with this?

    Regards,

    Michael.

    My Zen Cart set up:

    Database: MySQL 4.1.21-standard-log
    HTTP Server: Apache/1.3.37 (Unix)
    PHP Version: 4.4.4 (Zend: 1.3.0)
    Server Host: green.sashbox.net
    Server OS: Linux 2.4.21-37.0.1.ELsmp
    My first Zen Cart site: www.dotcomtoolsuk.com

  2. #2
    Join Date
    Jan 2004
    Posts
    65,307
    Blog Entries
    7
    Plugin Contributions
    228

    Default Re: Add-On Install Problem - Error 406 with sqlpatch.php

    A 406 error when processing raw SQL statements is a result of mod_security restrictions on your webserver, designed to protect you from hackers who would otherwise attempt to damage your site.

    You could try adding one of these to your /admin/.htaccess file:
    Code:
    SecFilterScanPOST Off
    or:
    Code:
    SecFilterEngine off
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    May 2006
    Location
    UK
    Posts
    28
    Plugin Contributions
    0

    help question Re: Add-On Install Problem - Error 406 with sqlpatch.php

    Thank you very much for your swift reply.

    However, I have never edited an .htaccess file before and, after looking at it, I am not sure how or where to insert the code that you have suggested. Please could you, or anyone else, elaborate on the correct method to do so.

    Would it help to see the contents of the existing .htaccess file? If so, is it safe to post the code here?
    My first Zen Cart site: www.dotcomtoolsuk.com

  4. #4
    Join Date
    Jan 2004
    Posts
    65,307
    Blog Entries
    7
    Plugin Contributions
    228

    Default Re: Add-On Install Problem - Error 406 with sqlpatch.php

    Just add it on a new line at the end of the existing file.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    May 2006
    Location
    UK
    Posts
    28
    Plugin Contributions
    0

    Default Re: Add-On Install Problem - Error 406 with sqlpatch.php

    Thanks again for your help.

    The first one you suggested (SecFilterScanPOST Off) worked for me and I completed the install of Google Base Feeder, generated a product feed and uploaded it to Google Base without further problems. (Assuming Google don't bung it back to me of course.)

    Just one more thing: Should I now remove the new line of code I added to the .htaccess file until the next time I want to add an SQL patch?

    Or, can I change the value to "On" and then return it to the "Off" position as and when necessary for inserting further patches?
    My first Zen Cart site: www.dotcomtoolsuk.com

  6. #6
    Join Date
    Jan 2004
    Posts
    65,307
    Blog Entries
    7
    Plugin Contributions
    228

    Default Re: Add-On Install Problem - Error 406 with sqlpatch.php

    You can probably leave it alone.
    Or just add a # before it to disable it until you need it again.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  7. #7
    Join Date
    May 2006
    Location
    UK
    Posts
    28
    Plugin Contributions
    0

    Default Re: Add-On Install Problem - Error 406 with sqlpatch.php

    So it won't compromise security if I leave it alone?
    My first Zen Cart site: www.dotcomtoolsuk.com

  8. #8
    Join Date
    Feb 2010
    Posts
    11
    Plugin Contributions
    0

    Default Re: Add-On Install Problem - Error 406 with sqlpatch.php

    I tried both mods, but now I got 500 error, any idea?

  9. #9
    Join Date
    Jan 2004
    Posts
    65,307
    Blog Entries
    7
    Plugin Contributions
    228

    Default Re: Add-On Install Problem - Error 406 with sqlpatch.php

    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. Replies: 1
    Last Post: 24 Nov 2012, 05:32 PM
  2. v151 Problems with sqlpatch.php after upgrading to v151
    By elvisstuff in forum General Questions
    Replies: 3
    Last Post: 27 Sep 2012, 02:54 PM
  3. sqlpatch.php page not accessible - fresh 1.5 install
    By MillenniumJim in forum Installing on a Linux/Unix Server
    Replies: 4
    Last Post: 5 Aug 2012, 01:34 AM
  4. Error 406 Not Acceptable on install
    By crazycucumber in forum Installing on a Linux/Unix Server
    Replies: 5
    Last Post: 13 Sep 2007, 05:36 PM
  5. 406 Error on banner_manager.php?
    By bettysue in forum General Questions
    Replies: 1
    Last Post: 8 Jul 2007, 10:41 AM

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