[4 Aug 2009 11:09] Sai Fujiwara
I found a solution to this bug:
1,download and install orca, an editor to msi files.
2,open mysql5.135+ msi file and search "SetDateTime" and u will find a row,its target value is "CASetRegDateTime",delete this row and save(notice: don't use "save as",if use "save as",the msi file will be corrupted and u can't install)
3,double-click mysql msi file,the installation will go smoothly.
Reason:
In cmd mode, execute mysql msi installation with a log, "msiexec /i mysql.msi /lv a.txt".When the installation fails,open a.txt and search "return value 3".u will find the following:
Action start 17:31:02: SetDateTime.
MSI (s) (3C:80) [17:31:02:140]: Note: 1: 2235 2: 3: ExtendedType 4: SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM `CustomAction` WHERE `Action` = 'SetDateTime'
MSI (s) (3C:EC) [17:31:02:140]: Invoking remote custom action. DLL: D:\WINDOWS\Installer\MSIC4.tmp, Entrypoint: CASetRegDateTime
Action ended 17:31:02: SetDateTime. Return value 3.
it is the first "return value 3" in a.txt, so it is the problem causing the setup wizard end prematurely.So I use a msi editor(ocra) to delete "SetDateTime" action in mysql msi file and the installation can go smoothly.
because I don't know what this modification will bring to mysql,please don't use this method in production.
In my private test,I don't find any problems.My method can solve this installtaion's problem, but it is a big bug indeed, especially it has existed in mysql three versions and other mysql products such as .net connector 6.0's msi.
Wish the msi error log can help the real solution to this bug. the reason causing failure is the following:
Action start 17:31:02: SetDateTime.
MSI (s) (3C:80) [17:31:02:140]: Note: 1: 2235 2: 3: ExtendedType 4: SELECT `Action`,`Type`,`Source`,`Target`, NULL, `ExtendedType` FROM `CustomAction` WHERE `Action` = 'SetDateTime'
MSI (s) (3C:EC) [17:31:02:140]: Invoking remote custom action. DLL: D:\WINDOWS\Installer\MSIC4.tmp, Entrypoint: CASetRegDateTime
Action ended 17:31:02: SetDateTime. Return value 3.
https://bugs.mysql.com/bug.php?id=45418
