database error right after installing Blog Activity - Unknown column 'last_active'

I get the following error:

[30-Apr-2014 22:37:27] WordPress database error Unknown column 'last_active' in 'where clause' for query DELETE FROM uhooh03ma_comment_activity WHERE last_active < '1396219047' made by require_once('wp-admin/network/admin.php'), require_once('wp-admin/admin.php'), do_action('settings_page_blog_activity_main'), call_user_func_array, Blog_Activity->page_main_output, Blog_Activity->schedule_cron, Blog_Activity->cleanup

  • Rahul Verma
    • The Incredible Code Injector

    Hello,

    I hope you are well today and Thanks for posting on the forums.

    That's odd, it shouldn't be doing that.

    I've flagged one of our plugin developers here to see if they can provider their valuable input, thanks for your patience.

    Problem is that 'last_active' column doesn't exist in the table.

    Table Structure is as below :

    CREATE TABLE {$wpdb->base_prefix}comment_activity (
    active_ID bigint(20) unsigned NOT NULL auto_increment,
    blog_ID bigint(35) NOT NULL default '0',
    user_ID bigint(35) NOT NULL default '0',
    stamp bigint(35) NOT NULL default '0',
    PRIMARY KEY (
    active_ID)
    )

    Query which generating this error :

    $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->base_prefix}comment_activity WHERE last_active < '%d'", $month_ago ) );

    Best Regards
    Sandeep Kumar

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.