[peterlaursen]

For your best friend buy a 10-user license to SQLyog Enterprise! 😀

[peterlaursen]

Your issue has been reproduced and fixed in the development tree. A few more Win98 issues have also been fixed, but we have one remaining Win98 issue, that the program can crash when closing a connection. We are working on it, and hope to be able to fix it in next release.

[peterlaursen]

We have no such know issue. If I create the SP `cta_DEL_RoomType` and next click 'alter stored procedure' from I get a editor tab like

Code:

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`cta_DEL_RoomType`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `cta_DEL_RoomType`()
BEGIN
— do nothing;
END$$

DELIMITER;

Please:

1) tell what are the program versions (SQLyog and MySQL) that you use?

2) if you execute “SHOW CREATE PROCEDURE `cta_DEL_RoomType`;” what is returned?

3) try explain EXACTLY what steps to take to reproduce?

[peterlaursen]

Quote:

a backlog per DB

Such feature should be implemented in the Server or the Storage Engine maybe.

😛 .. Now you have my comments.

[peterlaursen]

Quote:

reboot into a DOS mode

I remember that I did this once 15 years ago too 😛

[peterlaursen]

“..useful to backtrack the last things I did using SQLyog ..”

What actually is needed is an option to save or 'spool' history to a file and load such file into SQLyog again.

This is a planned feature. But it is 3rd priority only (of 5).

[peterlaursen]

On Win 98 the installer copies two files: GDIplus.dll and shfolder.dll

. They are not copied on later Windows versions as they are available with the OS.

So it looks like the installer failed to copy shfolder.dll on your system.

What about GDIplus.dll? (program will start without it, but cannot display images in BLOB viewer without it).

[peterlaursen]

Yes .. just write the “SET sql_mode = ” yourself.

But when updating from RESULT tab if not all columns are shown and if the columns not shown are defined as NOT NULL and have no DEFAULT, then the UPDATE (and INSERT) statement may fail. That is true for the 'strict_all_tables' mode and the 'strict_trans_tables' with transactional tables (InnoDB tables). And maybe other modes too.

[peterlaursen]

I do not have 5.2 beta4 installed anymore, but I can confirm the focus issue by comparing 5.19 and 5.2.

That will be fixed of course.

[peterlaursen]

We will look into the options available with SSH tunnel by next week.

main puropose is to support private/public key authentication, but we will look into this too.

[peterlaursen]

this is a sql-mode issue.

Please refer to: http://webyog.com/faq/28_72_en.html

Please understand that it is the server that behaves like that in 'non-strict' mode – not SQLyog.

SQLyog does not alter data itself. It only sends SQL to the server.

We do intend to improve the handling of sql_modes, but have not yet fully annalyzed what is possible form a grid-based program. The problem is that if a column is defined as NOT NULL and does not have a DEFAULT, there are some issues when updating from the RESULT tab. That also will affect Usr management as the user table has some BLOB fields defined as NOT NULL (and BLOBs cannot have defaults).

One solution couild be only to SET sql_mode = '' for those operations where it is required and switch back again after that.

[peterlaursen]

Quote:

I can make it happen on any server/database.

I think you told it happened on certain servers only. Can you detail?

What is the server version?

Could it be this server bug: http://bugs.mysql.com/bug.php?id=19588?

(I do not know how effective the patch is!)

[peterlaursen]

Quote:

I don't know where and how can I execute this sql command.

Just execute from the SQLyog Query Editor.

[peterlaursen]

webmin uploads from local hard-disk

sqlyog sends over network.

and this: “Have a upload speed of about 400kb/s …” does not mean that the server or remote network lets you transfer data to MySQL at that rate.

Basically this is a configuration issue on the server/the remote network.

What sort of hosting are we talking about?

How do you connect?

[peterlaursen]

Quote:

I mean “running” sql-script, not “import”.

OK. Confirmed too.

Give us a few hours to analyze and discuss please … 😮

[Author]

Posts