[vygi]

Now I've found out that ’ (ASCII #146) is a problem and not an usual “vertical” apostrophe '.

The affected line in the SQL file looks like this:

(3222,NULL,'1961-04-30',NULL,1,99,'X','Minneapolis','MN','USA','Bonnie Beecher’s Apartment',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL),

I was able to import this file into my local MySQL installation on Windows without any problems, but remote MySQL on Linux reports following error:

Error Code: 1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Apartment',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL),

and ´ is replaced by ' in sqlyog.err:

(3222,NULL,'1961-04-30',NULL,1,99,'X','Minneapolis','MN','USA','Bonnie Beecher's Apartment',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL),

Strange….

[vygi]

It's an old topic… but nevertheless:

maybe it would be possible to get a new config parameter “max bulk statement size” (set it eg. to 128 KB by default), and then divide bulk insert statements into that pieces?

Right now I've got timeout error because it took too log to upload a 500KB bulk insert statement. It worked when I've manually divided it into two ca. 250 KB parts.

Of course It is possible to export single statements but than it takes much longer to execute them.

Regards,

Vygi

[vygi]

wow – thanks a lot!

In return, I will do my very best in testing and reporting further possible problems (but hope that there will be not much of them).

All the best,

Vygi

P.S. …and next time better don't post your gifts that openly as everybody (like me) becomes envious of it…

[vygi]

Ritesh wrote on Nov 11 2005, 12:12 PM:

Thank you for the bug report.

I would be happy to provide you with a free license of SQLyog Enterprise. Just send a mail to [email protected] regarding the same.

[post=”7879″]<{POST_SNAPBACK}>[/post]

hey – cool! 😉

somebody has got a fee license just for re-submitting an OLD bug!

I have submitted the same problem already three times here, provided detailed descriptions and examples, look here: http://www.webyog.com/forums/index.php?showtopic=1739

1: Oct 13 2005, 03:59 PM (4.2 beta 5)

2: Oct 26 2005, 01:33 PM (4.2 RC1)

3: Nov 2 2005, 11:37 AM (4.2 RC2)

All what I got was a personal message saying that it will be fixed in 5.1.

(this was also the only reason why I've not re-submitted it again for the final 5.0)

A bit unfair — isn't?… 🙁 — where are my licenses?..

[vygi]

I have installed 4.2 RC2 and the bug is still here, although it now “works” in reverse order: next query can be executed insted of actual.

Actually I have 3 SQL statements in the query tab:

1st one is quite long (44 lines),

and following two are very simple:

SELECT 2+2;

and

SELECT 3+3;

SQLyog 4.2 RC2 now executes 3rd (select 3+3) query when cursor is placed on the right from “+” in the 2nd query, eg. in that way:

SELECT 2+|2;

SELECT 3+3;

Result is “6” and not “4”.

Queries are attached.

[vygi]

I have installed 4.2 RC1 and the bug is still here!

Actually I have 3 SQL statements in the query tab:

1st one is quite long (44 lines),

and following two are simple ones:

SELECT MAX(date_id) FROM calls;

UPDATE OLAP.calls, tinb.zones00 SET dest_id=code WHERE dest_id=100 AND date_id=1759 AND …

SQLyog 4.2 RC1 still executes 2nd (select max) query when cursor is placed on the left from the blank between “dest_id=100” and “AND” in the 3rd statement. (“…dest_id=100| AND date_id…”)

Full query tab content attached.

Vygi

[vygi]

peterlaursen wrote on Oct 17 2005, 11:15 PM:

If I understand you right I am still not able to reproduce! What do you mean by “that has an extra edit button” ?  Are you inside the BLOB-viewer?  And you really mean TEXT not CHAR/VARCHAR ?

Yes, I mean TEXT columns with “XXX b…” knob which opens a BLOB editor popup.

I thought that if F2 switches char/varchar and number fields into edit mode then maybe it will also open this editor. But instead of this, SQLyou immediately crashes on my Windows XP Home machine which connects to a 4.1 database.

peterlaursen wrote on Oct 17 2005, 11:15 PM:

However I experience something funny.  First I press on a TEXT column BLOB viewer opens.  If I close it then next I press SQLyog displays 'true' for the column.  ???

I have tried to do the same here in the office (XP Professional) and SQLyog does not crash by pressing F2. Insted of it, it switches TEXT field display to “true” without opening viewer/editor.

peterlaursen wrote on Oct 17 2005, 11:15 PM:

BTW: is quite undocumented, isn't it?  I don't find it anywhere!  Not in help .. keyboard shortcuts.

F2 is a standard key to edit fields in Excel and Access so I use it in SQLyog too.

By the way, SQLyog was just horrible yesterday: it has crashed at least 5-6 times in a hour. Either please send me some tools and I will try to help you with debugging or I must switch back to 4.1 as 4.2 BETA 5 becomes unusable 🙁

[vygi]

peterlaursen wrote on Oct 13 2005, 11:01 AM:

I think Ritesh should give you a build with a debug library.  Running a little bit slower but will give much more information if/when it crashes,

[post=”7561″]<{POST_SNAPBACK}>[/post]

Hey Ritesh,

any chance to get this release with the debug library?

SQLyog crashes quite frequently 🙁 One crash is even reproducible: just press F2 (“edit”) on a Text field (which has an extra edit button). Some other crashes seems to be quite random. It happened eg. when I tried to paste a short sentence into a text field editing window.

[vygi]

cathyli99 wrote on Oct 3 2005, 01:45 PM:

Is it also impossible to change the column name of the table?

[post=”7398″]<{POST_SNAPBACK}>[/post]

It must be easily possible:

ALTER TABLE tablename CHANGE COLUMN oldname newname column_definition

so it should be also easily possible via SQLyog

[vygi]

peterlaursen wrote on Oct 13 2005, 06:11 AM:

Did you click the refresh-icon. (the recycler-symbol) ?

[post=”7550″]<{POST_SNAPBACK}>[/post]

Additional note: SQLyog refreshes only the selected “subtree” of the object browser.

That means, you must click on the server and then refresh. It will not work if you eg. are pointing on some other database. The new one will not appear.

BTW I also got confused several times.

Does SQLyou not (or not always) refresh their lists after creating a new object????

<_<

[vygi]

peterlaursen wrote on Oct 10 2005, 01:59 PM:

Where did you get your my.ini from?  Generated by the wizard?

Yes, it was generated by the setup wizard. my.ini was not edited manually. Guaranteed!

peterlaursen wrote on Oct 10 2005, 01:59 PM:

First sentence from your mysql-docs go.  So if we were able to turn of 'strict mdoe with the connection, then we could create users with SQLyog even if strict mode is server default.  It is somewhat a 'hack' I know, but Rome wasn't built in one day.

[post=”7518″]<{POST_SNAPBACK}>[/post]

Yes but this would be just a very special workaround for this problem.

After creating an user, initial SQL Mode must be re-assigned. Otherwise one will develop and test some queries running on SQLyog but not with some other client with default settings.

This SQLyog issue must be fixed sooner or later. “Strict mode” will become more popular for sure as this is an ANSI SQL standard.

[vygi]

> 1) How is the definition of `ssl_cipher` on your system.

As usual: `ssl_cipher` blob NOT NULL,

> 2) Does your statement from history pane look like mine

