[peterlaursen]

Confirmed fixed in BETA 6.

[peterlaursen]

Quote:

however if I go back to edit the query, the line breaks are not displayed when it pulls from the job xml file.

Yup! now I understand. Confirmed. Actually both control characters rn are stripped away when loaded into Notifications Services SQL-window from an existing job file. You can copy into a HEX-editor and see that both character '0D' and '0A' are missing. However first time you type it they both are there.

Agree that this should be fixed!

[peterlaursen]

Quote:

I am encountering the same 'Error No. 1062' – complaining about duplicate entries in my primary key. I have tried globally setting the sql_mode = 'NO_AUTO_VALUE_ON_ZERO' but the problem remains.

Well if you set sql_mode = 'NO_AUTO_VALUE_ON_ZERO' an enter more rows with id=0 (if a PK) then of course you will have 'Error No. 1062' – duplicate entries in my primary key' for row no. 2.

@joejk2:

1) Are you using HTTP-tunnel? There was a bug in the tunnelling file of 5.02 that could create things like this!

2) So would you please try version 5.1 BETA6.

Also setting the global sql_mode = 'NO_AUTO_VALUE_ON_ZERO' will not have effect with SQLyog as SQLyog sets “sql_mode = '' ” for the connection! refer to: http://www.webyog.com/faq/28_72_en.html.

You will have to issue the set sql_mode form inside SQLyog. With HTTP-tunneling you will have to edit the tunnelling file to change the SQLmode (either 'hard-code' the sql-mode or use mysql_pconnect() method. On editing the tunnellng file: http://www.webyog.com/faq/21_103_en.html (with 'pconnect' MySQL 'remembers' the setting from statement to statement.)

If I did not fully understand then please describe your problem more in detail!

[peterlaursen]

I would like you to tell HOW you enter that linebreak? Do you key it in from keyboard, or do you copy from some other program?

Windows standard for link break is both characters “rn” or (in ASCII) or (in HEX) “0D 0A”; *nix standard is r only.

With this query

Code:

use test;
select * from my_table;

.. no matter if I key it in or copy from Editor/SQL-pane the saved XML-file has both characters. When opened in NOTEPAD each character displays in each their line.

If you paste in from some editor generating only the n character 'Notifications Services' simply sends and saves it as it was entered. If you open the XML in NOTEPAD all queries will be displayed in one line. However there are lots of other editors and some display a linebreak with the n character only.

And actually on my system the 'Notifications Services' query window displays a linebreak if either of the control characters are present.

Question is: how do you enter the SQL? Looks like you are pasting from a program that strips the control characters?

[peterlaursen]

I have 2 WinXP installation and two Linux (SuSE 10 and FEDORA 5). On the two Windows I have 5 different MySQL versions (3.23, 4.0, 4.1, 5.0, 5.1) installed. I can connect from local machine to all MySQL's (that is 12 different ones) from SQLyog and SJA installed on local Windows (or WINE). I have 5-6 different SQLyog versions installed on each (from 4.07).

This is not a general problem, but only occuring on some specific systems.

@Les: Could I ask you to try

1) making a completely fresh install (just install once more to another folder and run from here) and see if the problem persists.

2) renaming the sqlyog.ini file. SQLyog will then start building a fresh one.

[peterlaursen]

@Tom

the '… application datasqlyog' folder is where the 'favorites' are stored. If you now create some new favourites a new '… application datasqlyog' folder will be created. Does that work now?

As this seems to be related to file systems access I would suggest that people with this and similar problem(s)uninstall it, delete all folders used by sqlyog and try with a fresh installation.

I myself experienced some problems earlier with a sqlyog.ini file that had grown to messy after lots of updates. Reneming the .ini file solved the issue as SQLyog would then build a fresh one.

@Ritesh: does SQLyog quote like C:”Documents and Settings””Tom.DZINE201″”Application Data””SQLyog”. Maybe that was a good idea?

[peterlaursen]

That is the crazy thing about this crash phenomenon that it is never reproducable .. 🙁

[peterlaursen]

1) 'Rebuild TAGs' is available form 'powertools' menu.

2) “has the incredibly long delay when deleting text from the query tab been addressed yet?”

Sorry .. I don't understand or don't remember. There is no such kind of delay here. A problem you have been referring to before?

[peterlaursen]

Could you explain a little bit more … and maybe post a screenshot … tht would ne nice 😀

Or are you requesting some symbol like Greek letter 'pi' in some wordprocessors to indicate the linebreak?

[peterlaursen]

SJA for LINUX is a FREE program for everyone.

Check the FAQ for detailed description of the differences

[peterlaursen]

YES ..

As of now it is EITHER .. OR. BOTH .. AND is not possible.

And another detail still missing is e-mail functionalities with the DATA SYNC … like the other SJA-modules have.

I think it is plalled to do quite a lot of improvements to the SJA once 5.2 is out. However I can't tell if this request for BOTH .. AND is a minor thing that can be 'put in'. It is a matter of planning developer resources. Ritesh must tell.

[peterlaursen]

What is the program version you are using?

I think I remember that this was fixed long ago.

With these data at source (note the escaped singlequote)

Code:

CREATE TABLE `pladder2` (
`id` bigint(20) NOT NULL auto_increment,
`t` varchar(50) default NULL,
`f` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `pladder2` */
insert into `pladder2` (`id`,`t`,`f`) values (1,'f',NULL),(3,'dd'f',NULL);

and those at target.

Code:

CREATE TABLE `pladder2` (
`id` bigint(20) NOT NULL auto_increment,
`t` varchar(50) default NULL,
`f` float default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Data for the table `pladder2` */
insert into `pladder2` (`id`,`t`,`f`) values (1,'f',NULL),(3,'ddf',NULL);

it syncs OK like:

Code:

SQLyog Job Agent Version 5.1
Copyright (c) Webyog Softworks Pvt. Ltd.. All Rights Reserved.
Sync started at Thu Apr 06 19:58:17 2006

Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
`pladder2` 2 2 0 1 0

Total time taken – 1 sec(s)

So I think you should just consider upgrading you old program version!

[peterlaursen]

??????

I tried with SQLyog Enterprise 5.02 and 5.1 beta 5. Results are the same.

1)

I can dublicate and export/import any table whether it is named SELECT or UNIQUE or whatever

2)

and all objlects (including databases and tables) are ALWAYS enclosed in backticks.

BTW: THIS IS NOT ESCAPING – escaping is something quite different!

A more detailed 'test case' please!

[peterlaursen]

There is a LINUX version of the SJA (the 'SQLyog Job Agent') but not SQLyog (the graphical program).

[peterlaursen]

the best way would be .. I think …

1) Run the Migration

2) ALTER TABLE

if you want it fully automated you can create a batch file that 1)first executes a SJA-importjob 2)next executes a SJA-notify job doing the ALTER TABLE.

just like

*******************

sja myimportjob.xml

sja mynotifyjob.xml

*******************

http://www.webyog.com/faq/27_35_en.html

[Author]

Posts