Title: Multi-site sql query issue
Last modified: August 22, 2016

---

# Multi-site sql query issue

 *  Resolved [AWOL](https://wordpress.org/support/users/awol/)
 * (@awol)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/multi-site-sql-query-issue/)
 * Hi Bob,
    Starting a new topic as requested, but will repeat my post from the 
   other topic here. I am seeing an error message in my error logs relating to your
   plugin, as follows; WordPress database error Table ‘xxxxxx_wordpress.wp_9_wp_topbar_data’
   doesn’t exist for query SELECT * FROM wp_9_wp_topbar_data WHERE enable_topbar
   = ‘true’ AND COALESCE(TIMESTAMPDIFF( MINUTE, COALESCE(STR_TO_DATE( ‘2015-03-29
   08:23:55’, ‘%Y-%m-%d %H:%i’ ), 0), COALESCE(STR_TO_DATE( start_time_utc, ‘%m/%
   d/%Y %H:%i’ ), 0)),0) <= 0 AND COALESCE(TIMESTAMPDIFF( MINUTE, COALESCE(STR_TO_DATE(
   end_time_utc , ‘%m/%d/%Y %H:%i’ ), 0), COALESCE(STR_TO_DATE( ‘2015-03-29 08:23:
   55’, ‘%Y-%m-%d %H:%i’ ), 0)),0) <=0 ORDER BY weighting_points DESC made by require(‘
   wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/
   themes/suffusion/single.php’), get_footer, locate_template, load_template, require_once(‘/
   themes/suffusion/footer.php’), wp_footer, do_action(‘wp_footer’), call_user_func_array,
   wptb::wptb_activate_TopBar_html_js, wptb::wptb_build_cacheable_html_js
 * This error occurs multiple times for all the sites on my network.
 * The info on my Server/Install is as follows:
    Database/Column Check: Charset (
   DB_CHARSET): utf8 Collation (DB_COLLATE): Collation encoding: utf8_general_ci
 * Table Check:
    Table Name: wp_wp_topbar_data Number of rows in databse: 2 WP-TopBar
   internal db version: 5.08
 * Options Check:
    Plugin is not using the original Options (wptbAdminOptions) Plugin
   is using the DB Options (wptb_db_version) Plugin is using the new Global Options(
   wptb_global_options) Plugin is using the new Network Global Options (wptb_network_global_options)
 * Server Check:
    fopen setting is ON PHP Magic Quotes is OFF
 * Time Check:
    Server Timezone: UTC Current Time: 03/29/2015 10:49 Current Time(
   GMT): 03/29/2015 03:49 WordPress GMT Offset: 7
 * Multisite Check:
    Multisite: Yes Blog ID:1 Super Admin Only:no Current user can
   manage_network_plugins: Yes
 * My server info is as follows:
    OS Linux Database Data Disk Usage 151.8 MiB Server
   LiteSpeed Database Index Disk Usage 67.5 MiB PHP v5.4.36 MYSQL Maximum Packet
   Size 256.0 MiB MYSQL v5.5.40-MariaDB-cll-lve MYSQL Maximum No. Connection 500
 * In your reply on the other topic you mentioned the “_wordpress” had been added
   to the start but actually I left that bit in but took away my cPanel username(
   replaced with x’s above) – that is how all my wordpress tables are identified
   so I don’t think that is the error, or if it is, some change would ned to be 
   made to the plugin to allow for it.
 * [https://wordpress.org/plugins/wp-topbar/](https://wordpress.org/plugins/wp-topbar/)

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

 *  Plugin Author [rfgoetz](https://wordpress.org/support/users/rfgoetz/)
 * (@rfgoetz)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/multi-site-sql-query-issue/#post-5955601)
 * I was not able to recreate the issue on my test sites. Howeve, I have an idea
   of what the issue might be. I also added more debug logic to help pinpoint the
   problem, Would you be willing to try a beta version? If so, send me your contact
   info. My info is in wp-topbar.php.
 * Bob
 *  Plugin Author [rfgoetz](https://wordpress.org/support/users/rfgoetz/)
 * (@rfgoetz)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/multi-site-sql-query-issue/#post-5955768)
 * Thanks, AWOL, for helping test the fix. I just pushed v. 5.26 out.

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

The topic ‘Multi-site sql query issue’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wp-topbar_706d6d.svg)
 * [WP-TopBar](https://wordpress.org/plugins/wp-topbar/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-topbar/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-topbar/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-topbar/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-topbar/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-topbar/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [rfgoetz](https://wordpress.org/support/users/rfgoetz/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/multi-site-sql-query-issue/#post-5955768)
 * Status: resolved