Forums / General Questions / WARNING: The Admin Activity Log table has over 50,000 records and should be archived

WARNING: The Admin Activity Log table has over 50,000 records and should be archived

Views: 1,968

Results 1 to 5 of 5
1 Jul 2015, 7:36 PM
#1
okieannie avatar

okieannie

New Zenner

Join Date:
Feb 2008
Location:
Earlsboro, OK
Posts:
15
Plugin Contributions:
0

WARNING: The Admin Activity Log table has over 50,000 records and should be archived

I am receiving this error message:
WARNING: The Admin Activity Log table has over 50,000 records and should be archived to conserve space ... 51420

Will resetting the admin activity log do any damage to the website?

Ann

1 Jul 2015, 10:45 PM
#2
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: WARNING: The Admin Activity Log table has over 50,000 records and should be archived

No damage will be done! Your admin is just letting you know that the activity_log table in the database should be reset to cut down on the database size.

First, use the top portion of Admin Access Management->Admin Activity Logs to save the current log contents. I'd suggest choosing "All log data" from the first dropdown (new in Zen Cart v1.5.4!) and the CSV file format from the 2nd one, leave the filename as the default and then either save the file to your admin's /backup folder or on your own computer.

Once the current contents are saved, use the "reset" button towards the bottom of that screen to reset the activity-log table itself.

13 Nov 2016, 8:25 PM
#3
alejas avatar

alejas

New Zenner

Join Date:
Feb 2012
Posts:
8
Plugin Contributions:
0

Re: WARNING: The Admin Activity Log table has over 50,000 records and should be archived

What does this actually delete? Surely not the actual records.

13 Nov 2016, 9:04 PM
#4
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,119
Plugin Contributions:
56

Re: WARNING: The Admin Activity Log table has over 50,000 records and should be archived

Yes, the actual records are deleted. That's why you need to "save" the information in either an CSV (my preference) or HTML prior to doing that reset.

13 Nov 2016, 10:03 PM
#5
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: WARNING: The Admin Activity Log table has over 50,000 records and should be archived

And by "actual records" what is deleted is the history of what has been done, not the order history, not the customer records, not your products, etc... just the data in the activity_log table.

By storing the data, you have something to which to reference if asked a question about the history of operations on the site whether for yourself or by others. By deleting the records then space is returned to the database to do other things and to free up resources.

ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...