[peterlaursen]

we will certainly look into this Monday morning.

It would be a help is you attached a small dump with data to reproduce the porblem.

You can create a ticket if you do not want to expose the data in public.

[peterlaursen]

ok .. ther was a PK ..

.. but what is the SQLyog version that you are using ?

Th PK is based on a varchar column (CallId).

There has been some issues with special characters in string-based PK's (like for instance ), but I believe everything is OK with recent versions.

However string data must use the same charset. For instance if one table use utf8 and another latin1 and there are characters outside the ASCII-range, situations like this could occur. Check for this.

If not we will need two samle tables (source + target) to reproduce with.

Also inform about the MySQL versions.

[peterlaursen]

Fixed in the development tree.

Issue was that is the query did not use `database`.`table` notation but only `table` notation, the latest USE statement got lost if SQLyog reconnected – what it frequently does with so-called 'slow servers'.

Now it will USE the database shown in the combo-box in such situation.

[peterlaursen]

Reproduced here now too.

We are (re)searching ….

[peterlaursen]

And it is SQLyog 5.2 RC2 ?

[peterlaursen]

what format (HTML, CHM or PDF) ?

which version ?

what language ?

from where to get it?

[peterlaursen]

You explanation is good enough for me to understand!

But I think it is not the scope of SQLyog to define the SQL language!

We have no plan to add our own extensions the language like this.

[peterlaursen]

SQLyog reconnects automatically in case server does not respond.

Actually a lot of other software does too.

Also autocomplete starts it own thread for building tags.

Can you tell more about the situation?

But I do not think it is worth bothering about.

[peterlaursen]

Quote:

I still don't get right encoding.

Table type/engine and encoding/charset are two different things!

You asked how to change the table TYPE, but to change the CHARSET in MySQL execute for instance

Quote:

ALTER mytable default charset utf8

But note that this is not affecting existing columns in that table.

Only new columns created after that will be affected.

Also this we plan to support from the GUI (CREATE TABLE and ALTER TABLE).

[peterlaursen]

that is planned!

We just arranged our TODO-list or 'wish-list' into 4 categories/priorities. This comes into 1st priority.

[peterlaursen]

Quote:

All tables have primary keys defined (unique etc…)

A UNIQUE KEY and a PRIMARY KEY is NOT the same thing. Do you have a PRIMARY key?

You may paste the table definition here!

[peterlaursen]

Just first create the table using default, next rightclick table .. change tabletype

We will support defining an ENGINE with create database, create table and alter table soon.

[peterlaursen]

Do you mean that this happens for you with direct connection?

[peterlaursen]

Still please try latest available version (RC1). I might be wrong when trying to remember when that last pice of code was changed in this respect.

[peterlaursen]

Quote:

sqlyog enterprise v4.1

We do not support such old porgram versions! Please upgrade!

You can still upgrade for free if you hurry up!

Upgrade policy: http://webyog.com/faq/30_129_en.html

Of course I cannot guarantee that an upgrade will sove this. But there has been a lot of improvements – also with connectivity. So testing with a recent version would be 'first shot'.

for clarity: I am talking about upgrading SQLyog – not MySQL!

[Author]

Posts