Hi
I am using DNN 9.3.2 I have 205,000+ DNN admin log entries. I am trying to clear all these errors from my DNN website.
1) I tried "Manage > Admin Logs > Clear Logs" option. It is running. But it is not clearing any records. 2) Then I tried to run the following SQL scripts via SQL Console.
TRUNCATE TABLE {databaseOwner}{objectQualifier}sitelog TRUNCATE TABLE {databaseOwner}{objectQualifier}eventlog TRUNCATE TABLE {databaseOwner}{objectQualifier}schedulehistory But I am getting the following error. "Cannot truncate table 'dbo.eventlog' because it is being referenced by a FOREIGN KEY constraint. TRUNCATE TABLE dbo.sitelog TRUNCATE TABLE dbo.eventlog TRUNCATE TABLE dbo.schedulehistory"
Please, advise me on how can I clear all these errors and entries?
Yma,
this should help you: https://www.dnnsoftware.c...-eventlog-in-dnn-740
Happy DNNing! Michael
Michael TobischDNN★MVP
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.