PHPMyAdmin Undefined Index: Rows

Question

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

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.

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

Thermonuclear

When you go in there with a step debugger, why does the index variable has the wrong value? – Killough

When you go in with a step debugger you can normally directly see by placing a breakpoint at the reported problem location. – Killough

In my case the problem was fixed just by making the table name lower case while I still have uppercase in the column names. – Gettogether

The problem is a phpmyadmin bug, it fails to add the last field at the end of the statement it ends with the keword AFTER with the field name missing. ALTER TABLE ocr_files ADD size FLOAT NULL AFTER – Undis

Answer 1

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.

Thermonuclear

I don't think that's an actual answer, so much as a workaround. Uppercase letters are clearly allowed to be used in table names according to MySQL documentation on identifiers. I have a database full of tables that start with capital letters, that has been in use for 3+ years, and phpMyAdmin only recently started to complain with this error message. I suspect this is a problem in phpMyAdmin and not the database itself. – Arbuthnot

It looks like this was a bug that was fixed in version 4.4.4 of phpMyAdmin. – Arbuthnot

Seems it's not completely fixed. That error has disappeared but adding constraints still does not appear if the table contains capital letters. I've just had to change all my tables back to lower case again – Thermonuclear

I see this error in recent version 4.7.4 too. And yes I have column names is mixed case. – Encipher