[Phpmyadmin-devel] Two big bugs

[Steve Alberty]

Hi,

i've found another _new_ bug:
type:
"show table status from aTable"

this results a lot of warnings plus
Can't read dir of './aTable/' (Errcode: 2)

The Problem is in line 79 in sql.php3.

Loic, can you look also about this problem?

--
Steve

> -----Original Message-----
> From: phpmyadmin-devel-admin at lists.sourceforge.net
> [mailto:phpmyadmin-devel-admin at lists.sourceforge.net]On Behalf Of Loïc
> Sent: Friday, July 13, 2001 1:09 AM
> To: phpMyAdmin
> Subject: [Phpmyadmin-devel] Two big bugs
>
>
> Hi All!
>
> Here are two really annoying bugs I've been reported:
>
> 1. select * from aTable where afield <123
>     select * from aTable where afield like "arg"
>
> Before these kind of queries are submitted to MySQL, the
> 'htmlspecialchars'
> function is applied on them (db_readdump.php3, line 62). Then the '<' and
> '"'
> characters are replaced by their html entities and, of course, MySQL fails
> to run the transformed query.
>
> The question is: does anyone of you knows why the 'htmlspecialchars'
> funtion is applied at this stage? I've just tried to comment this line and
> can't
> face any problem!
>
> 2. select * from link LIMIT 1,5
>
> This kind of query always fails because of an invalid derived
> query at lines
> 82-94 in sql.php3
>
>
> Greets,
> Loïc
>
>
> __________________________________________________________________
> ____________
> ifrance.com, l'email gratuit le plus complet de l'Internet !
> vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP...
> http://www.ifrance.com/_reloc/email.emailif
>
>
>
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> http://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>