Bug #9366 Connecting to MySQL 3.x database fails to display error
Submitted: 23 Mar 2005 18:33 Modified: 20 Apr 2005 16:10
Reporter: a.h.s. boy Email Updates:
Status: Closed Impact on me:
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.0.6-beta OS:MacOS (OS X 10.3.8)
Assigned to: Alfredo Kojima CPU Architecture:Any

[23 Mar 2005 18:33] a.h.s. boy
Trying to use MySQL Administrator with a MySQL 3.x database fails to display an error explaining that it doesn't work with 3.x servers. It fails with a syntax error concerning the "interactive_timeout" value (which doesn't exist in 3.x). This was reported originally as bug #8981.

[I tried to add a comment to 8981 to explain this, but my comment disappears into the ether. Clicking "Add Comment" takes me to the "Edit Submission" page(!), and if I submit that form, I get a "You can't edit a bug that has been marked closed. What you can do, is add a comment and if that is relevant, the MySQL Team will re-open the bug." message. Although the bug is marked as "Can't repeat", not "Closed". This is a bug in the bug-tracking system, as far as I can tell.]

How to repeat:
Try to connect to a 3.x server with MySQL Administrator

Suggested fix:
Determine the MySQL server version before attempting to access the "interactive_timeout" setting, and display the error before executing the invalid SQL query.
[24 Mar 2005 3:49] Jorge del Conde

From the manual:  "MySQL Administrator is designed to work with MySQL servers versions 4.0 and higher. "
[24 Mar 2005 5:51] a.h.s. boy
And from the manual:

"If you try to connect to an older server, an error  message will appear, telling you that this is not possible."

This message does not appear. Hence the bug.
[24 Mar 2005 5:56] Jorge del Conde
Thanks for the bug report.  I just marked it as verified.
[20 Apr 2005 16:10] Alfredo Kojima
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at