{"id":17563364,"date":"2024-04-09T17:45:06","date_gmt":"2024-04-09T17:45:06","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-sql-error\/"},"modified":"2024-04-09T17:45:06","modified_gmt":"2024-04-09T17:45:06","slug":"database-sql-error","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-sql-error\/","title":{"rendered":"Database SQL Error"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I get the following error when I activate Genealogical Tree.  Im still learning how to trouble shoot so please excuse my ignorance.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near &#8216;WHERE group_id IN (1) AND is_confirmed = 1 AND (is_admin = 0 AND is_mod = 0 A&#8230;&#8217; at line 1 for query SELECT user_id FROM WHERE group_id IN (1) AND is_confirmed = 1 AND (is_admin = 0 AND is_mod = 0 AND is_banned = 0) ORDER BY date_modified DESC made by require_once(&#8216;wp-admin\/admin.php&#8217;), require_once(&#8216;wp-load.php&#8217;), require_once(&#8216;\/srv\/htdocs\/wp-config.php&#8217;), require_once(&#8216;wp-settings.php&#8217;), do_action(&#8216;plugins_loaded&#8217;), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, bp_loaded, do_action(&#8216;bp_loaded&#8217;), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, buddyboss_updater_init, BuddyBoss_Updater__Plugin::get_instance, BuddyBoss_Updater__Plugin-&gt;setup_actions, current_user_can, user_can, WP_User-&gt;has_cap, apply_filters(&#8216;user_has_cap&#8217;), WP_Hook-&gt;apply_filters, Zqe\\Genealogical_Tree_Admin-&gt;bp_manage_capabilities, groups_get_group_members, BP_User_Query-&gt;__construct, BP_User_Query-&gt;prepare_user_ids_query, BP_Group_Member_Query-&gt;get_include_ids, BP_Group_Member_Query-&gt;get_group_member_ids<\/p>\n","protected":false},"template":"","class_list":["post-17563364","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17563364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17563364\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=17563364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}