'406 Not acceptable' error

Locked

Results 1 to 5 of 5

This thread is locked. New replies are disabled.

09 May 2009, 08:53

travellers

Zen Follower

Join Date:: Oct 2008
Posts:: 143
Plugin Contributions:: 0

'406 Not acceptable' error

I'm trying to mirror an existing zencart to another domain and got this error. Ran a new install of zen on the second domain, all installed correctly - didn't take any 'demo' products. Then went into admin, and run SQL statements, and copied in there a fresh download from my first domain (which is working fine). Hit submit, and got the following:

Not Acceptable

An appropriate representation of the requested resource /admin/sqlpatch.php could not be found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Ran a quick search and came up with this thread https://www.zen-cart.com/forum/showthread.php?p=498532 but the two suggestions in there didn't help me :no:

09 May 2009, 09:10

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: '406 Not acceptable' error

It's likely a mod_security rule (managed by your hosting company) that's causing that 406 error.
The suggestions in the thread you mentioned should have worked.
Since you said they didn't work, you'll need to talk to your hosting company to find a suitable workaround to not trigger the security rule.
Or use phpMyAdmin instead.

09 May 2009, 09:28

travellers

Zen Follower

Join Date:: Oct 2008
Posts:: 143
Plugin Contributions:: 0

Re: '406 Not acceptable' error

I have to say I get a bit scared wandering round in phpMyAdmin, but it did seem fairly straightforward to do this bit so I had a go. Selected my database, hit the sql tab, there's a window to input the raw sql. Downloaded a fresh copy of the sql from my 'main' domain after ticking the 'no compression' tab and got myself a huge notepad file, copied and pasted that into the phpMyAdmin window, hit Submit.
A minute later the screen refreshed, with a bit at the top that said

Your SQL query has been executed successfully

.
So I looked at the new domain in my browser, and nothings changed! Its still the same brand new empty install, and doesn't have any of the customisations or products of my existing install on the other domain. I dunno whats happening now :oops:

09 May 2009, 09:46

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,506
Plugin Contributions:: 173

Re: '406 Not acceptable' error

When you did your "brand new empty install", did you select a table-prefix during the install phase? That table-prefix needs to match whatever table-prefix is used on your "main" site ... otherwise, while the data is present, the software doesn't know which tables to use in the database.

One way to "fix" it could be to compare the DB_PREFIX setting from the /includes/configure.php file from your "main" site against the "new" one. Change the "new" one to match the "main" one. You'll have to repeat it for the admin/includes/configure.php file once you have it reading the data properly.

09 May 2009, 10:26

travellers

Zen Follower

Join Date:: Oct 2008
Posts:: 143
Plugin Contributions:: 0

Re: '406 Not acceptable' error

You're a very clever cookie :cool:
Many thanks, I hadn't even thought that since I installed the 'new' one via the dreaded Fanstastico to save time, it might add a prefix I didn't want. Sure enough 'zen_' instead of ''. Makes you realise, 'saving time' doesn't necessarily mean 'saving time'!!!