Minor Bug: Tab Chars In Error Message

[larsen]

Hello,

I wanted to restore a SQL dump and got an error message with tab chars in it (I used square brackets here):

“…a query. [] The query…”

SQLyog 6.0 beta4, windows XP sp2

Lars

[peterlaursen]

Do I understand you right that those “tab chars” display as 'empty squares' ??

[larsen]

Yes.

[peterlaursen]

can you gvie a smal dump to reproduce with?

Also please inform about the server version!

[larsen]

Same dump as in the other thread. Basically, you can use any dump and then restore it on the tree root.

5.0.19-nt

Seems to be caused by this:

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

[peterlaursen]

OK .. i have an idea.

Try open the lqlyog.err file in Notepad.  What encoding is proposed by Windows?  ANSI, UTF8 or something else?

I do not get such squares. with your file

[larsen]

peterlaursen wrote on May 8 2007, 02:40 PM:

Try open the lqlyog.err file in Notepad.  What encoding is proposed by Windows?  ANSI, UTF8 or something else?

Do you really mean sqlyog.err or do you mean the sql file?

sqlyog.err must be ansi or utf-8. unicode doesn´t work. I can only select an encoding, it isn´t proposed automatically.

Is this what you meant?

[peterlaursen]

I mean the sqlyog.err file.  This is the SQLyog error log.  Error messages dispalyed on the screen are read form this file!

I there is nothing confidential can you copy, zip and attach the sqlyog.err file?

You may also tell if SQLyog 6.0 was installed on top of an older version.

And finally it would be nice if you could make a screenshot of that error message with such square, so taht we can see exactly what it looks like (as we never saw ourselves!)

[larsen]

peterlaursen wrote on May 8 2007, 03:10 PM:

I mean the sqlyog.err file.  This is the SQLyog error log.  Error messages dispalyed on the screen are read form this file!

Ah, ok. I thought they were copied to this file afterwards/parallel.

Quote:

I there is nothing confidential can you copy, zip and attach the sqlyog.err file?

attached

Quote:

You may also tell if SQLyog 6.0 was installed on top of an older version.

afair, yes. I installed over v5 and one or two 6 betas.

Quote:

And finally it would be nice if you could make a screenshot of that error message with such square, so taht we can see exactly what it looks like (as we never saw ourselves!)

attached

[larsen]

btw: I will be unavailable till Thursday. Hope you have enough information.

Have a nice day,

Lars

[peterlaursen]

once you get back, plese try to rename the sqlyog.err file.  Next start SQlyog and send an invalid query.  Then a new .err file will be created!

[larsen]

here it is.

[adarsh]

Hello,

Issue is confirmed we will fix this in next release.

Thanks

Adarsh

[larsen]

Thx!

[Author]

Posts