[peterlaursen]

I good request!

added here:

http://code.google.com/p/sqlyog/issues/detail?id=434

[peterlaursen]

Yes, your are right!

When we open the program we do not check if the coordinates stored are available.

I do not know exactly how to do this, but there must be a way!

I added this issue here:

http://code.google.com/p/sqlyog/issues/detail?id=433

[peterlaursen]

I think you or a colleague of yours created a ticket with the same subject!

Please only use ONE channel — it makes it easier to coordinate. I replied in that ticket!

[peterlaursen]

Please link to the 'previous reported problem' if ther is important information. And next time: please continue in the same thread!

Also always tell the program version!

“This is only affecting one table” .. well it may be some data specific issue. We have no change to do progress with this unless you give a test case!

Could you dump that table and let us have it? Use the ticket system if you want privacy! And please zip the file!

[peterlaursen]

Is the server a 64 bit Linux or Windows?

The old issue that I am referring to was simply that after some hours (typically a night) of inactivity the SET NAMES initially sent by SQLyog was sometimes 'forgotten' by the server and the datastream sent to the client (character_set_client) was encoded using the default and not the setting specified by SQLyog whne connected. As far as I remember this was an early 4.1 or 5.0 server build.

It is public holiday in India today, so only tomorrow we will be able to look into this.

[peterlaursen]

“My guess is that when reconnecting to the “gone away” server you are not using the same SET NAMES or some other code.” We will check this in detail. Nut we actually are (or should be) using the same function whenever reconnecting.

We have one example where the server 'forgot' the client and connection charsets setting after some time of inactivity. That one was a server issue!

What is the exact server and SQLyog versions that you are using?

[peterlaursen]

yes .. we should consider ALTER TABLE and not just DROP-CREATE with structure sync!

[peterlaursen]

The only processes you get returned are processes of user 'MONyog'. And those are filtered away .. !

so either there are no processes of other users or the privileges don't work as expected!

What does

Code:

SHOW GRANTS for 'MONyog'@'localhost'

return?

[peterlaursen]

1) Please try to execute SHOW FULL PROCESLIST as the same user. If you have SQLyog you can use the tools .. show menu.

2) What are the privileges of the user? Does he have PROCESS or SUPER privilege? (refer to the docs!)

3) What is the PROCESSLIST filter currently in action?

[peterlaursen]

As regards 3) it works fine for me with both CREATE TABLE and ATLER TABLE.

I can type directly without using the mouse at all.

what am I missing?

[peterlaursen]

first:

You cannot use the DUMP file unless —

1) You have the Microsoft Visual Studio .NET 2003 development environment installed

2) You have access to exactly the same source code version as the program was compiled with.

.. so please attach here (zip before attaching). There is absolutely no private information in the file that is usable for anybody!

second:

But please also

1) tell if this is consistently reproducable.

2) tell what operation caused this

3) if it is reproducable please try iv version 6.1 solves the issue.

[peterlaursen]

I thougt the MySQL server was running on that MAC.

Maybe there was a user configured for specific ip's?.

If it is a shared/hosted server at an ISP, then it is a chance that you will have to allow access from specific ip's from a webbased control panel.

Unless of course user or password was typed wrong (lettercase?) or some similar trivial mistake!

[peterlaursen]

1) the different passwords handling with different MySQL version only affect SQLyog when HTTP-tunnelling. The PHP binaries and the Server binaries must match. This is NOT AT ALL a SQLyog issue!

The solution is to configure the specific user to use the old passwords handling.

http://webyog.com/faq/content/23/18/en/err…on-denied-.html

2) Please read

http://webyog.com/faq/content/23/18/en/err…on-denied-.html

.. probably only connection from 'localhost' is allowed for this user and you are trying to connect from a remote host?

[peterlaursen]

Program should absolutely not crash!

It is true that we need the MySQL version. But in case it is not returned we should display an error msg like “requried information is not returned by the server – cannot initialize connection”

[peterlaursen]

1) it is working for us without any need for clicking with the mouse. Please detail!

2) Identifiers in MySQL can be up to 64 chars long. Please tell MySQL version and tell what exactly you enter that returns the error 'incorrect table name'.

MySQL docs: http://dev.mysql.com/doc/refman/5.1/en/identifiers.html

[Author]

Posts