[peterlaursen]

How did you upgrade? did you run the update scripts as the MySQL doducmentation describes it after the upgrade?

When you click the + of a database SQLyog sends

Code:

select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA` = 'your_db' and `TABLE_TYPE` = 'BASE TABLE'

(bacause that is the way to distinguish betwenn tables and views)

what hapens if you execute it as plain SQL? Looks like a defect information schema or a privilege issue.

[peterlaursen]

I am not sure myself! An it indeed looks weird.

If you can produce some kind of test-case (table def's + a few data) I would like to work on it too.

You can attach it here or create a ticket.

[peterlaursen]

What is the SQLyog version that you are using?

There was an issue fixed with TIMESTAMPs early in the 5.x tree

But it is not supposed to work with TIMESTAMPs across MySQL 4.0 and 4.1

Please read:

http://webyog.com/faq/11_68_en.html

actually it surprises me that it works to 'some degree'

[peterlaursen]

Only jobs that have been scheduled with the Windows Scheduler display in the 'Job Manager'.

It simply gets its input from Windows Scheduler and 'filters out' from here sja-instances.

Did that answer your question?

But my personal opinion is that that could very well be improved …

You can open the jobfile from the wizard, step through the wizard and eexecute.

This may be of use for you too: http://webyog.com/faq/27_74_en.html

[peterlaursen]

The SQLyog Migration Tool does not even attempt migrate Stored Procedures.

If there is some tool available that could be useful to you, I do not know. I doubt it. But it may depend on what your current SP's are like.

[peterlaursen]

There an sometimes some 'weird' issues with the Windows scheduler.

We have a FAQ here: http://webyog.com/faq/27_34_en.html

Maybe you can use some hints from there?

[peterlaursen]

I you have problems attaching files the try zip them.

I do not understand you very well. But once I get the files I think I will be able to!

[peterlaursen]

Now .. I can easily do that ALTER TABLE .. see attached.

hmmm… what do we do from here ???

It looks like a server configuration or privilege issue.

What is MySQL version ? A shared (ISP) server?

I assume that the samme error occurs from SQLyog SQL-pane and MySQL command-line client?

BTW 1): NO! the KEYWORDS handling is hotter than autocomplete!

http://www.webyog.com/forums/index.php?showtopic=1953 😀

BTW 2) gurus??? where???? no my dear – PROPHETS !!!

You can try from any other client this

“alter table `test4`.`ccc_area_list` change `title` `title` varchar(50) NOT NULL”

is there somewhere else where it works?

[peterlaursen]

There are several issues here. And we will need your help to sort it out…

1) “i try 5.14, when i export to html it is wrong(2.png),but i use select * from mybd.table and export the result to html it looks right (1.png)”

Try opening the files in Notepad!

Export table from the Object Browser includes a charset META-tag like

..export table from RESULT pane does not have a 'charset=' and then the browser will have to decide … and it seems to decide right!

2) Actually it surprises me that you are able to work with chinese string data so well in the GUI.

What MySQL charset do you use for string columns with chinese data?

(it surprises me that you use latin1 as server default!)

Also what LOCALE is your Windows? and your OFFICE software?

And is this 'simplified chinese' or 'traditional chinese' ?

3) CSV: I think it is Excel that is 'smart' enought to realize that this is chinese. Especially if you use a chinese Windows localization and a Chinese Office Suite. How does the file display if you open it in Notepad?

4) XML has the same issue as HTML. When exporting from Object Browser there is a header like

but there is not when exporting from RESULT-pane

I believe it is a bug (something that was forgotten) when it is NOT there! But to be able to export multibyte characters as UTF8, I think SQLyog must be compiled with Unicode. You Chinese LOCALE settings 'saves it' when no charset is specified, I belive.

We have a general FAQ here: http://webyog.com/faq/34_102_en.html

.. but that may not be fully correct if you are using Chinese software.

I really do not know how Chinese is implemented is Windows for non-Unicode programs.

You are welcome to comment on it!

Do you still have the FILES (HTML, CSV and XML files). If so please attach them too!

Also a dump of the table (or any small table with those characters) would be nice (though I doubt that my Danish Windows LOCALE support displaying it in SQLyog. Though I should be able to view the HTML at least!)

[peterlaursen]

Another consideration:

In a numerical field you can use functions like round(7.9,0)

and it sends:

update `tablename1` set `id`=round(7.9,0) … where …

and 8 is inserted as the function is evaluated to 8 by the server.

however you cannot use expressions like 7+3

it sends

update `tablename1` set `id`='7+3' … where …

.. but the server does not evaluate the expression, because it is sent as a string.

What about an Excel-like formula notation (using '=') like '=7+3'

.. so that SQLyog will do

update `tablename1` set `id`=7+3 … where … (no quotes!)

BTW: I think it should be a configuration option to turn on/off evalutation of expressions and functions.

[peterlaursen]

Yes, I can tell.

Please read: http://webyog.com/faq/8_99_en.html

.. so what you need to do is to enclose the literal string in backticks/backquotes like

Code:

`ceiling(msl/8)`

Now watch the HISTORY tab and see what it actually sends to MySQL!

.. but actually nobody ever told me that it now is possible to use functions and have them evaluated. So I guess that I will have to update the FAQ with that.

@Ritesh/Sarat: intended behaviour? It would be 'smart' if it only attempted to evaluate functions that actually exist! It could use the functions-list from 'keywords.db' file !!

[peterlaursen]

@manoj

Please note that there are new developments here:

http://bugs.mysql.com/bug.php?id=19874

And with MySQL 5.1.11 I cannot reproduce any problems with the “.” (punctuation) character anymore.

But there is some small bugs with SQLyog when BACKTICK is used in a database or table identifier.

(and would probably be the same with ” in ANSI-mode)

1)

I can create the database `db…7`and table `t`2` (by entering `t“2` as the table name)

However the 'double backticking' should ideally be done transparantly by SQLyog (though not important!).

2) and more important:

when activating the table and clicking the DATA tab, SQLyog does

show full fields from `db…7`.`t`2`;` — raises error 1064

It should be

show full fields from `db…7`.`t“2`;

It affects probably every SQL command executed on the table. Also 'describe', 'show full keys' etc

3)

I can create a database `t`g` (also here I must enter `t“g` myself) .

But also some database related SQL commands executed by SQLyog are wrong.

For instance it is not possible to create tables in this database with SQLyog GUI.

The database also cannot be DROPped from GUI.

(but does not affect those statements of the type SELECT .. FROM INFORMATION_SCHEMA … for some reason)

4)

And of course STORED PROCEDURES, FUNCTIONS, TRIGGERS, VIEWS are affected as well.

You can create SP 'n`n' like CREATE PROCEDURE `test`.`n“n` ()

.. but DROP and ALTER PROCEDURE raises an error too (and an error without a number ??)

[peterlaursen]

Oh yes .. that could be! 🙂

Well then let me repeat my implementation proposal:

A RESULT tab has a 'pin' icon on it. It is normally 'greyed out'. Clicking it makes it 'color-up' and that TAB gets 'sticky' (won't go away unless you explicitly close it or make it 'non-sticky').

[peterlaursen]

1) drag'n'drop:

there are more places where drag'n'drop could be implemented. It takes an awful lot of time. It is not high priority right now I think.

2

“Each Tab should display it's own result set instead of one result set shown for every tab…”

My left shoe should be on my left foot and not my left foot in my left shoe ?????

… Sorry but I do not understand what you mean! 🙄

[peterlaursen]

What is the SQLyog version?

And where did you get it from?

Before going further we must be sure that is the latest version (5.14) that you have and not some old copy!

[Author]

Posts