MAKEMSI quickly and reliably creates MSI files in a non-programmatic way\Windows Installer BasicsReturn Codes and Error Codes or TextError Codes2228 - 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.

Please email me any feedback, additional information or corrections. See this page online (look for updates) MAKEMSI© is (C)opyright Dennis Bareis 2003-2008 (All rights reserved). Wednesday June 25 2008 at 7:16pm Visit MAKEMSI's Home Page