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 ...Timeoute error when trying to delete PortalTimeoute error when trying to delete Portal
Previous
 
Next
New Post
2/24/2016 1:03 PM
 

I'm not using the site log data for anything. Actually, I didn't even know about its existence until now that I'm running into these issue and you guys mentioned it. 

How do I turn off the sitelog data? I checked under Host Settings and I only get the option to store sitelog data on the database or file system as pictured below:

Each of my portals has the Site Log History (days) setting set to 365. Should I change this to 0? Picture below:

Would running "truncate table sitelog" from the host/sql page timeout with the same error due to the huge number of records on that table? I'm guessing it will take a few minutes to clear that table. Would it be better to run "truncate" through SQL Management Studio instead? Is that possible?

 
New Post
2/24/2016 1:45 PM
 

So you have the "host" settings off, that turns it off for any NEW portals, but the existing ones need updated, set 365 to 0.

It won't matter where you run truncate, it will fly, it basically ditches everything in that table, quickly.


Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
2/24/2016 2:16 PM
 

That worked! After turning off site log history for all the portals and truncating the sitelog table, I tried to delete the Portal again and it worked. I didn't get the error message and the portal got deleted. Thanks so much for your help!

 
New Post
2/24/2016 5:41 PM
 
Glad that was it, simple fixes are always better :D

Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
2/24/2016 5:54 PM
 
if you want to clear everything from sitelog table, use "TRUNCATE TABLE SiteLog".
if you just want to delete items for a single website, use "DELETE FROM SiteLog WHERE PortalID = 7" (or whatever the PortalID is).

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Timeoute error when trying to delete PortalTimeoute error when trying to delete Portal


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