Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...4.5.2 Leaves stuff in DB when module install fails4.5.2 Leaves stuff in DB when module install fails
Previous
 
Next
New Post
5/31/2007 3:36 PM
 

I posted a problem about most modules failing their install on a new installation.

Now I find in the DB, despite these failures, all the various tables and such for these modules -- all the forum tables, repository tables, etc. I'd guess I'll find sprocs as well.

All installs really should be transacted, should they not?  On failure, there should be nothing left of any changes made (in the DB, web.config or anyplace else).

Either that, or they must be able to detect and incomplete install and be able to undo it, fix it or whatever. Is that what they do, or should I expect to have to restart my install (in addition to whatever action is necessary to fix failures of module install)?

Note: In case you haven't seen my other post, almost all modules fail to install, including the basic "HTML" module, and thus I can not get past that install page.

 
New Post
6/1/2007 10:44 AM
 

I would agree that it would be a "good" idea to wrap the SQL Data Provider statements in a transaction, however, there would need to be a lot of thought going into it as to the issues that might occur if changes are partially rolled back.

Typically on a module uninstall modules have an uninstall.sqldataprovider file that removes all created objects.  This should help finish the cleanup.


-Mitchel Sellers
Microsoft MVP, ASPInsider, DNN MVP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
 
New Post
6/6/2007 10:26 AM
 

I think I may not have been clear enough -- first off, these modules are the ones included with the distribution, and are presumably up to standards for uninstall. Secondly, as stated, these modules failed their installs, and left behind all kinds of database objects.  It is impossible to uninstall them, because they never completed install!

Really, there is very little, if any thought, needed -- when adding database objects, all such should be done in a single transaction (there are possibly exceptions, but based on the objects I see, this should not be a problem). If a SQL Server transaction were used, then any technical failure, such as occurred here, would result in no effect on the database as the transaction would never be committed.

I am not talking about partial rollbacks -- you start a transaction, add all the database objects, then commit. If it fails, you rollback. If it REALLY fails, you at least have the uncommitted transaction, and no affect on the committed database.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...4.5.2 Leaves stuff in DB when module install fails4.5.2 Leaves stuff in DB when module install fails


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out