Description:
Looking for alternatives to solve http://bugs.mysql.com/74369, I attempted a Customer package install to use the MySQL for Excel plugin directly from the Application subset and when I try to select the option I get an Unhandled Exception from the MySQL Installer with the following details:
************** Exception Text **************
System.FormatException: String was not recognized as a valid DateTime.
at System.DateTime.Parse(String s)
at WexInstaller.Core.Package.get_Published()
at WexInstaller.Wizards.AddProductsWizard.SelectProductsPage.productTree_AfterSelect(Object sender, TreeViewEventArgs e)
at System.Windows.Forms.TreeView.TvnSelected(NMTREEVIEW* nmtv)
at System.Windows.Forms.TreeView.WmNotify(Message& m)
at System.Windows.Forms.TreeView.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1026 (RTMGDR.030319-1000)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll
----------------------------------------
MySQLInstaller
Assembly Version: 1.4.2.0
Win32 Version: 1.4.2.0
CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Installer%20for%20Windows/MySQLInstaller.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1002 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1001 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1001 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.233 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
MySQLInstaller.Core
Assembly Version: 1.4.2.0
Win32 Version: 1.4.2.0
CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Installer%20for%20Windows/MySQLInstaller.Core.DLL
----------------------------------------
WindowsBase
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1015 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
System.Xml
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1026 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1015 (RTMGDR.030319-1000)
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
egkio1rt
Assembly Version: 1.4.2.0
Win32 Version: 4.0.30319.1001 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
s2gajkav
Assembly Version: 1.4.2.0
Win32 Version: 4.0.30319.1001 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
3tql40oj
Assembly Version: 1.4.2.0
Win32 Version: 4.0.30319.1001 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
fezfjg5n
Assembly Version: 1.4.2.0
Win32 Version: 4.0.30319.1001 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
sahfpcyi
Assembly Version: 1.4.2.0
Win32 Version: 4.0.30319.1001 built by: RTMGDR
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
Accessibility
Assembly Version: 4.0.0.0
Win32 Version: 4.0.30319.1 built by: RTMRel
CodeBase: file:///C:/windows/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
How to repeat:
- Uninstall any previous attempts or installs of MySQL for Excel, MS Installer.
- Install latest version of Visual Studio Tools for office 2010 64 bit from http://www.microsoft.com/en-us/download/details.aspx?id=44074.
- Download and install "MySQL for Windows Installer 5.6.21.1", Windows
Installer XML 3.6.3303.
- Choose "Custom" setup type and click Next.
- Under Available Products, drill down via Applications, MySQL for Excel, MySQL for Excel 1.3, MySQL for Excel 1.3.2 x64 (this is actually greyed out).
- Click on the greyed out reference and the error dialogue box appears.
- Click "Continue" to continue, and it takes you back to the Available Products screen.
- If I click under MySQL for Visual Studio and drill down, and mouse over on MySQL for Visual Studio 1.2.3, a red cross appears with the comment "1.2.3 has failing requirements: Visual Studio must be installed." This is not the case as we have the latest version of Visual Studio. (this would be another error)
Suggested fix:
- Allow MySQL Windows Installer to install the plugin, just like the workaround does.
- Workaround: to download the specific package from
http://dev.mysql.com/downloads/windows/excel/ and not use the Windows
Installer for Excel.