Back tracking a Bit to help Phil Decode those "error massages" in his earlier response. Sorry if you feel barged in on Phil :)
2205: Database: [2]. Table does not exist: [3]. 2228: Database: [2]. Unknown table '[3]' in SQL query: [4]. Taken from: http://msdn.microsoft.com/en-us/library/aa372835(v=vs.85).aspx A hunch here: The old MSI Database Doesn't contain an ERROR Table. Select message from Error Where Error = x indicates 1 of 2 things: 1. You are using or building application that contains or updates an ERROR table, which doesn't contain an ERROR table in the Product in which you are upgrading. 2. The Old MSI you are upgrading Contains no Error table and the MSI you built is throwing one. In an attempt to display the error properly, the error index is set to x so that the message in row x can be written to the log, but because the Error Table doesn't exist in the older msi being upgraded, you get the errors in your log instead. See: http://msdn.microsoft.com/en-us/library/aa368554(v=vs.85).aspx 22 Removing older versions of this application... 23 Preparing to remove older versions of this application... 16 Time remaining: {[1] min }{[2] sec} 21 Gathering required information... In your case I would validate my hunch by saying that the Old MSI has no Error Table. Would you mind using Orca to compare the 2 MSI's and posting the results here? Carter Quoting Phil Wilson <[email protected]>: > If you've got a major upgrade element in your new product it should > work. It's not clear to me what those strange errors are around the > REP area in the log. I've never seen anything like that. It might be > the kind of error you get when your ProductCodes or UpgradeCodes are > not all uppercase, or the cached copy of the older MSI version isn't > available or is inaccessible for some reason. If you look for > FindRelatedProducts actions in the log you may see one that says > something about detecting the older versioned product. The version > values look ok - they are within the documented ranges, and you don't > need a major upgrade element in the older version - I'm not sure what > Pavan is getting at. You just need an UpgradeCode, ProductCode, > ProductVersion. > --------------- > Phil Wilson > > > On Tue, Apr 15, 2014 at 8:32 AM, Pavan Konduru > <[email protected]> wrote: >> Hi Jamie, >> >> The major upgrade section should have been present in the older >> product too for the current installer to upgrade it. >> >> --Pavan >> >> -----Original Message----- >> From: Jamie Hankins [mailto:[email protected]] >> Sent: Monday, April 14, 2014 8:57 PM >> To: [email protected] >> Subject: [WiX-users] Upgrade Doesn't Find Old Product >> >> I've been on this for a few hours now. I'm trying to write an >> upgrade. From what I understand, it should be as simple as adding >> a MajorUpgrade section with a DowngradeErrorMessage string, and >> having the same upgrade code. However, it just isn't working out >> that way. I can install the old product with the same name and >> same upgrade code, then install the new product, and it just >> ignores the old one. I've dug through the WindowsInstaller log, >> and nothing jumps out at me. It doesn't say anything about >> detecting the previous version. It does run >> RemoveExistingProducts:MSI (s) (00:C4) [20:25:10:060]: Doing >> action: RemoveExistingProductsMSI (s) (00:C4) [20:25:10:060]: Note: >> 1: 2205 2: 3: ActionText Action 20:25:10: RemoveExistingProducts. >> Removing applicationsAction start 20:25:10: >> RemoveExistingProducts.MSI (s) (00:C4) [20:25:10:060]: Note: 1: >> 2205 2: 3: Error MSI (s) (00:C4) [20:25:10:060]: Note: 1: 2228 2: >> 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 22 MSI >> (s) (00:C4) [20:25:10:060]: Note: 1: 2205 2: 3: Error MSI (s) >> (00:C4) [20:25:10:060]: Note: 1: 2228 2: 3: Error 4: SELECT >> `Message` FROM `Error` WHERE `Error` = 23 MSI (s) (00:C4) >> [20:25:10:060]: Note: 1: 2205 2: 3: Error MSI (s) (00:C4) >> [20:25:10:060]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM >> `Error` WHERE `Error` = 16 MSI (s) (00:C4) [20:25:10:060]: Note: 1: >> 2205 2: 3: Error MSI (s) (00:C4) [20:25:10:060]: Note: 1: 2228 2: >> 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 21 Action >> ended 20:25:10: RemoveExistingProducts. Return value 1. >> One hint is that the ProductVersion property of the old product is >> incorrectly formed. The person that did it wanted to use a date >> for the build number, so here is the old version number: >> "2.0005.043012". >> Could this be why upgrade isn't working? I'm using "2.49.1" for >> the new version. Still, if it doesn't detect the old one as being >> older, it should give me an error, not just ignore the old one, >> right? >> This is my first post here, so please let me know if I've violated >> any etiquette rules. :-) >> Jamie >> ------------------------------------------------------------------------------ >> Learn Graph Databases - Download FREE O'Reilly Book "Graph >> Databases" is the definitive new guide to graph databases and their >> applications. Written by three acclaimed leaders in the field, this >> first edition is now available. Download your free book today! >> http://p.sf.net/sfu/NeoTech >> _______________________________________________ >> WiX-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/wix-users >> >> >> >> ------------------------------------------------------------------------------ >> Learn Graph Databases - Download FREE O'Reilly Book >> "Graph Databases" is the definitive new guide to graph databases and their >> applications. Written by three acclaimed leaders in the field, >> this first edition is now available. Download your free book today! >> http://p.sf.net/sfu/NeoTech >> _______________________________________________ >> WiX-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------------ > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, > this first edition is now available. Download your free book today! > http://p.sf.net/sfu/NeoTech > _______________________________________________ > WiX-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ WiX-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/wix-users
