MySQL Bugs: #4856: External exception when attempting to select Backup Schemata

Bug #4856	External exception when attempting to select Backup Schemata
Submitted:	2 Aug 2004 16:16	Modified:	8 Oct 2004 10:35
Reporter:	David Zebrowitz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.0.9	OS:	Windows (Windows 2000)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
This problem repeatably occurs when trying to configure a backup project in MySQL Administrator.  After a new project is created, any attempt to select a schemata causes an external exception to occur:  "External Exception C000001D"

I installed the latest release of MySQL Administrator and the problem still occurs.  After the message box pops up, I click OK, and the exception error repeatedly displays.  I have to kill the MySQL Administrator process in Task Manager.

How to repeat:
1. I click 'New Project', and type in a project name in the specified text box.
2. As soon as I click on a "schemata" or database in the list box, I receive a "MySQL Administrator Error" which reads: "The following Exception occurred:  External exception C000001D"
3. Clicking OK will only bring the same error again.  I have to kill the process.

This same error also occurs when clicking on a schemata when using the catalogs tool.

Thanks for reporting. Could you state which MySQL Server version you are using? I tried to verify this on Win2k and XP while being connected to 4.0.20a, 4.1.2, 5.0 and I was not able to repeat it.

Does the error occur the very moment you press the mousebutton? Do you have databases with special characters in the name, like Ä or ö ?

Thank you!

Thanks for reporting. Could you state which MySQL Server version you are   
     using?  I tried to verify this on Win2k and XP while being connected to 4.0.20a, 
     4.1.2, 5.0 and I was not able to repeat it.

----------------------------------------------------------------

I'm running MySQL 4.0.20d

Other Software versions running on the server:
- Windows 2000 Server w/SP4
- Microsoft .NET Framework 1.1
- Microsoft IE 6 SP1
- MySQL Control Center 0.9.4
- PHP 4.3.7

I first noticed this when I installed MySQL Administrator 1.0.7beta.  I later removed 1.0.7 and installed 1.0.9

Yes... the error occurs immediately when I click on a database name.  I'm not using any strange characters in the names.  For instance, one is myhelpdesk.  I have several other databases online, and I've followed the same type of naming conventions.  No special characters, spaces, etc... & all lowercase.

I wasn't able to repeat the bug you mention, but I did run into a bug which might be the cause of what you're experiencing.

How To Repeat:

Open a Backup project
Put a project name
open the mysql schemata
type 'm' in the Schemada box
open the tables in the mysql database
... it hangs in while 'Fetching Data...'

Also getting similar exception error whenever trying to access schemata under either Backups or Catalogues.

Scenario -- 2 Windows systems both running on my LAN:

#1. Windows 2000 Pro/sp4
MySQL 4.1.3b-beta-nt-max-log (just downgraded from 5.0.0)
MySQL Administrator 1.0.9 (just upgraded from 1.0.6)
PHP 5.0.0 (ext/mysqli is enabled -- old ext/mysql extension is not enabled)

#2. Windows 2000 Server/sp4
MySQL 5.0.1-alpha-nt-max-log (just upgraded from 5.0.0)
MySQL Administrator 1.0.9 (just upgraded from 1.0.1-alpha)
PHP 4.3.7

Problem occurs when trying to use MySQL Administrator on system #1 to access MySQL Server running on either system #1 or system #2. Problem does NOT occur when using MySQL Administrator on system #2 to access either MySQL Server.

MySQL Servers, other MySQL clients appear to be running fine on both systems.

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
    http://www.mysql.com/doc/en/Installing_source_tree.html