MySQL Bugs: #74173: Installation error: String was not recognised as a valid date time.

Bug #74173	Installation error: String was not recognised as a valid date time.
Submitted:	1 Oct 2014 8:12	Modified:	27 May 2015 23:53
Reporter:	Yulias Kurniawan	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL for Windows: Installer	Severity:	S3 (Non-critical)
Version:	5.6.21.1	OS:	Windows (Windows 7)
Assigned to:		CPU Architecture:	Any

Description:
If I set region and language (from control panel > region and language) on my PC to use some other languages beside of English (United States). When I select a product that I want to install an error occur: Unhandled Exception, String was not recognized as a valid Date Time.

How to repeat:
1. Set your language format to a language except English(united states). In my case the language is Indonesian. To change the language can be done from control panel > region and language.
2. Run the MySQL installer 
3. Click add button on the right
4. Choose the MySQL Servers on the available products choice
5. Error occur when I click the product I want to install inside MySQL Servers (that is MySQL Server 5.6.21 - x86)

Hello Yulias Kurniawan,

Thank you for the report.
In my case setting language to English(India) triggered similar error and installer hanged for some time(used mysql-installer-community-5.6.21.0.msi).

Thanks,
Umesh

Screenshot..

Attachment: 74173.png (image/png, text), 14.81 KiB.

This is actually a duplicate of what I reported on Sep27th http://bugs.mysql.com/bug.php?id=74117

Yes, this affects me and is now a showstopper - changing the data format to the US version DID work as a hack on a 32 bit platform, but failed on a 64 bit platform. Without a workround, this should be upgraded to critical.

I also have this problem, but unable to work around by changing timezone /date format. 64 win 7.  I can't install MySQL. Why is this not critcal please?

************** 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)

I have found a workround that seems to work on 32 bit Windows 8 (at least) and lets me get the server plus Workbench installed. Steps:
-Uninstall all MySQL products via the installer
-Run the installer
-Select ONLY the server
-Run to completion.
-Re start the installer
-Select MySQL workbench, but find the older version (6.1.7)
-Run to completion. This works OK.
The date format problem seems to be triggered when the Workbench 6.2 versions are selected.

I had same problem.
 Server installed fine but mysql workbench trows the same error that you had.
 Then I set short date format on 'yyyy-MM-dd' on region and language settings. It worked for me.

 International DateTime rules. :)

I also had the same problem and Nikola M's suggestion to change the short date format of my region (English Canada) to 'yyyy-MM-dd' worked for me.   Thanks Nikola!