MySQL Bugs: #20091: MSI Error 1325 - File name is not a valid short file name

Bug #20091	MSI Error 1325 - File name is not a valid short file name
Submitted:	26 May 2006 15:32	Modified:	19 Jan 2008 19:29
Reporter:	Trevor White	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	3.51.1.12	OS:	Windows
Assigned to:	Georg Richter	CPU Architecture:	Any

Description:
When installing MySQL ODBC connector on some machines you get a MSI Error 1325 File name is not a valid short file name

How to repeat:
Install ODBC on Windows XP silently with an old MSI engine, although I cannot always seem to get this to go wrong every time, although the table should really be corrected.

Suggested fix:
The error happens because in the file table there are two enteries:
File - license, FileName - myodbc3-license.rtf 
File - exceptions, FileName - myodbc3-exceptions.rtf

The file table should be authored "ShortName|LongName" like the entry for myodbc3i.exe if correct these two enteries the problem goes away.

Apparently there is the same problem with MySQL Administrator as well, although I have not witnessed this:
http://forums.mysql.com/read.php?34,44212,44212#msg-44212

Hi Trevor, thanks for your bug report.
Verified as described by reporter with Orca validate function:
ICE03	ERROR	Invalid Filename; Table: File, Column: FileName, Key(s): license
ICE03	ERROR	Invalid Filename; Table: File, Column: FileName, Key(s): exceptions

Not sure if you are using Wix and I know that Wix v3 is not released yet but it has some nice features that can avoid these types of problems.  I've been using Wix v3 for connector/net now for nearly 6 months.

This has been fixed in Connector/ODBC 5.1. The installer is updated to WiX 3.