Bug #74370 Windows Installer, Custom install package for Applications install error
Submitted: 14 Oct 2014 8:16 Modified: 21 Nov 2014 23:18
Reporter: Keith Hollman Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL for Windows: Installer Severity:S2 (Serious)
Version:5.6.21 OS:Microsoft Windows (W7 W8)
Assigned to: CPU Architecture:Any

[14 Oct 2014 8:16] Keith Hollman
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.
[14 Oct 2014 13:40] Miguel Solorzano
Thank you for the bug report. I could repeat on Windows 8.1 (greyed option) however I could install on Windows 7.
[14 Oct 2014 14:30] Peter Laursen
Same error "String was not recognized as a valid DateTime" was also reported here. http://bugs.mysql.com/bug.php?id=74117 among others.
[5 Nov 2014 1:04] Jose Gabriel Valencia Ornelas
Posted by developer:
 
This bug is related to a problems with dates with a locale different tan US, already addressed in the bug http://bugs.mysql.com/bug.php?id=74117 (fixed)
[21 Nov 2014 23:18] Jose Gabriel Valencia Ornelas
This bug is related to a problems with dates with a locale different than US,
already addressed in the bug http://bugs.mysql.com/bug.php?id=74117 (fixed)