database tables missing in multisite

  • Resolved stuurluidevelopment

    (@stuurluidevelopment)


    6 months ago

    Hi guys, we have some issues with the Simple History plugin on an multisite DEV environment.

    When we install the plugin and enable it on a network level, the DB tables are created for the main site (site id =1), but not for subsites site id >1).

    Activating the plugin on a subsite level does not fix the issues. Error that is displayed on /subsite2/wp-admin/admin.php?page=simple_history_admin_menu_page:

    Fatal error: Uncaught Exception: Fout bij uitvoeren query: Table ‘database.wp_2_simple_history’ doesn’t exist in /data/www/web-test.domain.com/public_html/wp-content/plugins/simple-history/inc/class-log-query.php:405 Stack trace: #0 /data/www/web-test.domain.com/public_html/wp-content/plugins/simple-history/inc/class-log-query.php(76): Simple_History\Log_Query->query_overview_mysql() #1 /data/www/web-test.domain.com/public_html/wp-content/plugins/simple-history/inc/class-log-query.php(47): Simple_History\Log_Query->query_overview() #2 /data/www/web-test.domain.com/public_html/wp-content/plugins/simple-history/inc/class-events-stats.php(1776): Simple_History\Log_Query->query() #3 /data/www/web-test.domain.com/public_html/wp-content/plugins/simple-history/dropins/class-sidebar-stats-dropin.php(326): Simple_History\Events_Stats::get_num_events_today() #4 /data/www/web-test.domain.com/public_html/wp-content/plugins/simple-history/dropins/class-sidebar-stats-dropin.php(345): Simple_History\Dropins\Sidebar_Stats_Dropin->get_quick_stats_data() #5 /data/www/web-test.domain.com/public_html/wp-includes/class-wp-hook.php(324): Simple_History\Dropins\Sidebar_Stats_Dropin->on_sidebar_html() #6 /data/www/web-test.domain.com/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #7 /data/www/web-test.domain.com/public_html/wp-includes/plugin.php(517): WP_Hook->do_action() #8 /data/www/web-test.domain.com/public_html/wp-content/plugins/simple-history/dropins/class-sidebar-dropin.php(129): do_action() #9 /data/www/web-test.domain.com/public_html/wp-includes/class-wp-hook.php(324): Simple_History\Dropins\Sidebar_Dropin->output_sidebar_html() #10 /data/www/web-test.domain.com/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #11 /data/www/web-test.domain.com/public_html/wp-includes/plugin.php(517): WP_Hook->do_action() #12 /data/www/web-test.domain.com/public_html/wp-content/plugins/simple-history/inc/services/class-admin-pages.php(109): do_action() #13 [internal function]: Simple_History\Services\Admin_Pages->history_page_output() #14 /data/www/web-test.domain.com/public_html/wp-content/plugins/simple-history/inc/class-menu-page.php(401): call_user_func() #15 /data/www/web-test.domain.com/public_html/wp-includes/class-wp-hook.php(324): Simple_History\Menu_Page->render() #16 /data/www/web-test.domain.com/public_html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #17 /data/www/web-test.domain.com/public_html/wp-includes/plugin.php(517): WP_Hook->do_action() #18 /data/www/web-test.domain.com/public_html/wp-admin/admin.php(259): do_action() #19 {main} thrown in /data/www/web-test.domain.com/public_html/wp-content/plugins/simple-history/inc/class-log-query.php on line 405

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Pär Thernström

    (@eskapism)

    5 months, 1 week ago

    Thank you for the report!

    We can confirm this is an issue. This also happens when installing the plugin as a must-use plugin. It’s probably the register hook that is not fired for all subsites.

    bobheinen

    (@bobheinen)

    4 months, 3 weeks ago

    Nice to see this is a known issue. Is there an ETA for a fix, or a hotfix, or a roadmap where this issue is a part of.

    Plugin Author Pär Thernström

    (@eskapism)

    4 months ago

    Yes, I plan to fix it in the next version, if no unplanned problems occur. I have create an issue for it that you can follow if you want.

    Plugin Author Pär Thernström

    (@eskapism)

    3 months, 3 weeks ago

    I have worked on a Database Auto Recovery feature and it is enabled now in the just released version 5.21.0. It should detect that tables are missing when viewing the log or when trying to create a log entry, and if it is missing then it recreated the tables. Let me know if this works for you!

    This feature can help in several situations when tables are missing. Another scenario is when a site is duplicated using a duplicate/clone plugin and then duplicates the options table but not the custom log tables = confusing the plugin.

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

You must be logged in to reply to this topic.