Query aren't giving correct result on ebay listing page.
-
wplister page query is showing correct results for listing_duration. But when same page with search query ($_REQUEST[‘s’] = “something”) results are not coming correct for listing_duration column. Reason is search_query option adding {$wpdb->prefix}ebay_profiles in joining so overriding data from table wp_ebay_auctions to {$wpdb->prefix}ebay_profiles data. So in query need to add explicitly l.listing_duration column.
This is from WPLE_ListingQueryHelper.php line number 978
To fix the issue `
Change the query statement line number 978
like
<strong>”SELECT *, l.details as details”</strong> to <strong>SELECT *, l.details as details, l.listing_duration</strong>$items = $wpdb->get_results(" SELECT *, l.details as details, l.listing_duration FROM $table l $join_sql $where_sql ORDER BY $orderby $order LIMIT $offset, $per_page ", ARRAY_A);
- The topic ‘Query aren't giving correct result on ebay listing page.’ is closed to new replies.