Use WP-CLI to remove all tables from the database in MySQL. Runs DROP_DATABASE and CREATE_DATABASE MySQL statements using DB_HOST, DB_NAME, DB_USER and DB_PASSWORD database credentials specified in wp-config.php. wp db reset –yes
I’m not entirely sure what the problem is, because you’ve already mentioned all the tools that you need to solve it… Just use pre_get_posts filter, check if the user is logged in, get the IDs of posts he should not see and exclude them in query: function remove_some_posts_for_user( $query ) { if ( ! is_admin() … Read more
I can’t comment due to low reputation so sorry for posting this as an answer, but you are missing $ (dollar sign) near groupcat[0]
First, can use meta_query, but, you should change your values to use the proper date format, e.g. 2020/01/02 for January 2nd, rather than a regional format. See https://en.wikipedia.org/wiki/ISO_8601 for more details. Second, your LIKE query is going to be very expensive, and achieving what you want while still using a LIKE query will be even … Read more
It looks like this is the new part of this query causing the problem, is that right? (SELECT term_taxonomy_id FROM wp_BOMEGAterm_relationships WHERE object_id = p.ID) AS categories If so the error message is clear: a sub-select in this query should only return one row. If it returns more than one row it doesn’t know how … Read more
That $query->have_posts() modifies the global $post variable which is also used on the admin side, and on the front-end/public side of the site, you would simply call wp_reset_postdata() to restore the global $post back to the post before you call the $query->have_posts(). But on the admin side, you need to manually restore the variable like … Read more
There are no default sorting to show a specific term posts on top of others. So need some tricks to achieve it. You can check this answer, should be helpful. https://wordpress.stackexchange.com/a/161168/102213
I am assuming you are trying to retrieve data from that route and display that to the end user? Instead of using the rest API to retrieve that information, you could put the callback function directly into your template file and then use the php $_GET variable (php docs) to pass the search term into … Read more
The post title and inline “Edit” links in the posts list table at wp-admin/edit.php uses get_edit_post_link() which applies a filter hook also named get_edit_post_link, so if (I correctly understood that) you want to modify those links (URL), you can use that filter. E.g. // Note: The callback will run anywhere, not just at wp-admin/edit.php add_filter( … Read more
As far as I remember category__not_in takes array of IDs, which are pain to use when written as string. For single category it would is easier to write it as cat=-14 (minus before ID). See Category Parameters in Codex. PS I think you meant query_posts(), not query()?..