[Phpmyadmin-devel] RE: privileges and underscore

[Marc Delisle]

Alexander,
in version 2.4.0, I would get this output from the pretty parser
showing the UPDATE statement:

UPDATE `marc` SET `c1` = 'L\'amie\'' WHERE `c1` = 'L\'amie' LIMIT 1

and this, for the following SELECT:
SELECT *
FROM `marc`

In current 2.4.1-dev, I get this:
UPDATE `marc` SET `c1` = 'L'amie'' WHERE `c1` = 'L'amie' LIMIT 1;
with no pretty colors.  Note the unescaped quotes.

And then, calling again the parser in common.lib.php3 line 1297,
makes the parser choke. $GLOBALS['SQP_errorString'] contains
the error message for unbalanced quote, but the error message
is not shown, instead Array Array is displayed.

Marc

What happens is that

Rabus wrote:

> Hi Marc & list,
> 
> -----Original Message-----
> From: Marc Delisle [mailto:delislma at CollegeSherbrooke.qc.ca]
> 
>>Rabus wrote:
>>
>>
>>>Hi Marc & list,
>>>
>>>-----Original Message-----
>>>From: Marc Delisle [mailto:DelislMa at CollegeSherbrooke.qc.ca]
>>>
>>>>Now trying to edit the newly inserted row containing a
>>>>quote, in the "showing rows" box I get Array Array.
>>>>
>>>>
>>>I cannot reproduce this issue. Editing rows works fine here, with
>>>magic_quotes_gpc as well as without.
>>>
>>Reproduceable on our demo at phpmyadmin.net, see table "marc".
>>
>>
> 
> I exported your table, tried it on my machine and got the same error
> here.
> 
> I noticed that, in the first box, the pretty-printer appears to be
> deaktivated automatically somehow.
> It seems as if the query of the second box has been parsed (the parser
> returns an array with the tokenized query), but hasn't been passed to
> the pretty-printer afterwards.
> 
> Robin, since you know your code better than me, could you help me with
> that? I don't want to break more than I already have...
> 
> Regards,
> 
> Alexander M. Turek
> <alex at bugfixes.info>
> 
> +-----------------------------+
> | The phpMyAdmin Project      |
> | http://www.phpmyadmin.net   |
> | rabus at users.sourceforge.net |
> +-----------------------------+
> | [bugfixes.info]             |
> | http://www.bugfixes.info    |
> | rabus at bugfixes.info         |
> +-----------------------------+
> 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Etnus, makers of TotalView, The debugger 
> for complex code. Debugging C/C++ programs can leave you feeling lost and 
> disoriented. TotalView can help you find your way. Available on major UNIX 
> and Linux platforms. Try it free. www.etnus.com
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
> 
>