'406 Not acceptable' error

**travellers** · 9 May 2009, 09:53 AM

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:

Code:

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

**DrByte** · 9 May 2009, 10:10 AM

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.

**travellers** · 9 May 2009, 10:28 AM

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

Code:

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

**DrByte** · 9 May 2009, 10:46 AM

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.

**travellers** · 9 May 2009, 11:26 AM

You're a very clever cookie

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'!!!