Zen Cart Logo
Forums / General Questions / Admin Activity Log Marked as Crashed?

Admin Activity Log Marked as Crashed?

Locked

Views: 1,860

Results 1 to 14 of 14
This thread is locked. New replies are disabled.
13 Nov 2010, 6:52 PM
#1
frenchfry5725 avatar

frenchfry5725

New Zenner

Join Date:
Oct 2010
Posts:
10
Plugin Contributions:
0

Admin Activity Log Marked as Crashed?

Tried to Login in my admin and the page displays this:

145 Table './spokanee_root/admin_activity_log' is marked as crashed and should be repaired
in:
[insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '0', 'login.php ', '', '67.185.228.253')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

13 Nov 2010, 7:02 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Admin Activity Log Marked as Crashed?

Use your hosts provided tools to repair

Back up first

13 Nov 2010, 7:08 PM
#3
frenchfry5725 avatar

frenchfry5725

New Zenner

Join Date:
Oct 2010
Posts:
10
Plugin Contributions:
0

Re: Admin Activity Log Marked as Crashed?

Do I paste part of this in the database somewhere?

[insert into admin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '0', 'login.php ', '', '67.185.228.253')]

13 Nov 2010, 7:11 PM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Admin Activity Log Marked as Crashed?

Do I paste part of this in the database somewhere?
No....Just use your hosts account manager tools for mysql to repair the db

13 Nov 2010, 7:46 PM
#5
frenchfry5725 avatar

frenchfry5725

New Zenner

Join Date:
Oct 2010
Posts:
10
Plugin Contributions:
0

Re: Admin Activity Log Marked as Crashed?

Okay, so I backed up and did repair table on my cpanel in the sql panel.

It said the same errors for that line, but everything else checked out okay.

So I did the Check table and for the sames line it said "Table upgrade required. Please do "REPAIR TABLE admin_activity_log" to fix it!"

Any help? Sorry for being soo noobish. :)

13 Nov 2010, 7:57 PM
#6
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Admin Activity Log Marked as Crashed?

So I did the Check table and for the sames line it said "Table upgrade required. Please do "REPAIR TABLE admin_activity_log" to fix it!"
Have you upgraded the cart recently?
If so, that would have been information you should have provided

13 Nov 2010, 8:01 PM
#7
frenchfry5725 avatar

frenchfry5725

New Zenner

Join Date:
Oct 2010
Posts:
10
Plugin Contributions:
0

Re: Admin Activity Log Marked as Crashed?

No I have not. Would that probably be the be all to fix all?

13 Nov 2010, 8:04 PM
#8
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Admin Activity Log Marked as Crashed?

What version are you using?

13 Nov 2010, 8:10 PM
#9
frenchfry5725 avatar

frenchfry5725

New Zenner

Join Date:
Oct 2010
Posts:
10
Plugin Contributions:
0

Re: Admin Activity Log Marked as Crashed?

Version v1.3.9b

13 Nov 2010, 8:13 PM
#10
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Admin Activity Log Marked as Crashed?

Always backup first just in case

Using your cpanel > phpmyadmin > select your shop DB

Check if there is a prefix for your tables and if so edit the two highlighted lined adding the prefix

Run it in the sql tab in phpmyadmin
***** CODE REMOVED BY MODERATOR *****
*
This table just logs admin activity and is cleared when it becomes full through your admin
So you are only losing the history of admin activity

13 Nov 2010, 8:15 PM
#11
frenchfry5725 avatar

frenchfry5725

New Zenner

Join Date:
Oct 2010
Posts:
10
Plugin Contributions:
0

Re: Admin Activity Log Marked as Crashed?

Ok cool, Will try and post results. Would it be advisable to upgrade though as well?

13 Nov 2010, 8:20 PM
#12
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Admin Activity Log Marked as Crashed?

Would it be advisable to upgrade though as well?
Yes, as upgrading within the 1.3.9 series is only file changes

13 Nov 2010, 8:38 PM
#13
frenchfry5725 avatar

frenchfry5725

New Zenner

Join Date:
Oct 2010
Posts:
10
Plugin Contributions:
0

Re: Admin Activity Log Marked as Crashed?

It Worked! Thanks Kobra!

13 Nov 2010, 8:41 PM
#14
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Admin Activity Log Marked as Crashed?

It Worked!
Now start a regime of making a DB backup daily and saving 2-3-4 days worth on a rolling rotation