[wix-users] MSI database update at install time

[Hoover, Jacob]

Have a look at: http://www.joyofsetup.com/2007/07/01/semi-custom-actions/

Basically injecting rows at runtime (as opposed to changing existing ones).


-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Stephen Woolhead
Sent: Wednesday, November 11, 2015 4:41 PM
To: wix-users at lists.wixtoolset.org
Subject: [wix-users] MSI database update at install time

Hi, I writing a WiX extension and one of the steps I need my custom actions to do is update existing records in the MSI database at install time.


After a bit of research it appears that I can't use SQL UPDATE on permanent tables at install time. Blog posts I've seen [1] say that I need to delete and insert a new row, but when I try this I get the following errors:


Ready to execute delete query: DELETE FROM `IIsAppPool` WHERE `IIsAppPool`.`AppPool`='web_general_apppool'
Delete Query Executed Successfully
Ready to execute insert query: INSERT INTO `IIsAppPool` (`AppPool`, `Name`, `Component_`, `Attributes`, `User_`, `RecycleMinutes`, `RecycleRequests`, `RecycleTimes`, `IdleTimeout`, `QueueLimit`, `CPUMon`, `MaxProc`, `VirtualMemory`, `PrivateMemory`, `ManagedRuntimeVersion`, `ManagedPipelineMode`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) TEMPORARY Executing insert query...
MSI (s) (B8!D0) [22:33:20:906]: Database string pool is corrupted.
MSI (s) (B8!D0) [22:33:20:906]: Note: 1: 2259 2:  3:  4:
Exception Type: Microsoft.Deployment.WindowsInstaller.InstallerException


Is this possible or am I heading down a blind end?


Cheer,


Stephen.




[1]  http://windows-installer-xml-wix-toolset.687559.n2.nabble.com/Updating-msi-database-install-time-tp7587512p7587523.html


____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/