Title: WordPress database error Table doesn’t exist
Last modified: October 28, 2019

---

# WordPress database error Table doesn’t exist

 *  Resolved [spencemaan](https://wordpress.org/support/users/spencemaan/)
 * (@spencemaan)
 * [6 years, 7 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-doesnt-exist-4/)
 * 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 6 years, 7 months ago by [spencemaan](https://wordpress.org/support/users/spencemaan/).
    -  This topic was modified 6 years, 7 months ago by [spencemaan](https://wordpress.org/support/users/spencemaan/).
    -  This topic was modified 6 years, 7 months ago by [spencemaan](https://wordpress.org/support/users/spencemaan/).

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [khushbu padalia](https://wordpress.org/support/users/khushbupadalia/)
 * (@khushbupadalia)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-doesnt-exist-4/#post-12155020)
 * HI [@spencemaan](https://wordpress.org/support/users/spencemaan/),
 * User activity log plugin is not supported with multisite. Pro version of this
   plugin is compatible with multisite.
 * Thank you.
    -  This reply was modified 6 years, 6 months ago by [khushbu padalia](https://wordpress.org/support/users/khushbupadalia/).

Viewing 1 replies (of 1 total)

The topic ‘WordPress database error Table doesn’t exist’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/user-activity-log_2b5346.svg)
 * [User Activity Log](https://wordpress.org/plugins/user-activity-log/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/user-activity-log/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/user-activity-log/)
 * [Active Topics](https://wordpress.org/support/plugin/user-activity-log/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/user-activity-log/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/user-activity-log/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [khushbu padalia](https://wordpress.org/support/users/khushbupadalia/)
 * Last activity: [6 years, 6 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-doesnt-exist-4/#post-12155020)
 * Status: resolved