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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Cleaning up asp_applications table rows (and related data)Cleaning up asp_applications table rows (and related data)
Previous
 
Next
New Post
7/26/2006 8:45 AM
 

Hi

I have two entirely separate DNN 4.3.3 installations (each with different portals on them) and I’m analysing/comparing the aspnet_Applications tables for both these installations.

In the aspnet_applications I appear to get conflicting row data between portals:

* In the first DNN installation (which I regard as a pretty clean installation) the asp_applications table only has one row with an applicationname of “DotNetNuke”.

* In the second entirely seperate DNN installation (which is an upgrade from 4.0.3 to 4.3.3), not only is there a “DotNetNuke” row the asp_applications table, but there are also rows with applicationnames corresponding to table dnn_Portals.PortalID, and there are additional rows with applicationsnames: “-1”, “0”, and “1”.

Does this mean in the second DNN installation I can clean up by wiping out all the rows in the asp_applications table (and values in related tables) except the row “DotNetNuke”?

Note both DNN installations correctly list the portals in the dnn_portals table.

Many thanks...

Alex



Alex Shirley


 
New Post
7/26/2006 5:20 PM
 

OK with the second portal I've deleted all the applications rows in aspnet_application table except row "DotNetNuke". Everything seems OK!
I now notice that there are similar tables without the asp_ prefix in the database.
I guess these are replacement tables doing a similar thing?

So my next radical question is.... Can we drop all tables beginning with asp_ now?

Cheers

Alex

p.s. I wonder if I'm in the right forum for this?



Alex Shirley


 
New Post
8/3/2006 6:18 PM
 

Ok a rather silly post on my part. The main DNN documentation on the main download site has a lot to say about these tables. I ended up having to restore most of the rows I deleted. So ignore my previous post!!!!

I still have plenty of questions though about about how users are treated in DNN, at first I thought it was odd behaviour but it appears this is quite normal. See this post.

http://dotnetnuke.com/Community/ForumsDotNetNuke/tabid/795/forumid/108/threadid/59009/scope/posts/Default.aspx

Cheers

Alex

 



Alex Shirley


 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Cleaning up asp_applications table rows (and related data)Cleaning up asp_applications table rows (and related data)


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