Skip to:
Content
Pages
Categories
Search
Top
Bottom

Table does not exists for groups


  • Mushi
    Participant

    @mubashiriqbal

    4 years, 8 months ago

    Hi,

    We’ve been receiving complaints from our users since last several days.
    The users see a “503 Service Unavailable” error after trying to login. The problem doesn’t fix even after the users try to clear browser cache and re-attempt login.

    Below is the error that keeps getting logged in error console.

    Feb 27 19:54:01 192.168.222.215 apache2[5365]: [u1050] [dojo.onpressidium.com] [720f49fd8f26631d] [75.128.103.167] [error] [client 192.168.212.31:57618] AH01071: Got error ‘PHP message: WordPress database error Table ‘db_xyz.g’ doesn’t exist for query SELECT DISTINCT g.id FROM g ORDER BY g.date_created DESC LIMIT 0, 20 made by require(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include(‘/themes/boss-child/functions.php’), is_user_logged_in, wp_get_current_user, wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, wplrdesy->wplqez7, wplrdesy->wpluibcy, apply_filters(‘memberium_session_filter’), WP_Hook->apply_filters, wpld9_0u1, groups_get_groups, BP_Groups_Group::get, wpdb->get_col, wpdb->print_error\nPHP message: WordPress database error Table ‘db_xyz.g’ doesn’t exist for query SELECT COUNT(DISTINCT g.id) FROM g made by require(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include(‘/themes/boss-child/functions.php’), is_user_logged_in, wp_get_current_user, wp_get_current_user, wp_set_current_user, do_action(‘set_current_user’), WP_Hook->do_action, WP_Hook->apply_filters, wplrdesy->wplqez7, wplrdesy->wpluibcy, apply_filters(‘memberium_session_filter’), WP_Hook->apply_filters, wpld9_0u1, groups_get_groups, BP_Groups_Group::get, wpdb->get_var, wpdb->print_error\n’

    We’ve checked this with Pressidium and Memberium and they are sure that it’s related to Buddypress.

    Here’s a breakdown of the error:

    This is when it happened

    Feb 27 19:54:01 192.168.222.215 apache2[5365]: [u1050] [dojo.onpressidium.com] [720f49fd8f26631d] [75.128.103.167] [error] [client 192.168.212.31:57618] AH01071:

    This is the error

    Got error ‘PHP message: WordPress database error Table ‘db_xyz.g’ doesn’t exist for query

    This is the (SQL) code

    SELECT DISTINCT g.id FROM g ORDER BY g.date_created DESC LIMIT 0, 20

    This is the order of functions called

    made by require(‘wp-load.php’),
    require_once(‘wp-config.php’),
    require_once(‘wp-settings.php’),
    include(‘/themes/boss-child/functions.php’),
    is_user_logged_in,
    wp_get_current_user,
    _wp_get_current_user,
    wp_set_current_user,
    do_action(‘set_current_user’),
    WP_Hook->do_action,
    WP_Hook->apply_filters,
    wplrdesy->wplqez7,
    wplrdesy->wpluibcy,
    apply_filters(‘memberium_session_filter’),
    WP_Hook->apply_filters,
    wpld9_0u1, groups_get_groups,

    Below is where the error happens. It’s in the BP Groups Group class, in the “get” static method.

    BP_Groups_Group::get,
    wpdb->get_col,

    Could you please investigate and provide us a fix for this issue.

    Thanks,
    Mushi

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

  • iamthewebb
    Participant

    @iamthewebb

    4 years, 8 months ago

    None of my BP sites have a table xyz.g in the database so it looks like another plugin has created this or is attempting to access this. Have you tried the troubleshooting tips in https://buddypress.org/support/topic/when-asking-for-support-2/

    It’s often worth deactivating all plugins then re-enabling each individually until you find what is causing the problem.


    Mushi
    Participant

    @mubashiriqbal

    4 years, 8 months ago

    @iamthewebb

    Thank you for responding to my comment. Actually XYZ is just the placeholder for my database name because I don’t want to disclose it’s name.

    Actually the error is trigger by Buddypress function BP_Groups_Group::get( array $args = array() )
    which is located “Buddypress\bp-groups\classes\class-bp-groups-group.php”

    You can find the function here https://www.buddyboss.com/resources/reference/classes/bp_groups_group/get/

    Right in the function definition when it reach here

     $bp = buddypress();
 
    $sql = array(
        'select'     => "SELECT DISTINCT g.id",
        'from'       => "{$bp->groups->table_name} g",
        'where'      => '',
        'orderby'    => '',
        'pagination' => '',
    );

    It triggers error because it can not find table_name. I am not sure why the table_name is not loaded.

    We are using Buddyboss theme with Buddypress and Memberium plugins.

    Thank You
    Mushi


    hliljegren
    Participant

    @hliljegren

    1 month, 3 weeks ago

    If someone runs into this problem (as I did today). If calling groups_get_groups in a hook like “plugins_loaded” it is to early in the WordPress loading sequence, and gives the SQL error. I moved my hook from plugins_loaded to bp_loaded and the SQL error went away. This is logic as to ensure that BuddyPress is loaded we should use a hook that ensures it.

    I still think that groups_get_group shouldn’t give an SQL error though…

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.

Topic Info

Topic Tags

Skip to toolbar