Title: Database error since last update
Last modified: August 21, 2016

---

# Database error since last update

 *  Resolved [pepe](https://wordpress.org/support/users/pputzer/)
 * (@pputzer)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/database-error-since-last-update/)
 * Since the latest update, I get database errors in my log files:
 * Table ‘wordpressmu.<prefix>_options’ doesn’t exist f\xc3\xbcr Abfrage DELETE 
   FROM <prefix>_options WHERE option_name LIKE ‘_transient_timeout_auditor_%’ von
   require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-
   config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), call_user_func_array,
   initializeNetworkPluginAuditor, NetworkPluginAuditor->NetworkPluginAuditor, NetworkPluginAuditor-
   >clean_old_transients, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->
   query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query
 * <prefix> is the DB prefix. I’m also using W3TC.
 * [http://wordpress.org/extend/plugins/network-plugin-auditor/](http://wordpress.org/extend/plugins/network-plugin-auditor/)

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Author [Katherine Semel-Munson](https://wordpress.org/support/users/ksemel/)
 * (@ksemel)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/database-error-since-last-update/#post-3921731)
 * Hi [@pputzer](https://wordpress.org/support/users/pputzer/),
 * Thank you for the bug report! I’ll get this sorted out.
 * Is the prefix displayed in the error log an incorrect prefix for your site? It
   seems that it would be from the error but I just want to be sure.
 * – Kathy
 *  Thread Starter [pepe](https://wordpress.org/support/users/pputzer/)
 * (@pputzer)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/database-error-since-last-update/#post-3921732)
 * No, the prefix is correct. However, this is a multisite installation and there
   is no global options table. Instead, the blog-specific options table should probably
   be used. (Or maybe wp_sitemeta.)
 * [http://codex.wordpress.org/Database_Description#Multisite_Table_Overview](http://codex.wordpress.org/Database_Description#Multisite_Table_Overview)
 *  Thread Starter [pepe](https://wordpress.org/support/users/pputzer/)
 * (@pputzer)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/database-error-since-last-update/#post-3921733)
 *  Plugin Author [Katherine Semel-Munson](https://wordpress.org/support/users/ksemel/)
 * (@ksemel)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/database-error-since-last-update/#post-3921765)
 * Hi [@pepe](https://wordpress.org/support/users/pepe/),
 * The newest version should resolve this issue. Let me know if you still have trouble!
 * – Kathy
 *  Thread Starter [pepe](https://wordpress.org/support/users/pputzer/)
 * (@pputzer)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/database-error-since-last-update/#post-3921766)
 * After updating I get the following error message on the admin interface (network
   and site-specific):
 * `Fatal error: Cannot break/continue 1 level in <path_to_plugin>/network-plugin-
   auditor.php on line 452`
 * This looks like a “continue” without a loop to me:
 *     ```
       function clean_old_transients() {
               global $wpdb;
   
               // Check that the db_prefix exists
               $check_table_query = "SHOW TABLES LIKE '" . $wpdb->base_prefix . "option
       s'";
               $check_table_result = $wpdb->get_results($check_table_query);
               if (($check_table_result === false && $check_table_result != 0) || ($wpd
       b->num_rows === 0)) {
                   // Store forever
                   set_site_transient( 'auditor_transients_cleaned', true, 0 );
   
                   // Skip this cleanup
                   continue;
               }
   
               // Remove all the legacy style transients
               $wpdb->query( "DELETE FROM " . $wpdb->base_prefix . "options WHERE optio
       n_name LIKE '_transient_auditor_%'" );
               $wpdb->query( "DELETE FROM " . $wpdb->base_prefix . "options WHERE optio
       n_name LIKE '_transient_timeout_auditor_%'" );
   
               // Store forever
               set_transient( 'auditor_transients_cleaned', true, 0 );
   
               return;
           }
       ```
   
 *  [robertstaddon](https://wordpress.org/support/users/robertstaddon/)
 * (@robertstaddon)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/database-error-since-last-update/#post-3921768)
 * I’m getting the same error as [@pepe](https://wordpress.org/support/users/pepe/)
   after upgrading to the latest 1.5.1 Network Plugin Auditor release.
 *  Plugin Author [Katherine Semel-Munson](https://wordpress.org/support/users/ksemel/)
 * (@ksemel)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/database-error-since-last-update/#post-3921769)
 * Hi [@pepe](https://wordpress.org/support/users/pepe/) and [@robertstaddon](https://wordpress.org/support/users/robertstaddon/),
 * Sorry about that! I switched dev environments recently and my debug log wasn’t
   logging notices anymore so I’m missing more bugs than I expect in testing. I 
   have a small pile of code to re-test it seems. 🙁
 * I tested this one in the old dev instance though, so it should finally be resolved.
 * Thanks for your patience!
 * – Kathy
 *  [robertstaddon](https://wordpress.org/support/users/robertstaddon/)
 * (@robertstaddon)
 * [12 years, 10 months ago](https://wordpress.org/support/topic/database-error-since-last-update/#post-3921772)
 * Thank you! 1.5.2 seems to have solved the problem.

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘Database error since last update’ is closed to new replies.

 * ![](https://ps.w.org/network-plugin-auditor/assets/icon-256x256.png?rev=985311)
 * [Network Plugin Auditor](https://wordpress.org/plugins/network-plugin-auditor/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/network-plugin-auditor/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/network-plugin-auditor/)
 * [Active Topics](https://wordpress.org/support/plugin/network-plugin-auditor/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/network-plugin-auditor/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/network-plugin-auditor/reviews/)

 * 8 replies
 * 3 participants
 * Last reply from: [robertstaddon](https://wordpress.org/support/users/robertstaddon/)
 * Last activity: [12 years, 10 months ago](https://wordpress.org/support/topic/database-error-since-last-update/#post-3921772)
 * Status: resolved