Consistent problem with phpMyAdmin...

MGCJerry · #1 08-10-2008, 11:41 PM

I've been trying to troubleshoot this stupid issue on my site before contacting my host about this issue.

I have a version of phpMyAdmin installed on my site thats tied into my site admin account, but that is not the problem.

The problem is the fact that on some tables, Apache returns a "Not Acceptable" error upon trying to edit some of the rows in some tables.

I get the following error:

Quote:

Not Acceptable

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

The following error accompanies the pageload:

Quote:

/phpMyAdmin/tbl_change.php?lang=en-iso-8859-1&convcharset=iso-8859-1&server=1&db=MY_DATABASE_USERNAME&table=MY_DATABASE_TABLE&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&prima ry_key=+%60id%60+%3D+%271%27&sql_query=SELECT++%2A++FROM++%60MY_DATABASE_TABLE%60+&goto=sql.php HTTP/1.1" 406 476 "http://www.2thextreme.org/phpMyAdmin/sql.php?lang=en-iso-8859-1&convcharset=iso-8859-1&server=1&db=MY_DATABASE_USERNAME&goto=db_details_structure.php&table=MY_DATABASE_TABLE&sql_query=SELECT+%2A+FROM+%60MY_DATABASE_TABLE%60&pos=0" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.1) Gecko/2008070208 Firefox/3.0.1"

I get this error when I click the "Edit" link to edit a record on some tables. However, on other tables theres no problem at all. This has done this with all versions of phpMyAdmin from 2.3 up to the 2.11 or whatever release.

I've tried optimizing and repairing the tables and this issue is still present, and punching the error into google is giving retarded results (3 results with one result not mentioning the issue at all).

I've also tried turning of mod_security, but it just returns a 500 error, so I doubt that addresses this issue.

Yes, the version of phpMyAdmin running in my control panel (Cpanel) works HOWEVER, I have a version running within my site admin panel where I dont have to give fellow admins access to my cpanel information.

So... Has anyone encountered this issue or know any way of troubleshooting it or is this a "contact your host" issue?

Thanks in advance.

**foobic** · #2 08-11-2008, 12:16 AM

It'll be mod_sec, almost certainly.

Quote:

Originally Posted by MGCJerry

I've also tried turning of mod_security, but it just returns a 500 error, so I doubt that addresses this issue.

Mod_security can be set up to disallow changes in .htaccess. Even if you are allowed to do this you need to know which version the server's running. Contact your host.

bsolaris · #3 08-11-2008, 02:15 AM

Posted in wrong thread. Sorry

junitha · #4 08-11-2008, 07:05 AM

Which version of mod_security is installed in the server? simply mod_sec or mod_sec2 ?

MGCJerry · #5 08-11-2008, 06:01 PM

Thanks for the replies... Looks like I'll be opening another ticket with my host.

I have no idea what version of mod_security they run. I'll ask in the ticket.