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:
An appropriate representation of the requested resource /phpMyAdmin/tbl_change.php could not be found on this server
The following error accompanies the pageload:
/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:22.214.171.124) 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.