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 <[email protected]> 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 <[email protected]> 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
> > [email protected]
> > 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-users

Reply via email to