Problem with Execute query...

[rbtux]

Hi there...

I ran into a problem with the execute query function of manage sql screen...

querys like:

Quote:/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

do not work... Can somebody confirm that?

[joximu]

Seems so - i tried this:

/*!40101 SET NAMES utf8; */
SHOW TABLES FROM 3_xxx

threw an error, without the first line it went smoothly...

Could you create a RC4-Ticket?

/J

[rbtux]

... done

[joximu]

Hi rbtux

as RatS already mentioned... this seems to be a problem.
You can try to run your query with the php command "mysql_query" - you won't succeed.. and since the adoDB does nothing else the comment's won't be executed.

PMA does it better - it analyzes the query and runs it step by step (very complex).

So I'd say I close the ticket - we cannot solve this.

/Joximu

[rbtux]

kk... no problem.

I will disable the function in the gui (I don't like things that don't work in the gui... The client is not interesseted in WHY that don't work! He only recognize THAT it don't work..)