[peterlaursen]

And I have had this Virtual Dimension program running now for some hours and did not experience anything like this. So 99.9% it is not related to this program.

“Note that I did not have such problems with several SQLyog versions, up to 5.0 final.” Well .. it could be a coincidence that something happened to your system about at the time when first 5.1 Betas appeared.

Now I'll suggest (it it is not fixed with 5.1 RC2) you work with 5.02/5.03 for some days and see if the problems persists. If the problem now is there with 5.0.2 too, I think you will need to try to do a 'OS repair'. But quite a lot of updates to apply after that .. even if you have a CD with WinXP SP2 (You can 'streamline' a SP2 CD from a SP0 or SP1 CD).

I think that I wrote this before: Did you try renaming the sqlyog.ini file and let the program build a new one from scratch? I have had a strange experience (with wrong fonts being displayed – not a crash) that went away after starting a new SQLyog.ini

[peterlaursen]

FAQ write-up:

http://www.webyog.com/faq/35_104_en.html

[peterlaursen]

hello again …

Crazy problems. In this situation we'll have to be sure that it is not the Virtual Dimension porgram that causes this. Do you have a chance to work without it for a period? I have installed it myself and see if something shows up.

I have 'severals' of such software (most graphics driver utiliies include it), but now I try this one.

I think that I remember that your PC at work has an integrated Intel graphics chip?

[peterlaursen]

this one for instace: http://www.fabforce.net/dbdesigner4/

Mike Zinner who wrote this is now at MySQL where it is working on the 'workbench' program. It is same type an corss-platform (java-based). But still pretty bugge .. check yourself at http://www.mysql.com

[peterlaursen]

Quote:

But the second question indicates that you have a problem that can't be fixed by SQLYog. The problem is you don't have permission to add users. You'll need to speak to your host about that.

That is the point. If it is a server at an ISP, it is very common that they only let you manage users from their web-based Control Panal Application.

[peterlaursen]

You cannot sync 4.x and 5.0. http://www.webyog.com/faq/11_68_en.html

@Ritesh: why does it not find that those versions are incompatible? It should! I have seen that a few times now!

[peterlaursen]

No problem here

A simple table id: integer PK, t varchar(50) 'This is why it's so important`on source and 'This is why it's so important' on target syncs like

Code:

SQLyog Job Agent Version 5.1
Copyright (c) Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Sync started at Tue Apr 11 18:38:08 2006

Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
`a` 1 1 0 1 0

Total time taken – 0 sec(s

)

…and data are OK afte sync.

We fixed an issue with backslashes LONG ago (4.06 or 4.07 – that is a year ago). What is your version?

And could you please desribe more is detail what is the problem you experience?

[peterlaursen]

Yes!

http://www.webyog.com/faq/33_20_en.html

[peterlaursen]

@Ritesh – don't you forget that SJA-SYNC now is supposed to work without a PK?

I agree that Joeck shoul have a PK, but still this should not happen.

Also it is a bug, that you can't export and import again! The export file generated is invalid!

[peterlaursen]

This is confirmed. Also with SQLyog 5.1 beta 6.

You have a PK build on 4 columns of which 2 are DATETIMES. If I create a new PK with only the two other columns there is no error when syncing.

I also note that there is only seconds between the records. If I change them so that there are months or more between them, there is no error. We fixed a similar issue with TIMESTAMPs and DATETIMES in the PK recently.

@Ritesh: has this fix accidently been deactivated?

[peterlaursen]

Code:

I think we are now done with one byte data handling.

1) I think that as long with wont need to display and be able to read and manipulate from GUI data we are done with all data if MySQL is >= 4.1. SET NAMES = utf8 converts data to a stream of bytes that SQLyog/SJA can handle internally. That goes for copy, export/backup, sync etc. But not for display and for keyboard manipulation.

2) But we can also handle all data (even with the GUI – display and keyboard) from multibyte-storage (possibly mixed with single-byte storage) as long as all characters used are convertible to one single byte charset. That is: if data are stored as utf8, ucs2 etc., SET NAMES = latin1/2/5/7 etc will load them into the client in a readable and manipulate-able way as long as this client has support for the Windows parallel for the charset that was specified with SET NAMES – and as long as this SET NAMES makes sense with the data.

But we cannot handle multibyte data where some characters must be converted to different one-byte character set (some latin2 and others to latin5 for instance) to be presented as single-byte. As SQLyog uses one byte internally there is no way to have a Polish l-with-an-accent and a Turkish i-without-a-dot at the same time! Unless there is some strange single byte charset supported by MySQL as well as Windows that has both.

And of course we cannot either handle multibyte characters with the GUI that cannot be represented in a single-byte charset. But we can copy, backup/restore and sync etc if server allows for SET NAMES = utf8.

@ritesh – actually I'd like your comment on whether you agree to this …

[peterlaursen]

hmmm …

I asked you if you were usig HTTP-tunnel? That is important to know! I don't think HTTP-tunnel can handle UCS2-data in all situations as of now. But As I said, I think we can 'hack' the tunnelling file if it is the case.

Also with only about 20 rows of data isn't it possible to dump the data (both) and zip them here?

If you don't want to expose the data in public you can create a 'ticket' and attach it there.

[peterlaursen]

Yeah .. and sometimes my car won't start … could you please tell me the reason? I am using Texaco gasoline 😀 .. Don't you think that you would need a little bit of additional information to help me here?

And so with your problem! Maybe Ritesh could use this “'group by 1 order by 2'” (but I doubt, because the error in the internal SQL is probably just before that) .. but we simply need a description of the DATA. From what sort of system do the data come? Are there any 'weird' binary data or encoded data?

Could you post 'Create staement for the tables' and preferably a small set of data from source and target to reproduce the error. And the job(XML)file. If it is data you don't want to have exposed here, then create a ticket in the webbased support system.

As you are able to use SJA for Linux, I must suppose that you use direct connection,

There is of course no limitation with 16 tables or the like!

The only thing we can tell from the information that you give is that SJA internally in your situation (with your data and server setup's) generates some SQL that is invalid in the situation.

[peterlaursen]

let me point your attention to this:

http://bugs.mysql.com/bug.php?id=18891

Read the link to the PHP docs. You can enter '127.0.0.1' and TCP connection (and no socket file) is used; if you enter 'localhost' PHP connects through socket.

I don't think this is an issue for SQLyog/SJA to decide where PHP should look for the socket. Don't think it is possible either. This is a system configuration issue on the remote host.

[peterlaursen]

The SQL 'UNION' clause is for this.

Code:

CREATE TABLE new_table SELECT * from old_table1 UNION SELECT * from old_table2;

Note that if you have an autoincrement PK in old_tables the new table will not have a PK. You must then add it using ALTER TABLE. If there are dublicates you may need to drop the PK-column and recreate it.

[Author]

Posts