#1716 (in 2.6.3-pl1) 'Commands out of sync' (with mysqli)

[mpopp75]

I've just installed phpMyAdmin 2.6.3. When I access any
table, I get the error message

SQL-Befehl: [Bearbeiten]

SHOW KEYS FROM `tablename` ;

MySQL meldet:
#2014 - Commands out of sync; you can't run this
command now

I'm using MySQL 4.1.12-nt on Windows XP SP 1 - but it
must be caused by the new pma release. All versions of
pma that I've used before didn't bring that error.

[Marc Delisle]

Logged In: YES
user_id=210714

Happens with 2.6.3 and not with 2.6.3-rc1.
Only with the mysqli extension.

[mpopp75]

Logged In: YES
user_id=1198806

The bug must have arisen very recently. I had even one of the
latest CVS versions before 2.6.3 final installed, but there was
no error until the final.

Markus Popp

[Marc Delisle]

Logged In: YES
user_id=210714

Here is the fix that will go into 2.6.3-pl1:
line 30 in tbl_properties_table_info.php becomes:

$table_info_result = PMA_DBI_query('SHOW TABLE STATUS LIKE
\'' . PMA_sqlAddslashes($table, TRUE) . '\';', NULL,
PMA_DBI_QUERY_STORE);

[Marc Delisle]

Logged In: YES
user_id=210714

fixed in 2.6.3-pl1