• Resolved photosynthesis

    (@photosynthesis)


    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)
  • Plugin Author Kento

    (@proaktion)

    Hi,

    Looks like the plugins are not compatible, my guess is that the Give plugin is using a non-standard format for the meta table which doesn’t provide a post_id field … not 100% sure though as the query you have posted is incomplete and I’m not really familiar with that plugin. I’d suggest to get in touch with them and see if they want to make it compatible with Groups.

    Cheers

Viewing 1 replies (of 1 total)

The topic ‘Groups causing MySQL error’ is closed to new replies.