Title: Groups causing MySQL error
Last modified: July 4, 2020

---

# Groups causing MySQL error

 *  Resolved [photosynthesis](https://wordpress.org/support/users/photosynthesis/)
 * (@photosynthesis)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/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)

 *  Plugin Author [Kento](https://wordpress.org/support/users/proaktion/)
 * (@proaktion)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/groups-causing-mysql-error/#post-13408358)
 * 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.

 * ![](https://ps.w.org/groups/assets/icon-256x256.png?rev=983146)
 * [Groups](https://wordpress.org/plugins/groups/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/groups/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/groups/)
 * [Active Topics](https://wordpress.org/support/plugin/groups/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/groups/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/groups/reviews/)

## Tags

 * [givewp](https://wordpress.org/support/topic-tag/givewp/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * 1 reply
 * 2 participants
 * Last reply from: [Kento](https://wordpress.org/support/users/proaktion/)
 * Last activity: [5 years, 8 months ago](https://wordpress.org/support/topic/groups-causing-mysql-error/#post-13408358)
 * Status: resolved