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 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
