MySQL PHPMyAdmin 未定义索引:行

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/29330472/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 13:25:11  来源:igfitidea点击:

PHPMyAdmin Undefined Index: Rows

mysqlphpmyadminundefined-index

提问by Sawyer05

I'm receiving the error below when using phpMyAdmin. It's occurring every time I create any table.

我在使用 phpMyAdmin 时收到以下错误。每次我创建任何表时都会发生这种情况。

Notice in ./libraries/structure.lib.php#1881
 Undefined index: Rows

Backtrace

./libraries/structure.lib.php#2382: getHtmlForRowStatsTable(
array,
NULL,
boolean false,
boolean false,
string '',
string '',
)
./libraries/display_structure.inc.php#263: PMA_getHtmlForDisplayTableStats(
string '',
NULL,
NULL,
boolean false,
NULL,
string '?db=btc_orders&table=Rep&token=09aa3ad5cb85e33dad2a2098ed2874e2&goto=tbl_structure.php&back=tbl_structure.php',
NULL,
)
./tbl_structure.php#163: require_once(./libraries/display_structure.inc.php)

It only occurs on the one Datadase in PHPMyAdmin with no errors popping up on any others.

它只发生在 PHPMyAdmin 中的一个 Datadase 上,其他任何一个都没有出现错误。

I've deleted all the tables and done them again with the error still occurring every time I add a new table.

我已经删除了所有表并再次完成它们,每次添加新表时仍然出现错误。

回答by Sawyer05

The problem was due to having uppercase characters in the table. I switched to all lower case characters in both the table and field names and the problem disappeared.

问题是由于表中有大写字符。我切换到表和字段名称中的所有小写字符,问题就消失了。