Title: MultiDB Issue
Last modified: October 4, 2017

---

# MultiDB Issue

 *  Resolved [twwoodward](https://wordpress.org/support/users/twwoodward/)
 * (@twwoodward)
 * [8 years, 8 months ago](https://wordpress.org/support/topic/multidb-issue/)
 * I have a unique-ish setup. It’s a large educational multisite. The database is
   fragmented into 256 different databases to deal with scale issues using [multi-db](https://github.com/wpmudev/multi-db).
 * H5P works well except for the fact that the main “All H5P content” listing for
   created content does not show any work. It gives the [linked error responses](https://gist.github.com/woodwardtw/33e9dec240ed3fd4c652e64d7ac6c623).
   I’m assuming the issue is caused by individual site’s table prefix (wp_23567 
   in this case).
 * The items are stored and retrievable if I manually enter the ID so that element
   works. So ../wp-admin/admin.php?page=h5p_new&id=5 will retrieve previously created
   elements with no issue. That gives me some hope there might be a relatively simple
   way to address this by modifying the table query but I’m not sure where that’s
   coming from.
 * I realize this is a fringe request so any help is appreciated but also understand
   if it’s outside the margins of what you can support.
 * In any case, thanks for a great plugin.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fmultidb-issue%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Plugin Author [icc0rz](https://wordpress.org/support/users/icc0rz/)
 * (@icc0rz)
 * [8 years, 8 months ago](https://wordpress.org/support/topic/multidb-issue/#post-9558098)
 * I’m not very familiar with that kind of database setup, but from the looks of
   it the users table is stored in another database (on the same server hopefully?)
   but the query is unable to join it in.
 * The query for the H5P content index can get complex as it supports so many input
   parameters, it’s, therefore, build using the class in [admin/class-h5p-content-query.php](https://github.com/h5p/h5p-wordpress-plugin/blob/master/admin/class-h5p-content-query.php).
   Notice how the users table is fetched using the $wpdb->users variable instead
   of the $wpdb->prefix on [L65](https://github.com/h5p/h5p-wordpress-plugin/blob/master/admin/class-h5p-content-query.php#L65).
 * I don’t know if I can be of much help, but please share if you find the culprit
   of the error. Maybe there’s something that can be improved within the plugin.

Viewing 1 replies (of 1 total)

The topic ‘MultiDB Issue’ is closed to new replies.

 * ![](https://ps.w.org/h5p/assets/icon.svg?rev=986118)
 * [Interactive Content – H5P](https://wordpress.org/plugins/h5p/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/h5p/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/h5p/)
 * [Active Topics](https://wordpress.org/support/plugin/h5p/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/h5p/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/h5p/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [icc0rz](https://wordpress.org/support/users/icc0rz/)
 * Last activity: [8 years, 8 months ago](https://wordpress.org/support/topic/multidb-issue/#post-9558098)
 * Status: resolved