MySQL Bugs: #88034: Installer unable to find Visual Studio 2017

Bug #88034	Installer unable to find Visual Studio 2017
Submitted:	9 Oct 2017 23:55	Modified:	6 Dec 2017 22:32
Reporter:	Jose Ramirez Ruiz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: Installer	Severity:	S2 (Serious)
Version:	5.7.19	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
MySQL for Visual Studio can't be selected for installation in the "Available Products" list of "MySQL Installer". "MySQL Installer" is failing to recognize that Visual Studio 2017 is already installed.

How to repeat:
1. Execute "MySQL Installer" web/full in a clean environment where older versions of VS hasn't been installed in the past.
2. Click the "Add" button.
3. In the "Available Products" tree view locate the "MySQL for Visual Studio" product.

The product is grayed out with a "Has Failing Requirements - Visual Studio version 2012, 2013, 2015 or 2017 must be installed" message, however Visual Studio 2017 is installed.

https://bugs.mysql.com/bug.php?id=88138 marked as duplicate of this one.

Is there any workaround?

The workaround is to download the stand-alone MSI from https://dev.mysql.com/downloads/windows/visualstudio/ and install from the MSI.

Posted by developer:
 
Fixed a bug in the code that checks prerequisites in the Windows Registry that was happening only in 32-bit versions of Windows.
Changed the Visual Studio detection rules to check for the following registry keys:
  HKEY_CLASSES_ROOT\VisualStudio.DTE.9.0
  HKEY_CLASSES_ROOT\VisualStudio.DTE.10.0
  HKEY_CLASSES_ROOT\VisualStudio.DTE.12.0
  HKEY_CLASSES_ROOT\VisualStudio.DTE.12.0
  HKEY_CLASSES_ROOT\VisualStudio.DTE.14.0
  HKEY_CLASSES_ROOT\VisualStudio.DTE.15.0

Posted by developer:
 
Fixed on 1.4.21

Fixed as of the upcoming MySQL Installer 1.4.21 release, and here's the changelog entry:

MySQL for Visual Studio (32-bit) detection rules failed to locate
prerequisite software even when it was installed.

Thank you for the bug report.