#2236 (ok 2.10) SQL History does not work

[ZakMc]

I want to use the SQL history function.
In firefox 1.5.0.6, IE 6 sp2 an IE 7 the following
error is displayed:

Fehler: missing ; before statement
Quelldatei: http://phpmyadmin.domain.de/querywindow.php
Zeile: 1, Spalte: 203
Quelltext:
document.getElementById('hiddenqueryform').querydisplay_tab.value
= 'sql';
document.getElementById('hiddenqueryform').query_history_latest.value
= 'SELECT * FROM `address` WHERE `street` = ''';

It seems the query is not escape the "'".

[Marc Delisle]

Logged In: YES
user_id=210714

Please show us your original query.

Also, what is the value of your $cfg['QueryHistoryDB']?

[ZakMc]

Logged In: YES
user_id=1587731

My original query was:

SELECT * FROM `address` WHERE street = ''

$cfg['QueryHistoryDB'] = true;
$cfg['QueryHistoryMax'] = 25;

[Marc Delisle]

Logged In: YES
user_id=210714

Ok, I see, the problem is when you recall a query that was
stored. I thought it was when you are storing the query.

[ZakMc]

Logged In: YES
user_id=1587731

What should i do now?
I want to use the history function. It is very usefull for me.

I removed all data from pma_history and try this query

SELECT * FROM `referer` WHERE `urltarget` = '/'

pma_history has one record now. The query is stored fine for
me. When i click on this query in the history-tab and error
is display: "NaN"
NaN is also stored in the pma_history table

I dont know what i must do now

[Marc Delisle]

Logged In: YES
user_id=210714

Please wait until we fix this bug.

[Marc Delisle]

Logged In: YES
user_id=210714

Fixed for 2.10.