MySQL Bugs: #6423: Edit Table Data is not enabled for Query Browser 1.1.0

Bug #6423	Edit Table Data is not enabled for Query Browser 1.1.0
Submitted:	4 Nov 2004 5:31	Modified:	4 Nov 2004 10:41
Reporter:	Marc Hodgins (Candidate Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.14	OS:	Windows (W2K)
Assigned to:		CPU Architecture:	Any

Description:
When uninstalling Query Browser 1.0 and installing Query Browser 1.1.0, "Edit Table Data" option is disabled when browsing tables.  MySQL Administrator doesn't see that Query Browser is installed.

How to repeat:
Uninstall Query Browser.  Install Query Browser 1.1.0-Gamma.  Open MySql Administrator, select Catalog, pick a schema and right-click on a table.  "Edit Table Data" is disabled.

Suggested fix:
Temporarily, renaming the Query Browser 1.1 path from C:\Program Files\MySQL\MySQL Query Browser 1.1\ to C:\Program Files\MySQL\MySQL Query Browser 1.0\ seems to solve the problem.

The path may be hardcoded somewhere in the code.  Maybe this should be specified in an XML file that Query Browser updates to point to itself when it is installed.

Another Temporary Fix,
this time involving the registry.

It appears MySQL Administrator looks for Query Browser on the following registry location:
HKEY_LOCAL_MACHINE\SOFTWARE\MySQL AB\MySQL Query Browser 1.0

The new Query Browser stores it information on key:
"MySQL Query Browser 1.1"

My temporary solution involves duplicating the keys using the registry editor (regedit). You could manually create the "Key" and "String Values" or follow the 2nd option below.

make a copy of:
"MySQL Query Browser 1.1"
to:
"MySQL Query Browser 1.0"

OPTION #2: Using export/import function of regedit.
1. Open the regestry editor (run: regedit)
2. Locate: HKEY_LOCAL_MACHINE\SOFTWARE\MySQL AB\MySQL Query Browser 1.1
3. Right-Click the key's name (MySQL Query Browser 1.1) and select Export.
4. Make sure the "selected branch" option is active and correct, type a filename and click Save.
5. Edit the file in notepad. On the key's name Replace "1.1" with "1.0". Leave Location/Version as is. And Save the file.
6. Run the file, and the new information would be added to registry.
7. Test MySQL Administrator.

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