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

[MichaelD]

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

[DrByte]

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:

SecFilterScanPOST Off

or:

SecFilterEngine off

[MichaelD]

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?

[DrByte]

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

[MichaelD]

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?

[DrByte]

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

[MichaelD]

So it won't compromise security if I leave it alone?

[cibertienda]

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

[DrByte]

https://www.zen-cart.com/tutorials/index.php?article=63