post_id field missing in give_formmeta table?

  • Resolved fidoboy

    (@fidoboy)


    2 years, 6 months ago

    I’m getting errors in my log about a wrong DB query. That query is being created from Give_Shortcode_Generator->generate_post and it’s looking for field form_id into the table give_formmeta. It throws an error Unknown column 'cdxn_post_meta.post_id' in 'on clause'

    The full query is this:

    SELECT wp_posts.ID FROM wp_posts INNER JOIN  wp_give_formmeta ON ( wp_posts.ID = wp_give_formmeta.form_id ) INNER JOIN  wp_give_formmeta as cdxn_post_meta on cdxn_post_meta.post_id = wp_posts.ID  WHERE 1=1  AND ( 
  ( wp_give_formmeta.meta_key = '_give_goal_option' AND wp_give_formmeta.meta_value = 'enabled' )
) AND wp_posts.post_type = 'give_forms' AND ((wp_posts.post_status = 'publish')) OR cdxn_post_meta.meta_key='_wp_attachment_image_alt' AND cdxn_post_meta.meta_value LIKE '%zip%' GROUP BY wp_posts.ID ORDER BY wp_posts.post_title ASC LIMIT 0, 30

    and it’s being created when I search a word in media library (“zip” is the word being used in this case)

    I believe that plugin causing the problem is this: https://es.wordpress.org/plugins/media-library-helper/

    • This topic was modified 2 years, 6 months ago by fidoboy. Reason: Added more details
    • This topic was modified 2 years, 6 months ago by fidoboy. Reason: Add more details about possible cause
Viewing 1 replies (of 1 total)
  • Plugin Support Rick Alday

    (@mrdaro)

    2 years, 6 months ago

    Hi @fidoboy,

    Happy to help here.

    My guess is that the Media Library Helper is searching in all post types including GiveWP Form and GiveWP Payments, both of which a custom post types.

    I would ask the plugin developer to see if there’s a way to exclude those custom post types from the search.

Viewing 1 replies (of 1 total)
  • The topic ‘post_id field missing in give_formmeta table?’ is closed to new replies.