[peterlaursen]

It might be because the server does not accept 'url_encode' in the HTTP header. This is a known issue on some systems (actually it was only reported on Win2003/IIS till now with some specific PHP builds – but this may be the same issue). The 'url_encode' in the HTTP header was introduced (I think in 6.0) to solve some issues with other server configurations.

We have a special 6.07 build that does not use 'url_encode' in the HTTP header. Would you mind trying this one? We can provide an updated (6.14) build if it helps and if you cannot or dont want to update server configuration!

Links

Enterprise registered: http://www.webyog.com//downloads/betas/not…rlencodeEnt.exe

Enterprise trial: http://www.webyog.com//downloads/betas/not…odeEntTrial.exe

BTW: what is PHP version?

Alternatively you could let us connect (create a account with minimal privileges (select priv to a single table with 'dummy data' is enough!)) so that we can use our debugging environment. For privacy you can create a ticket with details.

[peterlaursen]

BUT …

.. it will have to be analyzed in depth!

A VIEW definiton can use UNIONs, JOINs, GROUP BY's, aggregate functions, and even Stored Functions (do not know much about UDFs (User Defined Functions))! And frankly I do not trust MySQL Information_Schema too much before verifying every detail …

@coffeeboy .. do you know positively that this 'SQL monster' is able to handle all that stuff correctly?

[peterlaursen]

Just let me add that once a server is REGISTERED, MONyog will collect and store data from that server – no matter if it is SELECTED (= displayed) or not!

[peterlaursen]

1) 'save LAYOUT as graphics' is not a very big problem. It requires some code of course but when we can populate the screen canvas we can of course too populate some graphics object

2) zooming is a bigger problem! Admitted that we did not (but probably should have) designed for that originally. Please give some days for analyzing!

[peterlaursen]

After analysis we realize that we could query Information_Schema 'views' and 'columns' table and *construct* a better readable (but functionally identical) CREATE statement for the VIEW.

[peterlaursen]

I think nobody understands your problem!

Could you consider to explain better?

To insert a weblink as I understand you do like this (in HTML)

Code:

text

for example

Code:

link to Webyog

It makes no difference if this is hardcoded in a webpage or if the webpage gets its content from a database.

[peterlaursen]

The issue with Windows servers having 'lower_case_table_names' setting = 2 (allowing for using UPPERCASES) will be solved soon of course!

[peterlaursen]

We plan to add this to the GRIDs:

* add select all/deselect all functionality

* add 'SHIFT+click modifiers' (like in the gmail webinterface)

* add an option to select a row without using the mouse (SPACEBAR has been proposed for that. Idea is that it should be possible to scroll through a table or a resultset with arrow keys and select rows without using the mouse.

We have a few issues and enhancements with the Query Builder and the Schema Designer that will be handled first (and I guess that will take 3-4 weeks) – and the above issues are next task assigned for this particular developer.

[peterlaursen]

When a server is REGISTERED in is not automatically SELECTED (and displayed).

This is designed like this mostly for those people who have an 'unlimited' license. If you have 30 servers registered for instance you would probably not display them all at the same time!

[peterlaursen]

1)

Do you know if the server was installed 'on top' of a previous version? If so did you execute the 'mysqlupdate' program and/or 'fix_privileges' and 'fix_system_tables' scripts?

I will have to know the exact server version if I should detail more .. but what is the exact server version?

2)

Do you have an option to try another server installation (best of all a 'fresh install')?

Maybe buttons becoming greyed out is not the most intuitive way of responding to this situation. But we would not be able to sync anyway if the server(s) do not send the information needed!

[peterlaursen]

1)

Do you know if the server was installed 'on top' of a previous version? If so did you execute the 'mysqlupdate' program and/or 'fix_privileges' and 'fix_system_tables' scripts?

I will have to know the exact server version if I should detail more .. but what is the exact server version?

2)

So you have an option to try another server installation (best of all a 'fresh install')?

[peterlaursen]

1)

Do you know if the server was installed 'on top' of a previous version? If so did you execute the 'mysqlupdate' program and/or 'fix_privileges' and 'fix_system_tables' scripts?

I will have to know the exact server version if I should detail more .. but what is the exact server version?

2)

So you have an option to try another server installation (best of all a 'fresh install')?

[peterlaursen]

1)

Do you know if the server was installed 'on top' of a previous version? If so did you execute the 'mysqlupdate' program and/or 'fix_privileges' and 'fix_system_tables' scripts?

I will have to know the exact server version if I should detail more .. but what is the exact server version?

2)

So you have an option to try another server installation (best of all a 'fresh install')?

[peterlaursen]

SQLyog connects to MySQL with the MySQL client library (the C API).

Only when connecting to 'localhost' on a Windows system (and only if the user is an admin user) it will be possible to read the content of files.

On Linux etc. you would at least need to change Operations System/File System privileges. The .frm files are in the MySQL data folder that is owned by 'mysql' Linux user (who is the only member of the 'mysql' user group). Only this 'mysql' user and 'root' user can read the files with a *nix standard privileges setup. I am pretty sure that Linux Sysadmins would reject the idea that users 'robert' or 'peter' should be able to read the files (for security reasons)!

And when connecting to a remote host there is absolutely no way to read the files. The client can only get what info the server returns from SHOW and SELECT statements.

As my second post indicates it is also not 100% certain that the original CREATE statement is valid anymore. It was at create time – that is the only thing that is certain – but the table(s) underlying the view (and stored programs if such are used for defining specific columns of the view) may have changed in between! There is no information available (not to the server itself either) to tell if it still is! That is why the server itself cannot use it directly!

Still I think some formatting should and could be done (at least the original linebreaks and indentations should be respected), but it should be done on the server side.

[peterlaursen]

Maybe you have a point! We will check details and discuss that by beginning of next week!

(However I also think that SQLyog and the 'mysqldump' program does the same!)

Actually a stored procedure/function will restore/create even if they are referencing non-existing Tables and Views.

So maybe the SP's should be at the very beginning!

We will also have to consider Triggers and Events (that will also be supported in 6.2). I think Events are similar to SP's (it is a 'stored program' actually). But I do not think a Trigger will create if the table it is defined on does not exists.

I am also not sure if different MySQL versions are 100% consistent in this respect! We will check all that stuff of coruse!

[Author]

Posts