[peterlaursen]

“In the source database the character “é” is stored as “é” but yet still output as “é”.”

How can you tell that it is stored like that and it is not only a client displaying like that?

I think there might be two errors here.  “é” might not be encoded correctly when sent to the server (and thus not stored correctly), but the error is 'reversed' when you retrive data again.  But of course data shold be stored correctly.  Because if it is not it might work with one client but not others (including website scripts).

Basically please consider upgrading to SQLyog 6.0.  We cannot be responsible for any 'client side encoding' done by PHP.  We will not support issues with 5.02 anymore eitehr.  You can try 6.0 RC (even ENTERPRISE) for free. Just install to the same system as 5.02.

If you still use MySQL 4.1.12 you should also consider upgrading the server!

I think that this post is now so old and the involved software versions are so old too, that I must request a fresh report with recent software version!

[peterlaursen]

thanks for your feedback.

however we will concentrate on releasing 6.0 FINAL before considering the display.

personally i always thought that HISTORY should display execution time for each individual statement, but what MESSAGES and STATUS line should display is open to me.

[peterlaursen]

OK .. confirmed to be a GRID related bug in SQLyog. If you 'show results in text' it displays correctly!

We will work on that NOW!

[peterlaursen]

here comes the images

[peterlaursen]

I am sorry, but it seems that we forgot this one.

One thing that surprises me is that you create the table like '..DEFAULT CHARSET=latin1'. I do not understand how this is unicode related then? please explain!

Also please see 1st attached image. Ii am not even able to insert that long string without 'ööö' becoming garbled in the display. And that no matter if table charset is latin1 or utf8. Sever is 5.0.41 (i do not have 4.1.x here).

2nd attached image. Depending on the length of the substring it will garble! We will have to find out now if SQlyog garbles or MySQL does!

Thanks for persistency!

[peterlaursen]

why not ….. ??

well we actually asked users what they wanted (I think) about 9 monts ago!

Now what would YOU think would be teh most unambigious and useful way to display the information?

[peterlaursen]

It is not a bug really.

Please refer to:

http://webyog.com/faq/8_147_en.html

HISTORY displayss the closest we can come to 'server execution time'. MESSAGES as close as we can come to 'time for transmission of data'.  On localhost it will have to be a very big result if it shall not be 0 (zero).

If you experience behaviour different from what is explained here, then please detail, because then it may be a bug!

[peterlaursen]

SJA is running from command line – that is why the command line pops up.

However if the job runs with another user as the user that is currently logged on, it will not show!

From Windows 'control panel .. scheduled jobs' you can change the user that executes the job.  

You may use a system user like 'NT AUTHORITYSYSTEM' for instance.

[peterlaursen]

Now you do not tell the Wine version.

