Title: Multisite – Database issues
Last modified: August 30, 2016

---

# Multisite – Database issues

 *  [vreen](https://wordpress.org/support/users/vreen/)
 * (@vreen)
 * [10 years, 9 months ago](https://wordpress.org/support/topic/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
 * [https://wordpress.org/plugins/wp-power-stats/](https://wordpress.org/plugins/wp-power-stats/)

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

 *  Plugin Author [artifex404](https://wordpress.org/support/users/artifex404/)
 * (@artifex404)
 * [10 years, 8 months ago](https://wordpress.org/support/topic/multisite-database-issues/#post-6482920)
 * Sorry for taking such a long time to respond. The plugin supports multisite, 
   I will to fix this asap.
 *  [shad0vv](https://wordpress.org/support/users/shad0vv/)
 * (@shad0vv)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/multisite-database-issues/#post-6482957)
 * 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','http://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> = 'http://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','http://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> = 'http://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','http://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> = 'http://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
       ```
   
 *  Plugin Author [artifex404](https://wordpress.org/support/users/artifex404/)
 * (@artifex404)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/multisite-database-issues/#post-6482958)
 * shad0vv, looks like there was an issue with the plugin installations: the needed
   databases were not created. You could try reinstalling the plugin.
 *  [netivity](https://wordpress.org/support/users/netivity/)
 * (@netivity)
 * [10 years, 2 months ago](https://wordpress.org/support/topic/multisite-database-issues/#post-6482959)
 * 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

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

The topic ‘Multisite – Database issues’ is closed to new replies.

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

 * 4 replies
 * 4 participants
 * Last reply from: [netivity](https://wordpress.org/support/users/netivity/)
 * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/multisite-database-issues/#post-6482959)
 * Status: not resolved