User Activity plugin

Database Error Log Message

wrd2.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', '/jacques-le-jean/store/products/', '2011-05-11 18:50:20' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, Activity_Reports->user_activity

I tried deleting User Activity plugin through Admin deactivate, delete but I still have this error msg.

How do I fix?

Thanks.

  • DavidM

    Thanks for the additional information sdominique. The User Activity plugin does come with an additional sql.txt file which can be used in the event that the plugin's database tables don't get created for whatever reason. It seems like that's what's happened in your case.

    But I can't see a reason as to why the error message would occur after the plugin is totally deleted. Is that error continually occurring in your logs, or are there lots of occurrences of it?

  • Atlanta

    Is that error continually occurring in your logs, or are there lots of occurrences of it?
    Hi David, both.

    [12-May-2011 01:34:40] WordPress database error Table 'bizzable_wrd2.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', '/boutique/contact/', '2011-05-12 01:34:40' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, Activity_Reports->user_activity
    [12-May-2011 01:34:42] WordPress database error Table 'bizzable_wrd2.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', 'boutique/contact/', '2011-05-12 01:34:42' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, Activity_Reports->user_activity
    [12-May-2011 01:35:31] WordPress database error Table 'bizzable_wrd2.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', '/boutique/contact/', '2011-05-12 01:35:31' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, Activity_Reports->user_activity
    [12-May-2011 01:35:32] WordPress database error Table 'bizzable_wrd2.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', '/boutique/contact/', '2011-05-12 01:35:32' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, Activity_Reports->user_activity
    [12-May-2011 01:37:22] WordPress database error Table 'bizzable_wrd2.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', '/boutique/contact/', '2011-05-12 01:37:22' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, Activity_Reports->user_activity
    [12-May-2011 01:37:24] WordPress database error Table 'bizzable_wrd2.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', '/boutique/contact/', '2011-05-12 01:37:24' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, Activity_Reports->user_activity
    [12-May-2011 01:38:18] WordPress database error Table 'bizzable_wrd2.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', '/boutique/contact/', '2011-05-12 01:38:18' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, Activity_Reports->user_activity
    [12-May-2011 01:38:20] WordPress database error Table 'bizzable_wrd2.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', '/boutique/contact-/', '2011-05-12 01:38:20' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, Activity_Reports->user_activity
    [12-May-2011 01:42:51] WordPress database error Table 'bizzable_wrd2.wp_reports_user_activity' doesn't exist for query INSERT INTO wp_reports_user_activity (user_ID, location, date_time) VALUES ( '1', '/', '2011-05-12 01:42:51' ) made by require, require_once, include, get_footer, locate_template, load_template, require_once, wp_footer, do_action, call_user_func_array, Activity_Reports->user_activity

  • Vladislav

    Hello,

    Thank you very much for such detailed bug report, it helped a lot in figuring out what went wrong.

    The error message is not caused by "User Activity" plugin, but by "Reports" plugin. Therefore, disabling "User Activity" plugin had no effect on it.

    As David said, the error has to do with a missing database table. The "Repots" plugin comes with an "sql.txt" file too, which can be used to manually create the needed database tables if they didn't get autocreated for some reason. Can you please try executing the queries from that file on your database and see if it helps? Here is a tutorial on how to do that: https://premium.wpmudev.org/wpmu-and-buddypress-plugins/running-a-sql-code-on-your-wordpress-database/

  • Atlanta

    Thanks.

    Do I ignore this new error log msg, I assume that it is saying the sql.txt fix that I pasted tried to create a table that already existed?

    [18-May-2011 17:52:07] WordPress database error Table 'wp_sitecategories' already exists for query CREATE TABLE wp_sitecategories (
    cat_ID bigint(20) NOT NULL auto_increment,
    cat_name varchar(55) NOT NULL default '',
    category_nicename varchar(200) NOT NULL default '',
    last_updated timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    PRIMARY KEY (cat_ID),
    KEY category_nicename (category_nicename),
    KEY last_updated (last_updated)
    ); made by require_once, require_once, require_once, do_action, call_user_func_array, global_site_tags_make_current, global_site_tags_global_install

    wp-admin/error_log:
    KEY category_nicename (category_nicename),
    KEY last_updated (last_updated)
    ); made by include, do_action, call_user_func_array, global_site_tags_make_current, global_site_tags_global_install
    [18-May-2011 17:52:20] WordPress database error Table 'wp_sitecategories' already exists for query CREATE TABLE wp_sitecategories (
    cat_ID bigint(20) NOT NULL auto_increment,
    cat_name varchar(55) NOT NULL default '',
    category_nicename varchar(200) NOT NULL default '',
    last_updated timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    PRIMARY KEY (cat_ID),
    KEY category_nicename (category_nicename),
    KEY last_updated (last_updated)
    ); made by require_once, do_action, call_user_func_array, global_site_tags_make_current, global_site_tags_global_install
    [18-May-2011 18:02:10] WordPress database error Table 'wp_sitecategories' already exists for query CREATE TABLE wp_sitecategories (
    cat_ID bigint(20) NOT NULL auto_increment,
    cat_name varchar(55) NOT NULL default '',
    category_nicename varchar(200) NOT NULL default '',
    last_updated timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    PRIMARY KEY (cat_ID),
    KEY category_nicename (category_nicename),
    KEY last_updated (last_updated)
    ); made by include, do_action, call_user_func_array, global_site_tags_make_current, global_site_tags_global_install
    [18-May-2011 18:02:19] WordPress database error Table 'wp_sitecategories' already exists for query CREATE TABLE wp_sitecategories (
    cat_ID bigint(20) NOT NULL auto_increment,
    cat_name varchar(55) NOT NULL default '',
    category_nicename varchar(200) NOT NULL default '',
    last_updated timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    PRIMARY KEY (cat_ID),
    KEY category_nicename (category_nicename),
    KEY last_updated (last_updated)
    ); made by require_once, do_action, call_user_func_array, global_site_tags_make_current, global_site_tags_global_install

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.