Bug #46835 Desktop/Menu icons missing for Administrator & Query Browser
Submitted: 20 Aug 2009 14:46 Modified: 4 Sep 2009 22:38
Reporter: Lamont Peterson Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL GUI Common Severity:S3 (Non-critical)
Version:1.2.17 OS:Windows (XP, but probably all)
Assigned to: CPU Architecture:Any
Tags: Administrator Query Browser

[20 Aug 2009 14:46] Lamont Peterson
Description:
This morning, I found that the application icons for MySQL Administrator and MySQL Query Browser on my office Windows XP notebook system were "missing".  The generic executable icon was being displayed on my desktop and in the toolbar.

When I clicked on "Change Icon" for the shortcut properties, I got an error dialog that says:  "Windows cannot find the file %SystemRoot%\Installer\{EC5616-blah-blah-blah-UUID-9AC3}\QBIcon.exe".  This happened for both applications.

Browsing to the actual binary (.exe) files for these applications allowed me to restore the proper icon, since they are embedded in the executable.

How to repeat:
1.  Install MySQL GUI Tools
2.  Wait for however many months it took for Windows to delete old Installer temp files on its own; I assume that you have to not run the installer nor the uninstaller for that entire time in order to run into these "disappearing" icons.

Suggested fix:
Since this is the normal way for application icons to be referenced on windows, I am requesting that the MSI installer(s) be fixed to configure the shortcuts to get the icon from the applications' .exe files, instead of the temporary copy that was installed under %SystemRoot%\Installer\.  My guess is that Windows did a little housecleaning and deleted old Installer temp files.
[21 Aug 2009 7:16] Susanne Ebrecht
Many thanks for writing a bug report.

We are on the way to implement full functionality of MySQL GUI Tools into MySQL Workbench.

More informations about Workbench you will find here:

http://dev.mysql.com/workbench/

We won't fix this anymore in the MySQL GUI Tools.

Btw. could it be that your icons disappear because there was a Windows message that there is unused software on your computer and asked you to clean the Desktop?

This Windows feature, when you click Clean Desktop, will delete all icons from none Microsoft Software from your computer.
[4 Sep 2009 22:38] Lamont Peterson
I can understand that since you (probably) won't have another release of the GUI Tools that you won't fix it there.

I also expect that you have the same "bug" in MySQL Workbench.

 "Btw. could it be that your icons disappear because there was a Windows
message that there is unused software on your computer and asked you to
clean the Desktop?"

No.  The icon wasn't removed from view.  The actual file with the image for the icon was deleted.  Your Installer configuration created the link file to reference the icon file at a location which was the temporary cache of the installer itself.  Since this is a component integrated into Windows (MSI installer or Windows Installer), I believe that the file was deleted when at some later point, the Microsoft Installer or some other "kill unused junk" thing decided to clear out old MSI cache files.

The correct way to fix this is to make sure that your links reference the icon within the relevant EXE file, instead of installing a copy of the icon file and then not using that.  I'm sure you want to fix this for Workbench, if the problem does exist there.

I didn't see any way when writing this report to indicate that it was a packaging/installer bug.  It's not a bug in the applications themselves.