> Note here that there is no value inserted for `ssl_cipher`.

> That is strange because a NOT NULL column with NO DEFAULT would normally generate an error if no value is inserted.

> But it does not here! Must be because it is a BLOB. But it does with you … hmmm.

Yes my statement looks exactly the same. No value for ssl_cipher.

Traditionally, MySQL always inserts some guessed value even if the field is described as NOT NULL and without any default value. Eg. you can insert a string into an integer field and it will probably become 0. This behaviuor may be very confusing in some cases, therefore MySQL 4+ got a “strict SQL mode” which returns error in such cases.

What can I already tell is: SQLyog is not compatible with the strict SQL mode!

Please execute following statement:

SELECT @@sql_mode

My installation returns “STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”. This seems to be default on MySQL 5.0.13-rc-nt (Windows) although MySQL documentation says that '' (empty string) is set by default.

STRICT_TRANS_TABLES means:

“If a value could not be inserted as given into a transactional table, abort the statement. For a non-transactional table, abort the statement if the value occurs in a single-row statement or the first row of a multiple-row statement. More detail is given later in this section. (New in MySQL 5.0.2)”

(http://dev.mysql.com/doc/mysql/en/server-sql-mode.html)

This is exactly what happens: SQLyog tries to insert a row (in a single-row statement) with a wrong value (actually without any value at all, although the field needs it), and MySQL refuses executing as documented.

> 3) I propose you try to create a user with “MySQL Administrator”.

It works as expected.

Administrator inserts an empty string as ssl_cipher.

[vygi]

peterlaursen wrote on Oct 8 2005, 08:51 AM:

Well I can create users easily with MySQL 5.0.13 and SQLyog Beta 5.

Did you tell the server somehow, that connections are SSL-encrypted ?

[post=”7490″]<{POST_SNAPBACK}>[/post]

Hmm… I have tried it again and it don't work.

There is nothing special in the configuration:

MySQL 5.0.13-rc-nt was fresh installed on Windows 2000 Professional with all default settings, and SQLyog 4.2 BETA 5 upgraded from Beta 2.

New user creation fails from local machine as well as via remote connection (same SQLyog version on Windows XP).

The error message is “Error No. 1364 Field 'ssl_cipher' doesn't have a default value”.

No SSL tunneling is being used for connections. SQLyou is easily able to create users “manually” by inserting row(s) into the mysql.user table.

😕

[vygi]

peterlaursen wrote on Oct 1 2005, 02:28 AM:

You should not give user credentials for a user that has DROP-privilege to “every dork”  😀

Your problem is database management.  It is YOUR problem.  Not af problem of webyog!

[post=”7383″]<{POST_SNAPBACK}>[/post]

Yes, I know I know I know, this is not a problem of webyog nor any other software applicaton;

our current problem is: some “dork” (not me) has created just one single MySQL DB user with all possible privileges, and this account is being used in all possible shell/perl/php sripts and crontab jobs (user name & password everywhere hard-coded) and also in ODBC data sources in almost every workstation, so the alternatives are to create a proper read-only user and either change all scripts (barely possible in a running system) or change all data sources (easily possible but lots of manual work) or – just as work-around as long as real solution – use “safe” clients without these attractive “drop” and “delete” knobs. This is what we do.

Sorry for disturbing…

Vygi

[vygi]

peterlaursen wrote on Sep 22 2005, 04:40 PM:

What I mean is that if you highlight a table i Object Browser, the create statement for the table is there.

Then mark-up any column-name and copy to clipboard with ctrl-c

Then paste it into editor with ctrl-v

[post=”7275″]<{POST_SNAPBACK}>[/post]

Aha!… 😎

Thanks! This workaround is better than mine.

But let's hope that the real solution will come soon.

Regards,

Vygi

[Author]

Posts