I am not good at SQL but I believe this SQL query will do the job for you. UPDATE wp_posts SET post_status=”publish” WHERE post_type=”product” AND post_status=”trash”; Please remember to change WP database prefix if it is not default wp.
For testing I just set the external DB to the current DB. As you can see on your own setup they should all fail the check to be created because they all exist (B -> B). Obviously on your ( A -> B ) setup you will get many that will pass as long as … Read more
Try those args: ‘date_query’ => array( //start date array( ‘year’ => $startyear, ‘month’ => $startmonth, ‘compare’ => ‘>=’ ), //end date array( ‘year’ => $endyear, ‘month’ => $endmonth, ‘compare’ => ‘<=’ ) ),
I would say the problem is first array. Change it to array( ‘name’ => $_POST[‘name’] ), You can also use wpdb->show_error() or wpdb->print_error() To Samuel Elh: wpdb->insert() can escape value itself
I assume you’re already properly using the WP Metadata API https://codex.wordpress.org/Metadata_API to attach the field to new comments and you just want to backfill for existing comments by stuffing the database? If it was my problem, I wouldn’t bother and would assume in my code that absence of meta implied no likes. If you use … Read more
Woah there. You’ve just opened up a can of SQL injection. I use the default get_query_var(‘s’) that I believe is automatically escaped by wordpress. Not quite – get_search_query() will do that, but get_query_var( ‘s’ ) gets the “raw” value. Regardless, always use wpdb::prepare or similar escaping before executing SQL: $query = $wpdb->prepare( “SELECT * FROM … Read more
Guess I should have read the error page more carefully, because it contained the answer in plain English. In the factory request is should simply match the request to the response signature (an array in my case), thus becoming: angular.module(“app”).controller(“MainController”, [“$scope”, “commentRepository”, function ($scope, commentRepository) { commentRepository.query(function(data) { $scope.comments = data; }); }]); Instead of … Read more
This is because the value of meta key is inside the if clause and is not set for the else. try else { $key = ‘save-author-to-book’; delete_post_meta( $post_id, $key, $meta_value=””); // break; }
If I understand correctly you wish to retrieve your meta data from the database? Try looking at this WP function: https://developer.wordpress.org/reference/functions/get_metadata/ This will allow you to get the meta data you require dependent on the type of data you want to get, such as post meta data or page meta data etc. An additional read … Read more
I was able to reproduce the error. Here’s what I think is happening. ‘number’ defines the number of users per page, and ‘paged’ tell the query which page to return. For example: $args = array(‘number’ => 2, ‘paged’ => 2) will return the second page at 2 per page. If you don’t have a query … Read more