Hey Everyone,
I am new to using zencart and when working with the mysqlphp i accidently deleted the admin_activity_log. How can i restore this via manual input?
Mike
Results 1 to 7 of 7
-
10 Dec 2011, 11:15 PM #1
New Zenner
- Join Date
- Dec 2011
- Posts
- 1
- Plugin Contributions
- 0
I deleted the Admin Activity Log table
-
10 Dec 2011, 11:25 PM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: I deleted the Admin Activity Log table
If you're talking about the table CONTENTS, you'll need to restore from backup.
If you're talking about the whole table, it's also best to restore from backup.
You could optionally reconstruct it from the original /zc_install/sql/mysql_zencart.sql code, but that's still gonna result in lost data. Best to restore from backup.
You DO make regular backups of your database, right? And ESPECIALLY before you go mucking about with the raw database data ... right?.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
11 Dec 2011, 01:14 AM #3
Zen Follower
- Join Date
- Mar 2011
- Posts
- 364
- Plugin Contributions
- 0
Re: I deleted the Admin Activity Log table
Can you not just go into the install db and setup the table structure in phpmyadmin as it is in the install db? Do you really need data in there? I thought that data is just a log of admin activity and is regularly deleted anyways.
-
11 Dec 2011, 01:26 AM #4
Totally Zenned
- Join Date
- May 2010
- Location
- WA State
- Posts
- 1,678
- Plugin Contributions
- 3
Re: I deleted the Admin Activity Log table
The log of admin activity comes in very handy if you ever get hacked.
-
11 Dec 2011, 01:28 AM #5
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: I deleted the Admin Activity Log table
It's required for PCI compliance reasons, as an audit trail of who's been accessing what.
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
11 Dec 2011, 01:48 AM #6
Zen Follower
- Join Date
- Mar 2011
- Posts
- 364
- Plugin Contributions
- 0
Re: I deleted the Admin Activity Log table
So we should export it and save it for how long? Because that table does get big quick. TIA.
-
11 Dec 2011, 01:49 AM #7
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: I deleted the Admin Activity Log table
The "Implementation Guide" included with v1.5.0 (and newer) includes guidance on that topic.
I believe the recommendation is 12 months..
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
Reply With Quote
Similar Threads
-
v154 WARNING: The Admin Activity Log table has over 50,000 records and should be archived
By okieannie in forum General QuestionsReplies: 4Last Post: 13 Nov 2016, 11:03 PM -
WARNING: The Admin Activity Log table has over 50,000 records and should be cleaned .
By spretswell in forum General QuestionsReplies: 9Last Post: 27 Jul 2010, 09:54 PM -
Admin Activity Log table
By dealbyethan.com in forum General QuestionsReplies: 9Last Post: 20 Oct 2009, 08:50 PM -
WARNING: The Admin Activity Log table has records over 2 months old and...
By Agent_KGB in forum Customization from the AdminReplies: 1Last Post: 28 Mar 2009, 04:50 PM -
WARNING: Admin Activity Log table ?
By Kenada in forum Customization from the AdminReplies: 2Last Post: 22 Jan 2007, 06:30 PM
Bookmarks