Also the folder name is SQLyog41. why not use a recent version (if you don't)-

SQLyog ships with some Windows dll's. gidplus.dll is one. it iis need only on old Windows versions and Wine.

If the dll's are not copied during the install the program won't start. It will normally be sufficient to use the 'winecfg' program to let Wine emulate Windows 98 during the installation. Then the installer will 'think' that this is w98 an copy the dll's.

the FAQ explains this actually!Did you try that?

Also note that if fonts display badly then you might need to install the windows core fonts package in wine (not in Linux!). That depends on wine version and Linux distro!

[peterlaursen]

You won't be abale to build SQLyog on Linux. Though C/C++ is available on Win and Lin SQLyog uses WIN32 API calls/functions.

To run SQLyog on Linux you should run it in Wine. Refer to:

http://webyog.com/faq/31_71_en.html

[peterlaursen]

We cannot reproduce.  Not on this server (webyog.com) and not locally installed servers either.  We tried to have a SSH connection idle for up to 30 minutes.  When we after that do some operation from the GUI, the expected behaviour comes promptly.

Ther must be some time-out taking place on the server, so that the connection thread gets disabled.  it is very unlikely that this is MySQL that does this (normally MySQL only closes connection threads after several hours – but neverthelesss you should check this setting).  More likely it is a SSH (configuration) issue on the server.  Do you have an option to check this?

There is no 'keep-alive' command like FTP 'NOOP' in SQL.  Actually with SSH and direct connection we do nothing when the connection is idle (with HTTP connection 'keep-alive' packets are sent however, but that is totally controlled by the webserver itself!) an there should be no reason to do it.

One more question: is this happening with 6.0 beta only and not 5.x ?

We can try to reproduce the issue when connected to your server.  You will have to arrange temporary remote access then.  We do not need access to any data.  Just create an empty database and a MySQL user having all privileges to that database only.  Also you can create a new SSH/OS user for this so that we cannot access system files and files belonging to other users.

If you want us to try this, you can create a ticket with the necessary connetion details

[peterlaursen]

My first thought was that this is basically how a GUI editor is supposed to work!

a SPACE, a TAB or a NEWLINE (or hundreds of them!) are considered totally having the same meaning!

If there is more than one only the first is kept and the rest are stripped away –  SPACES, TABS and NEWLINES are considered a matter of SQL code formatting for the display only.

But well . . you got a point: inside a quoted string it should not do like this!   So I will agree that this is a bug! As we accept one linebreak inside the quoted string we should accept all of them (as we do accept multiple TABS and multiple SPACES inside a quoted string and do not strip any of those)

The workaround is to add an additional 'newline' as a C-style escape sequence “n” like

Code:

drop table if exists test;

create table test (
id int not null auto_increment primary key,
some text not null
) engine = InnoDB;

insert into test (some) values ('

one newline character:
two newline characters:n

end of story

');

select *
from test;

etc.

and of course this

Code:

one newline character:
two newline characters:n

end of story

and this

Code:

one newline character:
two newline characters:n
end of story

would be exactly the same!

But basically I would avoid using visual linebreaks in the quoted string itself but do like:

Code:

insert into test (some)
values ('one newline character:ntwo newline characters:nnend of story');

.. because that would work with any client – whether a graphical client as SQlyog or a commandline or a script/an application! In a similar way I would write “t” instead of a visual TAB.

Actually there could be a platform related issue too.  On Linux 'newline' is plain “n” (or ins ASCII/ANSI terminologi) – on windows it is “rn” ().  Typing/sending the escape sequences instead of relying on the visual display in sosme 'accidential program' is the safe way.  

So it could also be

Code:

insert into test (some)
values ('one newline character:rntwo newline characters:rnrnend of story');

. and this one I think I would actually prefer as not all Windows programs understand the unix/linux way of doing things.  One program that does not is Notepad!  I have not come across any *nix program having problems with display of Windows text!

[peterlaursen]

To me it looks like this Mango system and MySQL did not get installed correctly.

I would remove it and start from scratch.

I do not know the system but I know that other users are using SQLyog with it.

[peterlaursen]

Ok the error messages in the error log were not related!

does the game script(s) connect OK?

can you connect with other clients (command line, mySQL administrator)?

do you know if MySQL as shipped with Mango runs as a service?

can you stop and start the service from Windows service manager or command line (net start servicename/net stop servicename) ?

It looks like the system does not realize that a server is listening on port 3306!

But weird that you reported that you connected once!

[peterlaursen]

that sorted out one issue at least.  the error messages were not related to this connection issue.  probably you imported some script when you set up this game server?

Can't conenct to localhost.  That is pretty strange.

Please try some other client program, for instance

*mysql command lien client if it ships with this system (check the bin folder under the mysql server folder for the file 'mysql.exe'.  Start it from comman line like “mysql -uuser -p”.  Substitute user for the name of an existing user (= 'mango' ??)

* MySQL adminsistrator from http://dev.mysql.com –   Connection screen is much similar to SQLyog.

But this is a connection problem – not an authentication problem.  It is not user and password details that are wrong.  But the  system does not seem to realise that there is a server listening on port 3306!

Does the game script(s) connect OK?

Do you know if MySQL runs as a service when installed with mango?  And do you know the service name (check control panel .. administrative tools .. services)?  If it is running as a service try command line commands “net start mysql” and “net stop mysql” (substitute the service name with 'mysql' if it is different) You may also stop and start the service from Windows service manager itself.

the most weird thing is that you told that once you were able to connect!

[Author]

Posts