[peterlaursen]

I can't wait 😀

[peterlaursen]

confirmed fixed with the latest RC3 build!

[peterlaursen]

Quote:

BTW, do you chat on MSN or Yahoo Messenger?

I use the Qnext p2p-software (www.qnext.com) when I need such thing. I don't trust the other messengers and they won't ever get on my machine! But Qnext should be compatible to the various MS-Messengers. Actually it has worked before. It is running now.

I'll PM you my MSN-user ID.

You can PM my yours …

[peterlaursen]

No .. it is not!

You can read this mess here 🙂

http://www.webyog.com/forums/index.php?act…f=6&t=1500&st=0

and you probably will understand that RItesh want to be perfectly sure that my problems with the sync feature are not an issue with SQLyog and SJA but are instead caused by corrupt data or MySQL installation with me.

The want to build a 4.07 FINAL “solid as rock” and then integrate the 4.1 features into that code. I believe that when 4.07 FINAL is out it will only be a few days to build 4.1 BETA.

[peterlaursen]

Quote:

You have a PM

I know! PM (Peter Madsen) is a chess-player at the local chess-club just as I. I know him very well! 😛

[peterlaursen]

Quote:

I am waiting for your dump

what are you waiting for ? I thought I gave you all you asked !?

[peterlaursen]

BTW:

I had your first mail this afternoon ( danish time 13:11 )

it is sent yesterday 17:27 (I believe that's Danish Time, too – mail systems should be smart enough to convert time zones).

It is a problem with some mail server on your side, I believe. It also happens often with notifications from the Forums. First I had suspected that it was my gmail – but they assure me that though it is not as fast as a normal POP3 account, delay would very rarely be more than a few minutes.

[peterlaursen]

Just for your information:

Now I have the most terrible problems sync'ing with target on lacalhost. In one case SJA inserted 500 lines of garbage into the base before it crashed.

One-way sync from localhost to webhost still works … at least from commandline or from GUI when file not saved …

Actually I'm in doubt about how much of the problems are new …

[peterlaursen]

does not work (not on command-line either)

Code:

localhost
****** ******* 3306 musik

http://deepeter.dyndns.dk/SQLyogTunnel.php
30000

localhost
******* ******* 3306 test

`mp3_filer`
`Kunstner`

works

Code:

localhost
********* ********* 3306 musik

http://deepeter.dyndns.dk/SQLyogTunnel.php
-64771

localhost
******** ******** 3306 test

`mp3_filer`
`Kunstner` kunstner like '%'

how comes different timeouts ?

BTW: I remember an old thread in the Forums where some user had to specify a 'dump' SQL_where to get option work

I got to stop now! should have been 45 minutes – became 3 hours ….

[peterlaursen]

I found out that this

Quote:

Sync started at Tue Jul 05 13:23:28 2005

Table                      SrcRows  TgtRows  Inserted  Updated  Deleted

=========================  =======  =======  ========  =======  =======

`mp3_filer`                  38499    38499         0        0

Total time taken – 2 sec(s)

happens when this

Code:

http://www.yourdomain.com/SQLyogTunnel.php

is executed!

please note that http://www.yourdomain.com exists!

[peterlaursen]

Did a complete reinstall. No change

I have been able to produce these crazy XML-files

Code:

localhost
****** ******* 3306 musik

http://www.yourdomain.com/SQLyogTunnel.php
30

localhost
****** ****** 3306 test

`mp3_filer`
`Kunstne`

In this case I chose a connection that works – and it writes http://www.yourdomain.com/SQLyogTunnel.php

Code:

localhost
********* ********* 3306 musik

http://deepeter.dyndns.dk/SQLyogTunnel.php
30

localhost
******* ******* 3306 test

`mp3_filer`

(In this latter case I REALLY selected a column!)

I might have been stepping frward and backward in the GUI … remember that produced the ´´´´´-bug too!

[peterlaursen]

I removed attachment again (forgot to hide connection details to my webserver admin account) 🙁

[peterlaursen]

the ALTER TABLE from VARCHAR to CHAR can't be reproduced with tunnelling on my local machine.

So it must without doubt be a server issue.

But anyway – they may store it on disk as they like!

[peterlaursen]

Quote:

RC3 works as it should with these data.

to put it clear: from command-line only, not from GUI!

[peterlaursen]

A very crazy thing happens:

I can't change a varchar(25) to a char(25) on my webhost:

HISTORY says:

alter table `jazcyk_guestbook`.`mp3_filer` ,change `Guid` `Guid` char (25) NOT NULL

and msgbox “Alter table successfull* appears.

But type does not change (or it is changed back)! It probably is a server issue and not a SQLyog issue. But it never was like that before. Maybe my webhosting company can't spare the money for a new harddisk ? 😮

[Author]

Posts