[Mahesh]

Issue Confirmed

Query generation was wrong here,

Quote:

select count(*) from `temp` where `field1`='2' and `field2`='1';

update `temp` set `field1`='2',`field2`='2' where `field1`='2' and `field2`='1';

Wrong query.

It should be ,

Quote:

select count(*) from `temp` where `field1`='2' and `field2`='2';

update `temp` set `field1`='1',`field2`='1' where `field1`='2' and `field2`='2';

Correct Query.

We will look into this.

Thanks for reporting.

[Mahesh]

Please send us, The Table schema with some sample data where it is reproducable.

[Mahesh]

problem 1

Please tell us,

i) Attach a screenshot of CSV settings while exporting the data?

ii) Attach a screenshot while importing the data using CSV import?

iii) Provide a table with some sample data where it is reproducable ?

Problem 2

We are not supporting direct import from excel files.

[Mahesh]

HI,

In Connect to mysql Host window — Mysql tab,

1) Mysql host address- IP address or host name where mysql is installed.

2) User name- User name who is having access to mysql server.

3) password — user's password

4) port — TCP port (default is 3306)

Please see in help document –Getting started section.

[Mahesh]

Please tell us,

1) Which mysql version are you using?

2) How mysql is behaving with update query?

[Mahesh]

Quote:

I then switch the top tab over to Query and wait for the results. Nothing happens and I have no data. According to the help manual, I should see the results.

Once the query is generated, Click on Start a Query with new Query Editor then query will be opened in Query editor, Press F9 to execute the query then only you will see the result of the query.

We already have plan to implement , the direct execution of the generated query in Query Builder itself.

Thanks

[Mahesh]

Quote:

Query:

CREATE TABLE `buyout_product` (

`buyout_id` int(11) unsigned NOT NULL auto_increment,

`category_id` int(11) unsigned default NULL,

`description` varchar(50) NOT NULL,

`weight` decimal(11,3) default NULL,

`price` decimal(11,2) default NULL,

`create_date` timestamp NOT NULL default CURRENT_TIMESTAMP,

`country_of_origin` varchar(50) default NULL,

`alloy` varchar(50) default NULL,

PRIMARY KEY (`buyout_id`),

UNIQUE KEY `new_index9` (`description`),

KEY `FK_buyout_category` (`category_id`),

CONSTRAINT `FK_buyout_category` FOREIGN KEY (`category_id`) REFERENCES `category` (`category_id`) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB AUTO_INCREMENT=11129 DEFAULT CHARSET=utf8 COMMENT='InnoDB free: 59392 kB; (`category_id`) REFER `metalsmith/cat'

Error occured at:2008-06-30 11:19:23

Line no.:502

Error Code: 1005 – Can't create table '.metalsmith_targetbuyout_product.frm' (errno: 150)

I got this error while restoring the dump attached above.

This error is obvious cause `Category` table does not exist while restoring the dump.

Also, I din get any error related to trigger , i can see from the SQLyog.err file attached by you that trigger related error was logged in year 2007.

Please empty the sqlyog.err file and try again the restore from dump and check what error message you are getting?

[Mahesh]

Quote:

I have not had any problems at all. I first tried running the sync and testing the Generate Script feature, but at the 7th table it bombed. I then retested this same sync, but this time doing a Direct Sync, and ending in the same results. The included dumps are what I received. For the record, the databases that I'm trying to sync contains 256 tables with 20,348,525 total rows, and all are MyISAM.

Are you using direct,SSH or http connection for syncing operation?

Is this happening only with only 7th table ?

Can you please give us the reproducable case, may be small source and target dump ?

[Mahesh]

It is reproducable in vista too.

Pop up of dialogue is taking time ( it took around 40-45 secs to pop up the Open file dialogue.)

And after popping up the dialogue for error message dialogue ( takes around another 15-20 secs.)

We will check this in details and let you know.

[Mahesh]

HI,

I think you are talking about “Restore from SQLdump” dialogue ?

For me program never hangs after disabling n/w connection, it throws an error message -see the screenshot.

And Again After enabling n/w restore operation works perfectly after (5-7 secs>) as n/w got established.

[Mahesh]

HI,

This issue has been fixed in program version 6.1,

Please upgrade to latest version.

Thanks

[Mahesh]

Quote:

Hi,

Suddenly none my sync tasks are completing.

The MSTask.exe console window pops up, and after a number of seconds an error dialog pops up with the window title “ODBCImport Tool”, and gibberish in the dialog.

I have attached a screen shot.

Any idea what is going on here? I have five timers that have been operating reliably for over a month and suddenly this has happened.

Issue Confirmed

This error message pops up when SSH authentication fails.

We are analysing and will update you shortly.

[Mahesh]

HI,

You can add # number of columns inside QB grid,

To Add column — select a column inside QB grid– Right click — Select Insert column.

[Mahesh]

HI,

Tunnnler(SQLyogTunnel.php file) is not coming with community and the files after a fresh isntall are….

GPL.txt, keywords.db,sciexer.dll .chm ,sqlyog.exe and uninstaller for both enterprise and community.

[Mahesh]

MONyog is a dedicated and specialized web-server also makes it very secure.

You can install MONyog on your local machine and can access it remotely by giving IP of your machine, so that it is not accessbile over the internet.

Also MONyog is password protected –during install you can give password or you can set it from Tools– Preferences.

[Author]

Posts