There seems little point in creating a new post entry for each of your products if your table of products already has all of the information you wish to display. Your best bet is to create a single page for example “Product” and then setup your own rewrite rule, using add_rewrite_rule, so that you can … Read more
Put a file named db-error.php into the wp-content directory. Here you can ask the global $wpdb object for more detailed errors: global $wpdb; $wpdb->print_error(); This will print out the last error message if the database handler.
You have a structural problem with your data. Serialized data in the database is terrible if you need to search over pieces of that serialized data. There is no reliable, efficient, and certainly no easy, SQL query to search over serialized data. “serialization” is a PHP mechanism. It isn’t SQL. To the database that is … Read more
There are 2 ways that you could do this. The first and more difficult is to write a program, the other is to do a bulk update. Why do difficult when easy way will work equally well? and especially as this is a once-off requirement The easy way: In the admin dashboard, select the view … Read more
You want to use wp_ajax_nopriv_ for handling ajax for non-authenticated users: // logged-out users add_action( ‘wp_ajax_nopriv_my_action_search_key_press’, ‘action_search_key_press_callback’ ); // authenticated users add_action( ‘wp_ajax_my_action_search_key_press’, ‘action_search_key_press_callback’ );
First, enqueue your script correctly, in functions.php: function my_enqueue_scripts() { wp_enqueue_script(‘jquery’); } add_action(‘wp_enqueue_scripts’, ‘my_enqueue_scripts’); Then, Authenticated users only (see https://codex.wordpress.org/Plugin_API/Action_Reference/wp_ajax_nopriv_(action)) (can also be in functions.php): function fetchData(){ // Not needed anymore, as you manage the case through the `add_action` method // if ( ! is_user_logged_in() ) { // return; // } // this can be … Read more
Using Query Monitor I was able to find the source of this query, it was from a plugin “starbox” which uses the query to fetch the last 3 posts from the author of a given post. Editing the plugin by commenting out the part it runs this query solved the issue.
How can I write a bulk MySQL command to add in the value wp_capabilites=”a:1:{s:10:”subscriber”;b:1;}” into each user_id except 1, 2 and 3 ie. the newly imported users? You don’t. That is a serialized array which is a PHP construct. MySQL has no idea what to do with it. To the database, it is just an … Read more
Turns out, WordPress joins the postmeta table several times, depending on the meta query arguments. Yes that’s correct, and it’s also the reason why I said (in my other answer) that in an orderby array, you should use the key of an array in the meta_query which contains a direct item named/keyed key (where the … Read more
new WP_Query(array(‘tag_slug__in’ => array(‘forrest-gump’, ‘forest-gump’, ‘questend’))); new WP_Query(‘tag=forrest+gump,forest+gump,questend’); should work too…