[larsen]

Quote:

Well .. your are correct in the sense that the column `data` displays 'binary'. For me it does in both SQLyog 7.15 and 8.03. I did not get the point when you referred to 7.5 RC's.

I didn´t test it with 7.x as I now only have 8.03 installed, but I remember that there was a separate viewing window. Most certain the blob viewer you mentioned.

Quote:

If you open the dump in an editor (like Notepad) you will see the column dumped as 'ANnANR300100 0rn'. This looks very much like binary data! Can you explain what you would expect instead? And if you observed different behaviour with different SQLyog versions (with *exactly* those data) please also explain/detail this!

Well, I expect binary data. The field is varchar cause the machines from which that data comes used ASCII in an earlier version of their interface. Perhaps I should change the field type. I´m just in the process of adapting the code to the new interface that sends binary data.

Quote:

It is a long-standing request however that the Blob Viewer should have an option to open (and edit) such data in HEX-view. This is the only solution I can see for such data!

I don´t need to change the data. I just think, that SQLyog shouldn´t tamper it, when I doubleclick on it.

Quote:

BTW: What application stored those data?

It´s from an x-ray machine that is used in the food industry =)

Lars

[larsen]

SQL dump attached.

[larsen]

peterlaursen wrote on Nov 18 2008, 08:12 PM:

“Although, SQLyog freezes and doesn´t respond anymore.” .. well the connection window will wait for server response *and this is the only thing it does*. You will not be able to get any kind of response from it. But complete program should not freeeze. Do you have two connection windows in one program instance or two program instances?

First one, two windows in one instance.

Quote:

I can confirm there is some issue with thread isolation, though. I have two connection windows in one program instance. From one I execute “lock table t1 write”. From the other connection I do some operation like trying to display the data for the table. SQLyog displays active cursor (it is waiting because table was locked for WRITE, so READ is not possible for other clients – and every connection window is a client here!). Now comes the point: It continues to do if I click on 1st connection window. SQLyog is in a state where it does not accept input! However the simple workaround is to click on the title bar of some other program and now you can click on connection window no. 1 in SQLyog and execute 'unlock tables' — and the operation in 2nd window will continue.

I don´t know if that´s the same problem I experienced, too. Sometimes, one window would grey out all databases and tables which weren´t re-enabled after execution. Therefore, I couldn´t change db oder tables in this connection. Though, the other one was fine.

Lars

[larsen]

crap, wrong forum 🙂

please move it to the appropriate SQLyog forum, thx.

[larsen]

peterlaursen wrote on Dec 12 2007, 12:32 PM:

please detail this “btw: the “Topic Subscription Reply Notification” seems to be missing line breaks.”

Here is the mail I just received:

larsen, peterlaursen has just posted a reply to a topic that you have subscribed to titled “Feature Request: Auto Name For Sql Dump”.

---

please detail this “btw: the “Topic Subscription Reply Notification” seems to be missing line breaks.”

---

The topic can be found here: http://www.webyog.com/forums//index.php?sh…view=getnewpost If you have configured in your control panel to receive immediate topic reply notifications, you may receive an email for each reply made to this topic. Otherwise, only 1 email is sent per board visit for each subscribed topic. This is to limit the amount of mail that is sent to your inbox. Unsubscribing:

---

You can unsubscribe at any time by logging into your control panel and clicking on the “View Topics” link. Regards, The Webyog Forums team. http://www.webyog.com/forums//index.php

[larsen]

would the database name be displayed in the export dialog? i´d prefer this.

another idea would be variables like {DB_NAME}.

“database_.sql”

doesn´t look good. “_” should be removed in that case.

btw: the “Topic Subscription Reply Notification” seems to be missing line breaks.

[larsen]

anything new to a “check for update”? would be nice

[larsen]

adarsh wrote on May 11 2007, 12:20 PM:

Hello,

Which version of SQLyog are you using.

Adarsh

6.0 beta 4

[larsen]

Thx!

[larsen]

here it is.

[larsen]

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

Have a nice day,

Lars

[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]

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?

[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=''*/;

[larsen]

Please see the attached sql dump and make a right click on the tree root in SQLyog to import it.

There is a USE statement.

If you import it through clicking on an already existing DB it works and creates the stated DB not the one you clicked on.

[Author]

Posts