[Mahesh]

HI,

Please attach ,

1) Job file

2) Sample table structure and sample data on both source and target where it is reproducible.

3) Also tell MySQL server version for source and target?

Also please go through link given below which will tell you how to use data sync operation effectively.

http://www.webyog.com//en/whitepapers/Usin…L_Databases.pdf

[Mahesh]

Agreed.

[Mahesh]

HI,

This is known issue , selection of 10 to nth result tab there is no keyboard shortcut.

Also you can see there is an underline of every first digit of a result tab, so ALT+1 will point to 1st result tab.

Thanks,

Mahesh

[Mahesh]

HI,

We have fixed this issue in this special build v 7.12 ( not released).

To Download,

Community Version

http://www.webyog.com/downloads/betas/not_…SQLyog712n2.exe

Enterprise Trial Version

http://www.webyog.com/downloads/betas/not_…2n2EntTrial.exe

Enterprise Version

http://www.webyog.com/downloads/betas/not_…yog712n2Ent.exe

Please verify and let us know the status.

Thanks,

Mahesh

[Mahesh]

Hi,

We have checked the crash dump, it shows issue with the internal code. We give high priority to solve this.

Can you confirm that program is not crashing after renaming “SQLyog.ini” file?

We have prepared a special build identical to 7.11 except that it will do additional logging to a textfile 'Importlog.log'

that logs some c++ pointer values.

To Download,

http://www.webyog.com/downloads/betas/not_…Lyog711nlog.exe

Try to repeat the crash with this build and attach the log file here.

This file will be created at:

C:Documents and SettingsApplication DataSQLyog — for XP

C:UsersAppDataRoamingSQLyog — For Vista

Also please tell,

1) MySQL version?

2) Have you waited long time before it crashed.

3) Have you faced this issue even before also.

Thanks,

Mahesh

[Mahesh]

Quote:

CREATE TABLE `contact_bills` (

`BillId` decimal(15,2) NOT NULL default '1.00',

`Monthno` int(10) unsigned default NULL,

`yearno` int(10) unsigned default NULL,

`CustId` int(10) unsigned default '0',

`AE_Kwh` decimal(10,4) default '0.0000',

`AE_cents` decimal(10,4) default '0.0000',

`AE_n_Kwh` decimal(10,4) default '0.0000',

`AE_n_Cents` decimal(10,4) default '0.0000',

`DN_d_Kwh` decimal(10,4) default '0.0000',

`DN_d_cents` decimal(10,4) default '0.0000',

`DN_n_Kwh` decimal(10,4) default '0.0000',

`DN_n_cents` decimal(10,4) default '0.0000',

`DC_days` decimal(10,4) default '0.0000',

`DC_cents` decimal(10,4) default '0.0000',

`EC_cents` decimal(10,4) default '0.0000',

`AvgType` varchar(45) default NULL,

`Elecpow` varchar(45) default NULL,

`Time_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,

`UserID` int(10) unsigned default NULL,

`FirstLast` tinyint(4) default NULL,

`Promptdisc` decimal(10,4) default '0.0000',

PRIMARY KEY (`BillId`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

We have created a table like this and source rows are as below,

Quote:

1 st row

“81020122750.14”,”1″,”2008″,”3344″,”35922.0000″,”19.5580″,”31200.0000″,”19.5580″,”73019.0000″,”14.8020″,”500012.0000″,”11.7710″,”1.0000″,”9.7000″,”0.1670″,”Electricity bills”,”Contact Energy”,”2008-10-22 10:57:34″,”14″,”-1″,”0.0000″

2nd row

“81020122937.14”,”12″,”2008″,”3344″,”43643.0000″,”19.5580″,”10133.0000″,”19.5580″,”76359.0000″,”14.8020″,”53845.0000″,”11.7710″,”1.0000″,”9.7000″,”0.1670″,”Electricity bills”,”Contact Energy”,”2008-10-22 11:13:48″,”14″,”-1″,”0.0000″

and target row is as ,

Quote:

“81020122750.14”,”1″,”2008″,”3344″,”35922.0000″,”19.5580″,”31200.0000″,”19.5580″,”73019.0000″,”14.8020″,”500012.0000″,”11.7710″,”1.0000″,”9.7000″,”0.1670″,”Electricity bills”,”Contact Energy”,”2008-10-22 10:57:34″,”14″,”-1″,”0.0000″

After syncing it shows 1 rows inserted , we are still not able to reproduce this.

Can you attach a sample data for both source and target where sync result are improper ?

Also , please go through this link

http://dev.mysql.com/doc/refman/5.0/en/pro…with-float.html

Floating point numbers are not stored as exactly what is seen , it will be stored as a approx value.

This is one of the probability of getting such weird results in data sync operation.

@ Error no 1064.

Created a table on source and target as ,

Quote:

CREATE TABLE `contact_notes` (

`NoteId` decimal(15,2) unsigned NOT NULL,

`Id` int(10) unsigned default NULL,

`Notedate` datetime default NULL,

`UserID` int(10) default NULL,

`Note` longtext,

`time_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP,

`statusId` int(10) unsigned default NULL,

`FUdate` datetime default NULL,

`AdminFU` int(11) default NULL,

`FUPriority` varchar(45) default NULL,

PRIMARY KEY (`NoteId`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

Added rows on source and target such that source will update on target as below,

Quote:

Used Generate script option

UPDATE `contact_notes` SET `Id`='3125', `Notedate`='2008-10-19 00:00:00', `UserID`='13', `Note`='Interested in BIG package Ethos fire, 24L HP (floor or ceiling) Insulation upgrade and house-lot of mini downlights plus underfloor insulation. Gave approx prices but mentioned we would do a good deal on a package this size – he will contact us when he's had time to think what items he wants. He plans to get the u/f done first and should put the HP in at this time while he has access to the u/f.', `time_stamp`='2008-10-20 01:16:12', `statusId`='9', `FUdate`='2008-10-23 00:00:00', `AdminFU`='-1', `FUPriority`='1-Very Interested' WHERE (`NoteId` = '81019162834.13') ;

And it executed successfully,

For this table too please attach a sample data for both source and target where you are getting Error 1064 error?

[Mahesh]

HI,

Please provide a table structure with some sample data ( for both source and target) where it is reproducible, you can create a ticket if you want a privacy from here,

http://webyog.com/support/

[Mahesh]

Hi,

1) You mentioned that using ubuntu it is working without any problems , can you tell what is the wine version there ?

2) Also, wine v 1.1.5 is not a stable version,can you try with wine v 1.0.1 which is stable one ?

