特定表的phpMyAdmin问题无法编辑空白wh​​ere语句的行错误 [英] phpMyAdmin issue with specific table cannot edit rows errors with blank where statement

问题描述

主题几乎说明了一切.我有一个特定的表，PMA绝对不会让我编辑行.我不能使用内联表编辑器，也不能单击任何行的编辑"链接.

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的查询错误，原因之一是链接代码中的"where_clause"参数为空，从而导致它运行如下所示的查询:SELECT * FROM database. c1>在哪里....在什么地方?

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?

我不知道为什么PMA无法正确创建编辑链接.最肯定的是，id列是唯一的，并设置为主列.

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.

我正在Windows easyphp16.1设置上使用版本4.5.4.

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?

推荐答案

您是否在MySql(my.ini)配置中使用lower_case_table_names = 2?然后您可能遇到此错误:

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

您可以尝试降级到较旧的phpmyadmin版本，例如4.4.15.2，直到错误修复.

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

这篇关于特定表的phpMyAdmin问题无法编辑空白wh​​ere语句的行错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！