Multisite – Database issues
-
I have some database issues in my multi site setup.
The power stats tables are not created for the sites on my network.
Am I doing something wrong or is this plugin not meant to be used in a multi site environment?
Cheers,
Sascha
-
Sorry for taking such a long time to respond. The plugin supports multisite, I will to fix this asap.
I also see an enormous number of such lines in php errors log:
[02-Mar-2016 09:46:22 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_visits' doesn't exist for query INSERT IGNORE INTO wp_148_power_stats_visits (ip, date, time, country, device, referer, browser, browser_version, os, user_agent, language, user, is_search_engine) VALUES ('212.111.194.3','2016-03-02','2016-03-02 12:46:22','UA','desktop','https://www.kpi.kharkov.ua/en/education/','Chrome','47.0.2526.111','Windows','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.111 YaBrowser/16.2.0.3539 Safari/537.36','uk','','') made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::insert_row [02-Mar-2016 09:46:22 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_pageviews' doesn't exist for query UPDATE wp_148_power_stats_pageviews SET <code>hits</code> = <code>hits</code> + 1 WHERE <code>date</code> = '2016-03-02' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_pageview_data [02-Mar-2016 09:46:22 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_referers' doesn't exist for query UPDATE wp_148_power_stats_referers SET <code>count</code> = <code>count</code> + 1 WHERE <code>referer</code> = 'https://www.kpi.kharkov.ua/en/education/' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_referer_data [02-Mar-2016 09:46:22 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_posts' doesn't exist for query UPDATE wp_148_power_stats_posts SET <code>hits</code> = <code>hits</code> + 1 WHERE <code>date</code> = '2016-03-02' AND <code>post_id</code> = '5' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_post_data [02-Mar-2016 09:46:22 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_os' doesn't exist for query UPDATE wp_148_power_stats_os SET <code>count</code> = count + 1 WHERE <code>os</code> = 'Windows' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_os_data [02-Mar-2016 09:46:22 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_browsers' doesn't exist for query UPDATE wp_148_power_stats_browsers SET <code>count</code> = count + 1 WHERE <code>browser</code> = 'Chrome' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_browser_data [02-Mar-2016 09:46:28 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_visits' doesn't exist for query INSERT IGNORE INTO wp_148_power_stats_visits (ip, date, time, country, device, referer, browser, browser_version, os, user_agent, language, user, is_search_engine) VALUES ('212.111.194.3','2016-03-02','2016-03-02 12:46:28','UA','desktop','https://web.kpi.kharkov.ua/erasmus/about-erasmus/','Chrome','47.0.2526.111','Windows','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.111 YaBrowser/16.2.0.3539 Safari/537.36','uk','','') made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::insert_row [02-Mar-2016 09:46:28 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_pageviews' doesn't exist for query UPDATE wp_148_power_stats_pageviews SET <code>hits</code> = <code>hits</code> + 1 WHERE <code>date</code> = '2016-03-02' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_pageview_data [02-Mar-2016 09:46:28 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_referers' doesn't exist for query UPDATE wp_148_power_stats_referers SET <code>count</code> = <code>count</code> + 1 WHERE <code>referer</code> = 'https://web.kpi.kharkov.ua/erasmus/about-erasmus/' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_referer_data [02-Mar-2016 09:46:28 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_posts' doesn't exist for query UPDATE wp_148_power_stats_posts SET <code>hits</code> = <code>hits</code> + 1 WHERE <code>date</code> = '2016-03-02' AND <code>post_id</code> = '11' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_post_data [02-Mar-2016 09:46:28 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_os' doesn't exist for query UPDATE wp_148_power_stats_os SET <code>count</code> = count + 1 WHERE <code>os</code> = 'Windows' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_os_data [02-Mar-2016 09:46:28 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_browsers' doesn't exist for query UPDATE wp_148_power_stats_browsers SET <code>count</code> = count + 1 WHERE <code>browser</code> = 'Chrome' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_browser_data [02-Mar-2016 09:46:39 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_visits' doesn't exist for query INSERT IGNORE INTO wp_148_power_stats_visits (ip, date, time, country, device, referer, browser, browser_version, os, user_agent, language, user, is_search_engine) VALUES ('212.111.194.3','2016-03-02','2016-03-02 12:46:39','UA','desktop','https://web.kpi.kharkov.ua/erasmus/course-catalogue/','Chrome','47.0.2526.111','Windows','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.111 YaBrowser/16.2.0.3539 Safari/537.36','uk','','') made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::insert_row [02-Mar-2016 09:46:39 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_pageviews' doesn't exist for query UPDATE wp_148_power_stats_pageviews SET <code>hits</code> = <code>hits</code> + 1 WHERE <code>date</code> = '2016-03-02' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_pageview_data [02-Mar-2016 09:46:39 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_referers' doesn't exist for query UPDATE wp_148_power_stats_referers SET <code>count</code> = <code>count</code> + 1 WHERE <code>referer</code> = 'https://web.kpi.kharkov.ua/erasmus/course-catalogue/' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_referer_data [02-Mar-2016 09:46:39 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_posts' doesn't exist for query UPDATE wp_148_power_stats_posts SET <code>hits</code> = <code>hits</code> + 1 WHERE <code>date</code> = '2016-03-02' AND <code>post_id</code> = '14' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_post_data [02-Mar-2016 09:46:39 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_os' doesn't exist for query UPDATE wp_148_power_stats_os SET <code>count</code> = count + 1 WHERE <code>os</code> = 'Windows' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_os_data [02-Mar-2016 09:46:39 UTC] WordPress database error Table 'wp-multi.wp_148_power_stats_browsers' doesn't exist for query UPDATE wp_148_power_stats_browsers SET <code>count</code> = count + 1 WHERE <code>browser</code> = 'Chrome' made by do_action('wp_ajax_nopriv_power_stats_track'), call_user_func_array, PowerStats::power_stats_track, PowerStats::get_visitor_data, PowerStats::insert_data, PowerStats::get_insert_browser_data
shad0vv, looks like there was an issue with the plugin installations: the needed databases were not created. You could try reinstalling the plugin.
Hello,
For Multisite do I Network Activate the plugin or do I activate it on each subfolder site individually?
I have tried to activate on the 3 subfolder sites I have and it does not capture any stats?
Is your plugin working with Multisite?
Can you add some instructions on how to use it with Multisite?
thanks,
Netivity
- The topic ‘Multisite – Database issues’ is closed to new replies.