Unanswered Questions
2,374 questions with no upvoted or accepted answers
5
votes
1
answer
1k
views
Order wp_query by calculated field
Hi I'm working on a store locator.
I have a custom post "clinics" where I save clinic details (address,.., lat, lng). Each time I publish a new clinic I save post_id, lat and lng also in a custom ...
5
votes
1
answer
12k
views
wp_query->max_num_pages always returns 0 on custom post type
Hi there I am developing a theme where I have to load some posts with ajax, in my index page everything works properly, the problem is when I need to use it on custom post type, I pass the values for ...
5
votes
2
answers
790
views
Extending WP_Query — Optimise SQL query
I'm storing posts, a user follows in a custom table that has the columns id, post_id and user_id. To fetch posts that a user follows I have extended the WP_Query as follows:
class ...
4
votes
1
answer
858
views
How can I list only sites that use a particular theme or plugin?
I need to search through dozens of WordPress multisite (network enabled) installs for sites that use a particular plugin.
How can I list only sites that use a particular theme or plugin, preferably ...
4
votes
1
answer
3k
views
WP_Query min and max values
I'm building a houses class and I want to filter these houses with a query. But don't get any results:
Example house:
Min price: 10
Max price (field not required): empty
I've a price filter ...
4
votes
0
answers
798
views
Order posts by meta_value even if meta_key is not filled
I want to sort search results by the value of custom field ('name-official') for all posts (is this field filled or not).
But when I add filter in function.php like
function searchExcludePages($query)...
4
votes
2
answers
2k
views
How do I order pages and categories by ID or name in the same query?
I would like to query most of my pages and categories on the homepage. So far I am able to get the pages and category (posts), but I cannot order the list the way I want to. I want to be able to get a ...
4
votes
1
answer
644
views
Get page content by category or tag
I'm trying to sort of emulate the Views behaviour in Drupal with WordPress, but doing it in theme templates.
Now, I have pages that are assembled by using wp_query in the template to get posts ...
4
votes
1
answer
353
views
How to sort posts by last name (2nd word) on ONE category only?
I have an "author" category that is used as a list to browse multiple posts containing author biographies. I have Smart Category Ordering installed and right now it is sorted by title ascending. ...
3
votes
1
answer
3k
views
How to get orders with used coupon in WooCommerce
Im trying to get orders in WooCommerce (ideally through wc_get_orders) where the coupon code "some_code" was used.
My try:
function get_orders_with_coupon($coupon){
$customer_orders = ...
3
votes
1
answer
2k
views
Too many datadabse connections - upper ceiling mysql
We run a high traffic blog with around 500 real-time users and 10000 posts.
We are hosted by self on VPS - 16gb, 4 core with separate mysql DB server - 4gb, 2 core; both SSD.
No problem with hosting ...
3
votes
1
answer
858
views
$wpdb->get_results() does not fetch results with unicode 'WHERE' clause
I've just a simple query to fetch a students records by his name, written in Bengali.
$student_rcrd = $wpdb->get_results("SELECT * FROM student WHERE name='আবুল কালাম আজাদ'");
Although my database ...
3
votes
1
answer
1k
views
Working Bootstrap Carousel Conversion to WP - Technical Questions
I have coded a working Bootstrap carousel, it needs to be converted to WP. It's a small chunk of the site, but as a Wordpress newbie, am stuck in understanding the technical issue.
So here's what I ...
3
votes
1
answer
6k
views
Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
I have a xampp configurated locally to run wordpress. I must have done something wrong when fixing some issues 'cuz at the end, I got stuck with the following log from mysql database.
2015-11-10 15:...
3
votes
0
answers
912
views
Emojis getting converted to "?"
Emojis in posts and comments on a 500+ posts blog get converted automatically into single question marks in irregular and untraceable intervals.
The respective tables wp_comments and wp_posts are ...