MAKEMSI quickly and reliably creates MSI files in a non-programmatic way
Have your say! Join the MAKEMSI discussion list or view archive! Suggest improvements. No question too simple or too complex.
[Bottom][Contents][Prev]: 2213 - Database: [2]. Error saving database tables[Next]: 2262 - Stream does not exist: [2]. System error: [3]
Have your say! Join the MAKEMSI discussion list or view archive! Suggest improvements. No question too simple or too complex.
\->Windows Installer FAQ (the basics)->Return Codes and Error Codes or Text->Error Codes->2228 - Database: [2]. Unknown table '[3]' in SQL query: [4]

2228 - Database: [2]. Unknown table '[3]' in SQL query: [4]

This cryptic error code will be displayed by an install if a "required" table is missing (and possibly also if empty). It typically more of an "informational" message, but if its near the point of failure perhaps it is really a problem.

MAKEMSI tries to not create empty tables unless absolutely required making it much easier to examine the MSI, however sometimes the creation of one table may cause extra windows installer code to be invoked requiring a completely different table to be created (I have seen merge modules do this).

A message (with the format "Database: [2]. Unknown table '[3]' in SQL query: [4]") will be logged in any verbose log. Above this message you should find the missing table mentioned as well as the failing SQL statement (use the "TableCreate" command to create this table).

Missing tables can also cause 2205 and 2262 messages.

Example of Creating Tables Safely

<$TableCreate "Class"   ExistingOK="Y" DropExisting="N">
<$TableCreate "TypeLib" ExistingOK="Y" DropExisting="N">

The "ExistingOK" and "DropExisting" parameters were added for safety, we are doing this step because the tables don't exist however you may some time in the future add code which may create it and you would not want to lose its contents.


Microsoft awarded me an MVP (Most Valuable Professional award) in 2004, 2005, 2006, 2007, 2008 & 2009 for the Windows SDK (Windows Installer) area.Please email me any feedback, additional information or corrections.
See this page online (look for updates)

[Top][Contents][Prev]: 2213 - Database: [2]. Error saving database tables[Next]: 2262 - Stream does not exist: [2]. System error: [3]


MAKEMSI© is (C)opyright Dennis Bareis 2003-2008 (All rights reserved).
Sunday February 28 2016 at 3:45pm
Visit MAKEMSI's Home Page
Microsoft awarded me an MVP (Most Valuable Professional award) in 2004, 2005, 2006, 2007, 2008 & 2009 for the Windows SDK (Windows Installer) area.