#2191 (ok 2.9.2) "Edit next row" and mysqli

[Marc Delisle]

When using the "Edit next row" dropdown for sequential
editing of the next PK, with mysqli I get

SHOW TABLE STATUS LIKE 'tablename';

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

Works correctly with mysql extension.

[Jürgen Wind]

Logged In: YES
user_id=1383652

i 'd like to test this (not documented) feature.
if i insert some test rows (mysql connection type)
dropdown "insert new row" go works fine.
when try and edit the 1st row , dropdown choices are:
go back to prev.
INSERT onother row
go back to this page.

"insert" is misleading, as i am going to change something.

"go back to this page" ->go
gives:
----
Affected rows: 1
SQL query: UPDATE `db1__a` SET `f1` = 'test-edited' WHERE
CONVERT( `db1__a`.`f1` USING utf8 ) = 'test' LIMIT 1 ;

[ snip menu ]

MySQL returned an empty result set (i.e. zero rows).
SQL query: SELECT *
FROM `db1__a`
WHERE CONVERT( `db1__a`.`f1`
USING utf8 ) = 'test';
----
should not be displayed, as i edited the row
(or the option should not have been given)

switching to PK asc did not make it better

plz tell me the steps to do
what you described

[Marc Delisle]

Logged In: YES
user_id=210714

To see the Edit next row, use a table with a PK on a field
of type INT.

[Jürgen Wind]

Logged In: YES
user_id=1383652

i added an INT PK, sorted by PK asc, clicked on edit/change
1st row, but still got dropdown choices:

go back to prev.
INSERT (???) another row
go back to this page.

---
BTW.
why says the "in row" tooltip "edit"
but at the bottom of the list "change"
when i hoover [/] (pencil)

[Jürgen Wind]

Logged In: YES
user_id=1383652

sorry ,
i overlooked group 282,
take it as a bug report for HEAD ;)

in 282 i DO get a fourth option "edit next row"
(but same err like u with ext. mysqli)

[Marc Delisle]

Logged In: YES
user_id=210714

You uncovered _another_ bug: this feature was deactivated in
HEAD. I just fixed this other bug: now at least you can see
the feature.

To reproduce, with mysqli, make a change to the current row,
and try to "Save and then Edit next row".

[Sebastian Mendel]

Logged In: YES
user_id=326580
Originator: NO

so there was a reason it was disabled, ;-)

also bug #1680952 Call to undefined function PMA_getUvaCondition()

would not appear if it would still be disabled ...

[Marc Delisle]

Logged In: YES
user_id=210714
Originator: YES

The feature works in 2.9.2 (with mysql or mysqli extension).