Need
DNN Support
?
DeskPal.com
Learn DNN / DotNetNuke
Login
Subscribe to DNNCreative
Home
Subscribe
Training & Tutorials
Tutorials for Beginners
Tutorials for Administrators
Tutorials for Core Modules
Tutorials for Advanced Users
How to Build a Website in DotNetNuke
Skinning Tutorials
Module Development
Third Party Modules
Forum
Search
Search
Home
Subscribe
+
Training & Tutorials
Tutorials for Beginners
Tutorials for Administrators
Tutorials for Core Modules
Tutorials for Advanced Users
How to Build a Website in DotNetNuke
Skinning Tutorials
Module Development
Third Party Modules
Forum
You need to
Register
for free and
Login
to post a message in the forum.
Forum
Forums
Search Forum
Search
Advanced Search
Topics
Posts
Unanswered
Active Topics
Forums
>
DotNetNuke®
>
DotNetNuke® Questions
truncating event log in dnn 7.4
Last Post 10/14/2015 9:38 PM by
Bo
. 2 Replies.
Sort:
Oldest First
Most Recent First
Check this box to subscribe to this topic.
Prev
Next
You are not authorized to post a reply.
Author
Messages
Bo
Nuke Master
Posts:215
10/13/2015 12:34 AM
Hello There:
I have been struggling over trying to get a sql script to work that sebstian one of the DNN guru's from Germany provided a while back. I am sending this inquiry to you because I feel you might be quicker at getting back to me than the other dnn guys and might have a useful answer.
Basically what happened was this. When DNN 7.4 came out for what ever reason the eventlog table was split into three joined by foreign keys so of course no longer can you do a simple truncate command so this Sebastian came up with an sql script that was suppose to work.
Upon testing it out I kept getting syntax errors. I replaced the obect qualifier with nothing and the database owner with dbo since that is how it showed up in my web.config file.
I tried everything leaving the braces in than taking the braces out and while monkeying a bit with the script file I got a lot of the red underlines off still there were unsolvable problems at least from my standpoint.
I didn't know if you could look at this sql file and tell me or perhaps even send me a sql script that would be fail proof for this purpose. I guess it is a fairly complex script that has to be used but no matter what I try to do I just can't seem to get it to work via sql server 2012.
Even if you could provide me with some kind of delete script that would delete x number of rows from the top that would at least be better than having to go through the steps of editing the top 2000 rows and than clicking on the first row and scrolling down to the last, holding down shift and clicking again.
Even if it was a script where you could change the number from 100 or perhaps 1000 etc... where it wouldn't cough I chose too many rows that weren't there.
At any rate the main point is if you could look at this script sabastian supplied and give me some ideas as to why it is failing syntactically with sql server 2012.
Thanks,
Bo
Joseph Craig
DNN MVP
Posts:11667
10/13/2015 10:54 AM
I'll assume that you don't use an Object Qualifier:
1. Start with Sebastian's script.
2. Replace {databaseOwner} with nothing.
3. Replace {objectQualifier} with nothing.
4. Paste the script into the appropriate box on the Host, SQL page, check the Run as Script checkbox, and then click the button to run the script.
(Please note that I am doing this from memory, and haven't tested what I just wrote.)
Joe Craig,
Patapsco Research Group
Complete DNN Support
Bo
Nuke Master
Posts:215
10/14/2015 9:38 PM
I got it to work as I was able to chat back and forth with sebastian but it was a tuff but after a bunch of back and forth I got it to work thanks though.
You are not authorized to post a reply.
Special Bonuses
--Subscriber Bonuses
--Readers Offers
Users Lounge
--Announcements
--DNN Creative Articles
--Everything Else
--Feedback, Suggestions and More
--Membership
--Site Review Please!
--Testimonials
--Podcasts
DotNetNuke®
--DotNetNuke® Questions
--Modules
--Modules - What's needed?
--Quick Tips
Hosting
--DotNetNuke® Hosting Providers
Skinning Toolkit
--Skinning Toolkit
UK DotNetNuke User Group
Forums
>
DotNetNuke®
>
DotNetNuke® Questions
Latest Forum Posts
Can you Run Xcode in Linux?
by Aman Singh
Can you Run Xcode in Linux?
Can you Run Xcode in Linux?
by Aman Singh
Can you Run Xcode in Linux?
Billed for subscription that was canceled
by Ryan
I was just billed for a subscription that was canc eled / inactivetive how do I get a refund for th
Meta Title and Meta Description are not showing properly
by DNN User
Hi, On my site the meta title and meta descriptions are not showing properly. It's showing the m
Search is not functioning properly
by DNN User
Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea
Search is not functioning properly
by DNN User
Site: https://www.prv-engineering.co.uk/search If I search any item only the 1st option under sea
DNN Platform import site optio
by Melanie Weaver
Is it possible to import site template in DNN Platform 8.0? We have internal Evoq Content 8.1 tha
Events Module for DNN V5?
by Tugboat
Would anyone have a download link for the version 5.0.3 Events Module? Thanks!
"Ghost" TabID Number?
by Tugboat
Hi! I have a portal instance with multiple child portals and on one of the child portals, there i
RE: DNN Load Testing
by ayman sharkawy
Hi. Have you already implemented a site using the DNN . And how the performance of the site and its
Publish All Pages
by NSUOK
I'm using DNN Evoq Content Basic 8.2.0. When I make the HTML Pro module display on all pages, I h
Simpler profile needed in 9.2.2
by Donald
We are upgrading a DNN 4.8.4 site to DNN 9.2.2. On 4.8.4, the top bar shows the user’s name. If yo
How to link from dnnmodal popup to web site page?
by Donald
Hello all. I am using a dnnmodal.show popup. The popup works correctly, showing the content that I
RE: Document Collaboration
by Nick Davern
That feature would be super beneficial for our needs as well! Does anyone have an update as to if th
RE: DNN 9.2, how to set default theme?
by Andy Stephenson DNN Creative
you do that under "Manage/Themes". Note the highlight blue border around the default container and d
DNN 9.2, how to set default theme?
by Donald
Please disregard, found Manage Themes I cannot find how to set a default portal theme in DNN 9.2
RE: Looking for DataSprings Dynamic Forms
by Andy Stephenson DNN Creative
Your best chance would be to contact Chad Nash @ http://www.datasprings.com/
Looking for DataSprings Dynamic Forms
by Jakir HM
Looking for DataSprings Dynamic Forms 3.4 for DNN 4.x 5.x for my site (https://themasters2018s.com/)
RE: Help with Cycle Image Carousel not displaying images
by peter
I had the same problem with the Will Strohl Content Slider after upgrading to DNN 9.1 The above an
RE: Object reference not set to an instance of an object
by Andy Stephenson DNN Creative
Check this one might be useful: http://www.dnnsoftware.com/answers/im-tryin-to-move-my-site-to-pr
Used
By
Testimonials