Admin Activity Report [support thread]

[Steven300]

Thanks ccembd, I'm pleased you found it useful. You mentioned that the reset function doesn't work. Could you describe what happens? And does this happen for both pages?

[ccembd]

When I used the reset button actually nothing happened. It didn't reset. It successfully reset when I used the reset button in Tools: Store Manager. I verfied this by going back and opening the Admin Activity Log which I now have thanks to you.

Hope this helps,
Cat

[Steven300]

Yep it does help It's an interesting issue because the reset function has worked for others. I'm wondering whether it could be a database prefix problem. Anyway I'll have a proper look and see if I can figure out what might be wrong.

[Steven300]

Okay I think this might work.

In the following file:
admin/stats_admin_activity.php

Find:

$db->Execute("delete from " . TABLE_ADMIN_ACTIVITY_LOG);
$db->Execute("optimize table " . TABLE_ADMIN_ACTIVITY_LOG); 

Change to:

$db->Execute("delete from " . TABLE_ADMIN_ACTIVITY);
$db->Execute("optimize table " . TABLE_ADMIN_ACTIVITY); 

If it does work, you'll need to make the same change to:
admin/stats_admin_activity_all.php

Either way, let me know.

[Jinson]

I also had problems getting reset to work, here's how i fixed mine ->

-- Files --
admin/stats_admin_activity.php
admin/stats_admin_activity_all.php

Replaced the top part just after the include of application_top.php

// added by Jinson on 12th July 2008. Because this script was
// originally written expecting register globals to be on
$action = $_GET['action'];

switch($action) {

// clean out the admin_activity_log
    case 'clean_admin_activity_log':
      $db->Execute("delete from " . TABLE_ADMIN_ACTIVITY);
      $db->Execute("optimize table " . TABLE_ADMIN_ACTIVITY);
      $messageStack->add_session(SUCCESS_CLEAN_ADMIN_ACTIVITY_LOG, 'success');
      unset($_SESSION['reset_admin_activity_log']);
      zen_redirect(zen_href_link(stats_admin_activity));
    break;
    } // eof: action
unset($action); 

[Steven300]

Thanks Jinson, that's a big help.

Have you uploaded this change to the contributions area?

[Steven300]

Ok I have uploaded the suggested change.

Should be approved within the next couple of days.

Hopefully that's the end of the reset problems.