On May 28, 3:47 pm, Andrew Scott <[EMAIL PROTECTED]> wrote: > Cheers for your help, but when I ran that it timed out. And now it just > errors each and every time I try to run it. > > But when I look at the content archives they are still sitting there which > tells me that doesn't do what I want it to do. > > I could sit here and write a query to do the job myself, but I do not know > enough about the relationships in the tables to make the script or code to > do the job myself as yet.
To remove data from the audit table.. feel free to truncate the table completely. There are no relationships -- its a log only. With respect to archives, you can delete records from the dmArchive table using datetimecreated as the property to limit your deletes. The only purge option available is for stats -- if that times out then you have too many stats. My overall recommendation to folks who can't periodically prune the stats table, is to turn off stats completely and use your web logs or Google Analytics. Regards, -- geoff http://www.daemon.com.au/ PS. These community forums are not an appropriate place for emergency support -- the "developers" only peruse the forums when they have free time and generally in their own time. You might consider a commercial support contract to address priority issues. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
