I have two SELMGR entries, both for FEAT_Main, none for FEAT_NewSql, so I assume they are for the two files updated in the MSP. This is true regardless of wether I run with REINSTALL=ALL or have the SQL component referenced in the patchfamily. However, looking through the verbose log, I found these lines:
MSI (s) (64:94) [09:47:00:953]: Feature: FEAT_Main; Installed: Local; Request: Reinstall; Action: Reinstall MSI (s) (64:94) [09:47:00:953]: Feature: FEAT_NEWSQL; Installed: Absent; Request: Null; Action: Null Indeed, it seems that the feat_newsql is ignored even though I've set REINSTALL=ALL on the command line and even though the feature is coded like this: <Feature Id="FEAT_NEWSQL" Title="SQL Scripts" Level="1" AllowAdvertise="no" Absent="disallow"> <ComponentRef Id="DatabaseUpdate" /> </Feature> What is making my MSP ignore the feature and how can I force it to install when the MSP is run? Regards /Tobias Dersén On Mon, Mar 28, 2011 at 6:39 PM, Wilson, Phil <phil.wil...@invensys.com>wrote: > If you have a verbose log, are there any SELMGR entries in it? > > Phil Wilson > > -----Original Message----- > From: Tobberoth [mailto:tobber...@gmail.com] > Sent: Monday, March 28, 2011 8:50 AM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Sql component ignored during msp install > > I can find no mention of the component at all in the log. However I have > noticed some oddities with the feature itself. If I just run the MSP as > usual and click repair, the log will mention the new SQL feature in both > PublishFeature and the property ADDLOCAL. However, if I use REINSTALL=ALL, > there won't be any ADDLOCAL mentioned in the log, and the Property(S) > REINSTALL will be pointing only to the main feature, and the Property(C) > REINSTALL will point to ALL. Which means, if I use REINSTALL=ALL, the new > feature is only mentioned in PublishFeatures. Assuming the issue is indeed > that the feature is being skipped, even if I run with REINSTALL=ALL, how > can > I force it to be installed? I've already set the feature to > AllowAdvertise="no" and Absent="disallow". Level is set to 1. > > (Since the component and even whole feature is not part of the original > install, I assume it can't have anything to do with being up-to-date or > not) > > Regards > /Tobias Dersén > > On Sat, Mar 26, 2011 at 9:00 PM, Rob Mensching <r...@robmensching.com> > wrote: > > > You need to get the Component with your SQL content to be repaired. I > > expect > > the log file is saying the Component is being skipped because it is > already > > up to date. You may need to explicitly set the ADDLOCAL property to force > > your Component to install (IIRC). > > > > On Wed, Mar 23, 2011 at 6:16 AM, Tobberoth <tobber...@gmail.com> wrote: > > > > > Hello, > > > > > > I'm currently working on a system to deliver updates to a web > application > > > as > > > windows installers, both major and minor upgrades. I've gotten major > > > upgrades to work like I want them, but I can't seem to wrap my head > > around > > > minor upgrades. > > > > > > I've made a .msp which correctly updates files, but I also need it to > run > > > sql scripts on a database. While I've gotten this to work in .msis, it > > > seems > > > to be ignored in my .msps. I've added a User element, a Database > element > > > and > > > a SqlString element in the "new" installer, and I have a componentref > to > > > the > > > component with the SqlString in the patch family of the patch file. > When > > > using repair on the .msp, it works fine, but the sqlstring isn't run on > > the > > > database. Looking at the log, the sql component isn't even mentioned. > The > > > feature containing the sql component is published, but that's about it. > > > > > > I've tried adding a <CreateFolder/> element to the sql component which > > made > > > AllowRemoval non-usable, but it had no effect otherwise. Both > > > ExecuteOnInstall and ExecuteOnReinstall is set to "yes". > > > > > > What do I need to do to have the sql run properly? > > > > > > Regards > > > /Tobberoth > > > > > > > > > ------------------------------------------------------------------------------ > > > Enable your software for Intel(R) Active Management Technology to meet > > the > > > growing manageability and security demands of your customers. > Businesses > > > are taking advantage of Intel(R) vPro (TM) technology - will your > > software > > > be a part of the solution? Download the Intel(R) Manageability Checker > > > today! http://p.sf.net/sfu/intel-dev2devmar > > > _______________________________________________ > > > WiX-users mailing list > > > WiX-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > > > > > > > > -- > > virtually, Rob Mensching - > > http://RobMensching.com<http://robmensching.com/>LLC > > > > > ------------------------------------------------------------------------------ > > Enable your software for Intel(R) Active Management Technology to meet > the > > growing manageability and security demands of your customers. Businesses > > are taking advantage of Intel(R) vPro (TM) technology - will your > software > > be a part of the solution? Download the Intel(R) Manageability Checker > > today! http://p.sf.net/sfu/intel-dev2devmar > > _______________________________________________ > > WiX-users mailing list > > WiX-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > ------------------------------------------------------------------------------ > Create and publish websites with WebMatrix > Use the most popular FREE web apps or write code yourself; > WebMatrix provides all the features you need to develop and publish > your website. http://p.sf.net/sfu/ms-webmatrix-sf > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > *** Confidentiality Notice: This e-mail, including any associated or > attached files, is intended solely for the individual or entity to which it > is addressed. This e-mail is confidential and may well also be legally > privileged. If you have received it in error, you are on notice of its > status. Please notify the sender immediately by reply e-mail and then delete > this message from your system. Please do not copy it or use it for any > purposes, or disclose its contents to any other person. This email comes > from a division of the Invensys Group, owned by Invensys plc, which is a > company registered in England and Wales with its registered office at 3rd > Floor, 40 Grosvenor Place, London, SW1X 7AW (Registered number 166023). For > a list of European legal entities within the Invensys Group, please go to > http://www.invensys.com/legal/default.asp?top_nav_id=77&nav_id=80&prev_id=77 > . > > You may contact Invensys plc on +44 (0)20 3155 1200 or e-mail > recept...@invensys.com. This e-mail and any attachments thereto may be > subject to the terms of any agreements between Invensys (and/or its > subsidiaries and affiliates) and the recipient (and/or its subsidiaries and > affiliates). > > > > > ------------------------------------------------------------------------------ > Create and publish websites with WebMatrix > Use the most popular FREE web apps or write code yourself; > WebMatrix provides all the features you need to develop and publish > your website. http://p.sf.net/sfu/ms-webmatrix-sf > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
