Support » Plugin: Shortcodes Ultimate » wp_1_options npt found

  • plemboarw1

    (@plemboarw1)


    This is on an internal site not accessible from the Internet. Out front page is using

    [su_tab title=”Internal Sites Directory” ][site-list][/su_tab]

    To show a list of sites on its multisite network. But when someone goes there this error shows up in Apache’s error_log:

    [Mon Oct 09 14:44:53 2017] [error] [client 10.17.214.57] WordPress database error Table ‘wparwsites.wp_1_options’ doesn’t exist for query SELECT option_value FROM wp_1_options WHERE option_name IN (‘siteurl’,’blogname’,’blogdescription’) ORDER BY option_name DESC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/wordpress-bootstrap-master-home/page-homepage.php’), get_sidebar, locate_template, load_template, require_once(‘/themes/wordpress-bootstrap-master-home/sidebar-sidebar2.php’), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Text->widget, apply_filters(‘widget_text’), WP_Hook->apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, Su_Shortcodes::tabs, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, Su_Shortcodes::tab, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, ithemes_mssls->display_site_list

    The problem, of course, is that in a multisite network there is no wp_1_options table, and never will be. In multisite, blog_id 1 is the root site. The next site created would be blog_id 2, blog_id 3, etc. The wp_options table is for the root side, blog_id 1. WP then creates wp_2_options for blog_id 2 and so on.

    So the question is, what can we do to keep Shortcodes Ultimate from calling a nonexistent table?

  • You must be logged in to reply to this topic.