+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: Problem with Execute query... (/thread-1907.html)
Problem with Execute query... - rbtux - 12-01-2007 02:05 AM
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?
RE: Problem with Execute query... - joximu - 12-01-2007 06:30 AM
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
RE: Problem with Execute query... - rbtux - 12-01-2007 07:44 AM
... done
RE: Problem with Execute query... - joximu - 12-03-2007 03:49 AM
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
RE: Problem with Execute query... - rbtux - 12-03-2007 03:52 AM
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..)