jeudi 23 juin 2016

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?

Aucun commentaire:

Enregistrer un commentaire