Search code examples
phpmysqlphpmyadmineasyphp

phpMyAdmin issue with specific table cannot edit rows errors with blank where statement

Subject pretty much says it all. I have as specific table that PMA just will absolutely not let me edit the rows. I cannot use the inline table editor and and I cannot click the "edit" link for any row.

PMA barfs with a bad query error due to the fact that for one, the "where_clause" parameter is empty in the link code, thus causing it to run some query that looks like this: SELECT * FROM database.table WHERE .... WHERE WHAT?

I have no clue why PMA does not create the edit links correctly. There is most certainly and id column that is unique and set as primary.

I'm using version 4.5.4 on a windows easyphp16.1 set up.

I have tried analyzing, checking, repairing the table with no results.

Does anyone have any idea what the heck would be causing something like this?

Solution

  • Are you using lower_case_table_names = 2 in your MySql (my.ini) configuration? Then your probably encountering this bug:

    https://github.com/phpmyadmin/phpmyadmin/issues/11816

    You can try downgrading to an older phpmyadmin version e.g. 4.4.15.2 until the bug is fixed.