[Mahesh]

We are not able to reproduce this ,

1) Created an user with read only permission ( see the 1 st screenshot)

2) Created a dsn with read only option ( see the 2nd screnshot)

3) Then checked PK option in mapping section, and after migration shown table with Pk.

have you checked PK option manually in mapping section ?

[Mahesh]

HI,

Can you please try to migrate in MS excel ?Is data getting migrated properly ?

[Mahesh]

Issue confirmed using v 7.11 under wine

It is added in our issue tracker.

[Mahesh]

Can you please attach a crash dump file ?

[Mahesh]

Quote:

If the tables are not the right kind? PLEASE, do MAKE them so without me knowing it, and is there no index? PLEASE create one, without me knowing it. These things are not part of the semantics of Foreign Keys, they depend on the product and system, so the system should itself take care of these technical details. Pfff. ??

We will discuss this internally and let you know the details.

[Mahesh]

Quote:

CONSTRAINT `FK_PLtextlocation` FOREIGN KEY (`Language-id`) REFERENCES `PLLanguages` (`Language-id`)

here you can see from table “PLtextlocation” you are referencing a column “Language-id” of “PLlanguages” table which is not at all available, thus the error is obvious for this case.

Now, i have created a table called “Pllanguages” as,

Quote:

CREATE TABLE `Pllanguages` (

`labguage-id` smallint(5) default NULL,

UNIQUE KEY `NewIndex1` (`labguage-id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

and

Quote:

CREATE TABLE `PLtextlocation` (

`textlocation` varchar(20) NOT NULL,

`Language-id` smallint(5) NOT NULL,

PRIMARY KEY (`textlocation`),

UNIQUE KEY `NewIndex2` (`Language-id`),

CONSTRAINT `FK_PLtextlocation` FOREIGN KEY (`Language-id`) REFERENCES `pllanguages` (`labguage-id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC

I can see the relationship between these two tables now.

[Mahesh]

HI,

We have fixed both the issues ( No PK Migration and Program crash) in this v 7.12 (not released build) .

To Download,

http://www.webyog.com/downloads/betas/not_…yog712n1Ent.exe

Please verify and let us know the details.

Thanks,

Mahesh

[Author]

Posts