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_jsThis 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_ciTable Check:
Table Name: wp_wp_topbar_data
Number of rows in databse: 2
WP-TopBar internal db version: 5.08Options 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 OFFTime Check:
Server Timezone: UTC
Current Time: 03/29/2015 10:49
Current Time (GMT): 03/29/2015 03:49
WordPress GMT Offset: 7Multisite Check:
Multisite: Yes
Blog ID:1
Super Admin Only:no
Current user can manage_network_plugins: YesMy 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 500In 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.
- The topic ‘Multi-site sql query issue’ is closed to new replies.