[peterlaursen]

Sorry for the late reply.

I do remember to have seen this before: “The server understood the request, but will not fulfill it. – Could not get FIELD information for …” It occured with a relatively old MySQL 4.1.x too and was not reproducable with 4.1.20. But I do not recall details.

Also we just verified that 4.1.19 (and 4.0.20 and 4.0.21) and 4.0.26 (and 4.0.27) syncs.

But it could also be an issue with a specific character set or data type.

Please create a ticket with some source data (only the problematic table with a few rows of data)

[peterlaursen]

It is all fully explained here:

http://webyog.com/faq/34_102_en.html

When connection to Unicode data you SHALL NOT CHOOSE 'default' as the character setting in the connection manager! But chose a non-unicode character set the corresponds to the language of the client and the data.

[peterlaursen]

If Sqlyog is the only program changing the structure of databases there is in principle NEVER any need to 'rebuild tags'. 'rebuild tags' means that SQLyog builds the small database files used for autocomplete.

It is you own choice if you will do so each time a connection is established. The only thing that 'goes wrong' if TAGS are not fully up-to-date is that autocomplete may not display some table names etc. that it should (or oppositely: it may display some that have been deleted since last rebuild)

[peterlaursen]

User privileges in MySQL are host specific.

so you must grant privleges to the remote user. If for isntance root shall be able to log on from everywhere and have same privileges as 'root'@'localhost' has the SQL is

grant all on *.* to 'root'@'%' with grant option;

On an example where 'billy' may only select from a single database and connect from a certain group of ip's.

grant select on *.* to 'billy'@'10.0.0.%';

http://mysql.com/doc/refman/5.0/en/grant.html

[peterlaursen]

I must say that I absolutely do not understand if this will be affected at all on the installation method.

This change is in the sqlyog executable and not some other file in the installation directory.

[peterlaursen]

It syncs perfectly here with two 5.0.23 servers.

[peterlaursen]

beta 2 is released now:

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

please report back 🙂

[peterlaursen]

@Tom and @Prasad

please see ticket 880!

[peterlaursen]

I cannot reproduce with InnoDB either.

Prasad (test enginner) is trying to reproduce/explain the issue!

[peterlaursen]

I wonder if CPU load is very high due to other tasks running?

[peterlaursen]

I am sorry but I cannot reproduce either!

I just copy a table with 150.000 rows and it (5.16) displays for every 1000 rows. The complete copy process took 4-5 seconds (copy to another computer on LAN).

Now what do we do from here?

[peterlaursen]

of course .. sorry for the silly question!

There is no scrollbar when word wrap is 'on'

[peterlaursen]

We have an identical report with a precise test case in our ticket system and it will be fixed in 5.17.

I think you can navigate the right by pressing the END key. Right?

Can you tell if 'word wrap' is checked in 'preferences' or not?

edit: no it is NOT exactly the same thing, I see now!

[peterlaursen]

@Scott and @Donna.

We would like to compliment you for this.

Most often we give away a free personal ENTERPRIE license in such cases.

However if you have allready (and don't need more than one) we can prolong the registration period instead.

Create a ticket and tell on what you want!

[peterlaursen]

I just tried MyODBC 5.04 myself.

It installs without problems. But when I try to use it Open Office base neither Tables nor Views show up. And with Access 2000 an error msgbox 'Driver does not support the environmental attributes' (translated from Danish) pops up.

[Author]

Posts