Support » Plugin: User Activity Log » WordPress database error Table doesn’t exist

  • Resolved spencemaan

    (@spencemaan)


    Our multisite is receiving numerous logs from 4 of our sites. All logs happen anytime the plugin page is visited or for any login/logout related action. Also no activity is being logged for these 4 sites.

    Abbreviated Error log:

    WordPress database error Table 'our_prefix.wp_7_ualp_user_activity' doesn't exist for query

    It seems that a database table doesn’t exist. It only happens of these four sites. I was going to deactivate and reactivate the plugin but I wanted contact support. The plugin is activated Network wide.

    Any recommended next steps or solutions? We aren’t updating WordPress or plugins for a variety of reasons. So I hope there can be an alternate solution.

    Also, if a click: Delete Log Activities -> Reset Database, does that delete the record just from the site in a multisite environment?

    WordPress: 4.9.8
    User Activity Log: 1.3.8

    Sample Log:

    [28-Oct-2019 15:46:45 UTC] WordPress database error Table 'our_prefix.wp_6_ualp_user_activity' doesn't exist for query SHOW FULL COLUMNS FROM wp_6_ualp_user_activity made by wp_signon, wp_authenticate, do_action('wp_login_failed'), WP_Hook->do_action, WP_Hook->apply_filters, ual_shook_wp_login_failed, ual_user_activity_add, QM_DB->query
    [28-Oct-2019 15:47:32 UTC] WordPress database error Table 'our_prefix.wp_7_ualp_user_activity' doesn't exist for query SHOW FULL COLUMNS FROM wp_7_ualp_user_activity made by wp_signon, wp_authenticate, do_action('wp_login_failed'), WP_Hook->do_action, WP_Hook->apply_filters, ual_shook_wp_login_failed, ual_user_activity_add, QM_DB->query
    [28-Oct-2019 15:47:55 UTC] WordPress database error Table 'our_prefix.wp_3_ualp_user_activity' doesn't exist for query SHOW FULL COLUMNS FROM wp_3_ualp_user_activity made by wp_signon, wp_authenticate, do_action('wp_login_failed'), WP_Hook->do_action, WP_Hook->apply_filters, ual_shook_wp_login_failed, ual_user_activity_add, QM_DB->query
    
    • This topic was modified 1 month, 1 week ago by spencemaan.
    • This topic was modified 1 month, 1 week ago by spencemaan.
    • This topic was modified 1 month, 1 week ago by spencemaan.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.