Multiple meta value where clause throws error

[ghost]

Here is a simple Code which shows the error.
My settings are exported below.

add_shortcode( 'listing', 'listing_function' );

function listing_function() {
  /* Single clause works fine */
  $params = array(
      'limit' => 10,
      'where' => "objektkategorie.nutzungsart.meta_value = 'wohnen' "
  );

  $immobilien = pods('immobilie', $params);

	/* Single clause works fine */
  $params = array(
      'limit' => 10,
      'where' => "objektkategorie.vermarktungsart.meta_value = 'miete' "
  );
  $immobilien = pods('immobilie', $params);

  /* Combined throws error */
  $params = array(
       'limit' => 10,
       'where' => "objektkategorie.vermarktungsart.meta_value = 'miete' AND objektkategorie.nutzungsart.meta_value = 'wohnen' "
  );
  $immobilien = pods('immobilie', $params);
}

settings.txt

[sc0ttkclark]

What’s the error it throws?

[jimtrue]

Copying the error over from Slack #support from yesterday:

SELECT DISTINCT `t`.* FROM `yy2eA_posts` AS `t` LEFT JOIN `yy2eA_podsrel` AS `rel_objektkategorie` ON `rel_objektkategorie`.`field_id` = 251 AND `rel_objektkategorie`.`item_id` = `t`.`ID` LEFT JOIN `yy2eA_posts` AS `objektkategorie` ON `objektkategorie`.`ID` = `rel_objektkategorie`.`related_item_id` LEFT JOIN `yy2eA_postmeta` AS `objektkategorie_nutzungsart` ON `objektkategorie_nutzungsart`.`meta_key` = 'nutzungsart' AND `objektkategorie_nutzungsart`.`post_id` = `objektkategorie`.`ID` LEFT JOIN `yy2eA_postmeta` AS `objektkategorie_vermarktungsart_meta_value` ON `objektkategorie_vermarktungsart_meta_value`.`meta_key` = 'meta_value' AND `objektkategorie_vermarktungsart_meta_value`.`post_id` = `objektkategorie_vermarktungsart`.`post_id` LEFT JOIN `yy2eA_postmeta` AS `objektkategorie_vermarktungsart` ON `objektkategorie_vermarktungsart`.`meta_key` = 'vermarktungsart' AND `objektkategorie_vermarktungsart`.`post_id` = `objektkategorie`.`ID` LEFT JOIN `yy2eA_podsrel` AS `rel_geo` ON `rel_geo`.`field_id` = 276 AND `rel_geo`.`item_id` = `t`.`ID` LEFT JOIN `yy2eA_posts` AS `geo` ON `geo`.`ID` = `rel_geo`.`related_item_id` LEFT JOIN `yy2eA_postmeta` AS `geo_strasse` ON `geo_strasse`.`meta_key` = 'strasse' AND `geo_strasse`.`post_id` = `geo`.`ID` WHERE ( ( `objektkategorie_nutzungsart`.`meta_value` = "wohnen" AND `objektkategorie_vermarktungsart`.`meta_value` = "miete" ) AND ( `t`.`post_type` = "immobilie" ) AND ( `t`.`post_status` IN ( "publish" ) ) ) ORDER BY `geo_strasse`.`meta_value`, `t`.`menu_order`, `t`.`post_title`, `t`.`post_date` LIMIT 0, 10

Error: Unknown column 'objektkategorie_nutzungsart.post_id' in 'on clause'

[jimtrue]

@SimpleKjell I did notice that yesterday that the SQL clause didn't include the actual error statement, though, so that would be helpful.

[ghost]

Here is my debug.log - i hope that's what you meant, otherwise give me an advice where to find the actual error statement.

edit: noticed that this problem only occurs with custom defined lists. Plain Text fields work fine.
podA->find(relatedPod.field_name_plain_text.meta_value = 'value1' AND relatedPod.field_name_plain_text_2.meta_value = 'value2') // works fine

WordPress-Datenbank-Fehler Unknown column 'objektkategorie_nutzungsart.post_id' in 'on clause' für Abfrage SELECT
                
                DISTINCT
                `t`.*
                FROM `wp_posts` AS `t`
                
                    LEFT JOIN `wp_podsrel` AS `rel_objektkategorie` ON
                        `rel_objektkategorie`.`field_id` = 2297
                        AND `rel_objektkategorie`.`item_id` = `t`.`ID`

                    LEFT JOIN `wp_posts` AS `objektkategorie` ON
                        `objektkategorie`.`ID` = `rel_objektkategorie`.`related_item_id`
                
                
                    LEFT JOIN `wp_postmeta` AS `objektkategorie_vermarktungsart` ON
                        `objektkategorie_vermarktungsart`.`meta_key` = 'vermarktungsart'
                        AND `objektkategorie_vermarktungsart`.`post_id` = `objektkategorie`.`ID`
                
                
                    LEFT JOIN `wp_postmeta` AS `objektkategorie_nutzungsart_meta_value` ON
                        `objektkategorie_nutzungsart_meta_value`.`meta_key` = 'meta_value'
                        AND `objektkategorie_nutzungsart_meta_value`.`post_id` = `objektkategorie_nutzungsart`.`post_id`
                
                
                    LEFT JOIN `wp_postmeta` AS `objektkategorie_nutzungsart` ON
                        `objektkategorie_nutzungsart`.`meta_key` = 'nutzungsart'
                        AND `objektkategorie_nutzungsart`.`post_id` = `objektkategorie`.`ID`
                
                WHERE ( ( `objektkategorie_vermarktungsart`.`meta_value` = 'miete' AND `objektkategorie_nutzungsart`.`meta_value` = 'wohnen'  ) AND ( `t`.`post_type` = "immobilie" ) AND ( `t`.`post_status` IN ( "publish" ) ) )
                
                
                ORDER BY `t`.`menu_order`, `t`.`post_title`, `t`.`post_date`
                LIMIT 0, 10 von require('C:\xampp3\htdocs\test\wp-blog-header.php'), require_once('C:\xampp3\htdocs\test\wp-includes\template-loader.php'), include('C:\xampp3\htdocs\test\wp-content\themes\twentyfifteen\page.php'), get_template_part, locate_template, load_template, require('C:\xampp3\htdocs\test\wp-content\themes\twentyfifteen\content-page.php'), the_content, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, listing_function, pods, Pods->__construct, Pods->find, PodsData->select, pods_query, PodsData::query

[quasel]

did you find a solution?
Sorry for the late reply, feel free to comment if you still have questions!