#1600 Query no longer show after affected message.

[Frédéric NOUVIAN - Noonet]

When you make a update query, the sql is no longer show
in this version( present in previous version)

disp_query is not append to the query.

this is due of the change in tblrepplace in version 2.6.1

265: // I don't understand this one:
// $add_query = (strpos(' ' . $goto,
'tbl_change') ? '&disp_query=' . urlencode($sql_query)
: '');
// if we have seen binary,
// we do not append the query to the Location so it
won't be displayed
// on the resulting page
// Nijel: we also need to limit size of url...
273: $add_query = (!$seen_binary && strlen($sql_query)
< 1024 ? '&disp_query=' . urlencode($sql_query) : '');

I have replace the ligne 273 by

$add_query = (((!$seen_binary && strlen($sql_query) <
1024)|| strpos(' ' . $goto, 'tbl_change')) ?
'&disp_query=' . urlencode($sql_query) : '');

so it will concatenate the two request and show the
query after update if I stay on the same page. That
what I want.

Maybe you will do best code !!!

Thanks for this new version

Fred

[Marc Delisle]

Logged In: YES
user_id=210714

Please tell me the exact steps you do to reproduce this
problem under 2.6.1. When I edit a row and save, the UPDATE
query is shown.

[Frédéric NOUVIAN - Noonet]

Logged In: YES
user_id=1218989

First click on left on a table
click on browse (icon or menu)
click on a row to modify ( icon or checked case + icon)
modifify a value
Click on Go

you go back to the previous page (select) with the previous
select query !! but not with the update query you just made

This is whith radio button ' Go back to previous page' checked.

With 'Go back to this page' th info bar with the number of
affected rows is show but not the query.

look at tblreplace to uncomment line 256

hope it helps you

[Marc Delisle]

Logged In: YES
user_id=210714

I cannot reproduce this bug with phpMyAdmin 2.6.1. I
remember fixing this on an previous version.

If you are sure this happens on 2.6.1, please attach here an
export of your table.

[Marc Delisle]

Logged In: YES
user_id=210714

Moved to support. Please reply. Merci

[Frédéric NOUVIAN - Noonet]

Logged In: YES
user_id=1218989

I'm sure it happens on phpMyAdmin 2.6.1 !!

but you are right, it don't happens on all my tables.
so I send you an export of my table.
It seems to be related the blob (binary) field.

The SQL INSERT QUERY is done BUT it is NOT SHOWN at the
screen and the message of affected rows not even.

Thanks for all

Fred

[Frédéric NOUVIAN - Noonet]

Dump of the Table to reproduce the bug

[Marc Delisle]

Logged In: YES
user_id=210714

Moved to bugs. I can reproduce the problem.
It does not occur if I delete the BLOB column.

[Marc Delisle]

Logged In: YES
user_id=210714

The goal of this segment of code is to avoid displaying some
binary contents (which would probably be meaningless) when
showing the query that was executed.

I think it will stay this way.