Description:
Upgrading an already installed version of MySQL for Excel (greater than 1.2.0) does not work at all, the only option is to uninstall the previous version and install the new one after uninstalling.
An error like the one below consistently appears upon upgrading. (The tests I did were upgrading from 1.3.0 > 1.3.1 and then from 1.3.1 > 1.3.2).
Name:
From: file:///C:/Program Files (x86)/MySQL/MySQL For Excel 1.3.1/MySQL.ForExcel.vsto
************** Exception Text **************
System.Deployment.Application.DeploymentDownloadException: Downloading file:///C:/Program Files (x86)/MySQL/MySQL For Excel 1.3.1/MySQL.ForExcel.vsto did not succeed. ---> System.Net.WebException: Could not find a part of the path 'C:\Program Files (x86)\MySQL\MySQL For Excel 1.3.1\MySQL.ForExcel.vsto'. ---> System.Net.WebException: Could not find a part of the path 'C:\Program Files (x86)\MySQL\MySQL For Excel 1.3.1\MySQL.ForExcel.vsto'. ---> System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Program Files (x86)\MySQL\MySQL For Excel 1.3.1\MySQL.ForExcel.vsto'.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync)
at System.Net.FileWebStream..ctor(FileWebRequest request, String path, FileMode mode, FileAccess access, FileShare sharing, Int32 length, Boolean async)
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
--- End of inner exception stack trace ---
at System.Net.FileWebResponse..ctor(FileWebRequest request, Uri uri, FileAccess access, Boolean asyncHint)
at System.Net.FileWebRequest.GetResponseCallback(Object state)
--- End of inner exception stack trace ---
at System.Net.FileWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.FileWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
--- End of inner exception stack trace ---
at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.GetManifests(TimeSpan timeout)
at Microsoft.VisualStudio.Tools.Applications.Deployment.ClickOnceAddInDeploymentManager.InstallAddIn()
How to repeat:
1. Install any version of MySQL for Excel greater or equals 1.2.1 and lesser than 1.3.2 (or make sure it is already installed)
2. Make sure it works in Excel after installation, close Excel.
3. Upgrade MySQL for Excel to a newer version (do not uninstall)
4. After the installation is finished, run Excel and open MySQL for Excel
5. Note an error like the one in the description is shown and the add-in is not accessible