Groups causing MySQL error
-
We’re using groups on a site that also has WooCommerce and GiveWP installed.
When Groups is activiated, every logged-in page load produces this MySQL error:
"PHP message: WordPress database error Unknown column 'post_id' in 'field list' for query SELECT 3uOgy46w_posts.ID FROM 3uOgy46w_posts INNER JOIN 3uOgy46w_give_formmeta ON ( 3uOgy46w_posts.ID = 3uOgy46w_give_formmeta.form_id ) WHERE 1=1 AND ( ( 3uOgy46w_give_formmeta.meta_key = '_give_goal_option' AND 3uOgy46w_give_formmeta.meta_value = 'enabled' ) ) AND 3uOgy46w_posts.post_type = 'give_forms' AND ((3uOgy46w_posts.post_status = 'publish')) AND 3uOgy46w_posts.ID IN ( SELECT ID FROM 3uOgy46w_posts WHERE ID NOT IN ( SELECT post_id FROM 3uOgy46w_give_formmeta WHERE 3uOgy46w_give_formmeta.meta_key = 'groups-groups_read_post' ) UNION ALL SELECT post_id AS ID FROM 3uOgy46w_give_formmeta WHERE 3uOgy46w_give_formmeta.meta_key = 'groups-groups_read_post' AND 3uOgy46w_give_formmeta.meta_value IN ('switch_themes','edit_themes','activate_plugins','edit_plugins','edit_users','edit_files','manage_options','moderate_comments','manage_categories','manage_links','upload_files','import','unfiltered_"Any idea why this is happening, what the purpose of the query is, or if there are settings we can change to try to eliminate this issue while still using the Groups plugin?
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
The topic ‘Groups causing MySQL error’ is closed to new replies.