? orus casino? bodog? ruleta? luckia? betano? sportium? spin casino? stakes? 3 reyes? 888? lottoland? coolbet? 777 casino? gana777? betfair? bwin? yak casino? ivy casino? oddschecker? red casino? netbet? william hill? vip casino? rey casino? marathonbet? dafabet? sol casino? 1bet? winland? bet777? parimatch? 18bet? 888casino? campobet? mostbet? ganabet? rushbet? betcris? betsson? lucky? novibet? winner? winpot? betmaster? betmexico? cancun? playcity? strendus? pokerstars? codere? caliente? fun88? bbrbet? 1win? 10bet? betway? pin up? spinbet? 7cslot? pickwin? spin bet? mr fortune? w88? pragmatic? gamdom? crasher? jojobet? betmex? bcasino? foliatti? winner mx? bets 10? big bola? bet master? inbet? 7slots? lucky day? m777? mexplay? luckydays? bet caliente? 1x? plinko

   aderson@dnnhero.com   |      1-855-DNN-HERO

Forum

Forum


HomeHomePremiumPremiumAdministrationAdministrationDatabase clean up & reduce in sizeDatabase clean up & reduce in size
Previous
 
Next
New Post
7/28/2015 5:57 AM
 
John
No Ranking

Joined: 12/14/2011
Posts: 13

HI Aderson

We're trying to clean up a DNN741 database with 6600 spam users, and truncate log files. Your cleanup script isnt working - it gives us this error...

" Cannot truncate table 'EventLog' because it is being referenced by a FOREIGN KEY constraint. exec dnnHeroCleanUp"

My server team have set the database to simple, but it still wont run..
Please can you suggest something?

Thanks

John / Jane
 
New Post
7/28/2015 6:41 AM
 
Aderson Oliveira
1st Level Poster

Joined: 12/28/2009
Posts: 1011

Hi John/Jane,

DNN 7.4 brought many changes to the Log tables. The script is not ready for that. I would have to look and investigate. Not sure when I can do that though. 

In the meantime you can check these 2 links which may give you insights into the recent changes.

http://www.dnnsoftware.com/community-...

http://www.dnnsoftware.com/community-...

Best regards,

Aderson
 
 Page 1 of 1
Previous
 
Next
HomeHomePremiumPremiumAdministrationAdministrationDatabase clean up & reduce in sizeDatabase clean up & reduce in size



Try FREE
30 days money back guaranteed


About Us
The Cape
The Cape

This is Aderson Oliveira and I'm the Chief Editor of DNNHero. First why "DNNHero". If you think I'm just a self-indulgent individual, maybe you are right :). But this was not the case. This came from a good friend of mine, Carole Martin. Back then we were working on many DNN projects together and whenever she was having a problem she used to say that she needed her "DNN Hero" referring to me. How nice! She even give me a super hero cape!

So when I decided to start recording my learning adventures on DNN, I went to check if the domain "DNNHero.com" was available. It was, so here we are.

Back in 2010 I have decided to focus my time and efforts on spreading the word about CMS platforms, DNN in particular .

I hope you enjoy DNNHero and please feel free to send me your feedback.

Contact Us
*
*
Captcha:
Copyright 2010-2026 by Wayout Corp. | Privacy Statement | Terms Of Use | Google | Aderson | The SoloCoder Podcast