MultiDB Issue

  • Resolved twwoodward

    (@twwoodward)


    7 years, 1 month ago

    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.

    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. 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 to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author icc0rz

    (@icc0rz)

    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. Notice how the users table is fetched using the $wpdb->users variable instead of the $wpdb->prefix on 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.