Title: Multisite Issues
Last modified: August 21, 2016

---

# Multisite Issues

 *  Resolved [iDesignCo](https://wordpress.org/support/users/idesignco/)
 * (@idesignco)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/multisite-issues-5/)
 * Hello,
 * I seem to be having a similar issue described here:
    [http://wordpress.org/support/topic/added-by-dont-shows-up](http://wordpress.org/support/topic/added-by-dont-shows-up)
 * However this is off of a clean install (didn’t update the plugin from an older
   version). The sums show up, but in a sub-site the list just says “No Data”. However
   if I look at the DB table, I can see the entries for the income/expenses I’ve
   added.
 * It does, however, work fine on the main site. Additions appear both in the list
   and in the sums.
 * I’ve also noticed that it seems to be messing up the styling on other WordPress
   Admin pages. I’m guessing this is due to the styling being queued to the wp-admin
   without checking to see if it is the finance page. Nothing major on that part
   asofar, but it shouldn’t be happening.
 * Thanks,
    Chris.
 * [http://wordpress.org/extend/plugins/wp-finance/](http://wordpress.org/extend/plugins/wp-finance/)

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

 *  Thread Starter [iDesignCo](https://wordpress.org/support/users/idesignco/)
 * (@idesignco)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/multisite-issues-5/#post-3872679)
 * Good news.
 * I figured out the issue. It was in `/wp-finance/components/wpf_default.php`
 * You use `$wpdb->prefix` to grab the table prefix for the site, which works fine
   for everything on a single-site installation. However on a multisite installation,
   you’re trying to use it for users, which is what’s breaking this.
 * It’s trying to load `wp_3_users` when it should be loading `wp_users` on a multisite
   installation. Using `wp_3_` as the prefix works for the rest of the time, because
   the `finance` table is with that prefix, but the users table is still in the 
   main WP table.
 * So by changing in lines 138-139 in that file from:
    `$wpdb->prefix."users` to`
   $wpdb->base_prefix."users` to select the users instead, the plugin loads content
   fine in a sub-site.
 * Hope this helps anyone else with this issue.
    Chris.
 *  Thread Starter [iDesignCo](https://wordpress.org/support/users/idesignco/)
 * (@idesignco)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/multisite-issues-5/#post-3872682)
 * There are additional references to the user table, so instead of just on those
   two lines, replace any instance of `$wpdb->prefix."users` with `$wpdb->base_prefix."
   users`.
 * That’ll make it all work for multisite.
 * -Chris.
 *  Plugin Author [mch0lic](https://wordpress.org/support/users/mch0lic/)
 * (@mch0lic)
 * [12 years, 11 months ago](https://wordpress.org/support/topic/multisite-issues-5/#post-3872746)
 * Hi iDesignCo,
 * So basically using $wpdb->base_prefix will sort all multisite problems? Will 
   try to add patch asap 🙂

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

The topic ‘Multisite Issues’ is closed to new replies.

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

## Tags

 * [finance](https://wordpress.org/support/topic-tag/finance/)
 * [multisite](https://wordpress.org/support/topic-tag/multisite/)
 * [network](https://wordpress.org/support/topic-tag/network/)
 * [records](https://wordpress.org/support/topic-tag/records/)
 * [styling](https://wordpress.org/support/topic-tag/styling/)

 * 3 replies
 * 2 participants
 * Last reply from: [mch0lic](https://wordpress.org/support/users/mch0lic/)
 * Last activity: [12 years, 11 months ago](https://wordpress.org/support/topic/multisite-issues-5/#post-3872746)
 * Status: resolved