remove wordpress post links
remove wordpress post links
mysql
MySQL query to list users who never signed in
What MySQL query can I use to get a list of users who have never logged in to WP? None. WordPress does not store this information so this is not something you can do, you would need to add code for it but that would also require going back to 2015 to add the code … Read more
Update WooCommerce Short Description using SQL
You should never change the database structure,, if you just wanna display the short description in place of description there are hooks and filters you can use alternatively you can override the plugin file that displays the single products by creating a woocommerce directory and add tha file in the same hierarchy as in the … Read more
Execute multiple PHP Snippets causes error?
Maybe I’m misunderstanding something, and it’s still not clear to me how you’re using this code, but it seems like a straightforward PHP error. You can’t declare an independent function with the same name twice. You declare (or define) the function with the function function_name() only once, and then you can call it by name. … Read more
How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
The easy way is to just write PHP to go through all the posts and call wp_update_comment_count() on each post ID.
Assign a tag to custom post type using a query
Put code below to your functions.php add_filter(‘pre_get_posts’, ‘query_post_type’); function query_post_type($query) { if(is_category() || is_tag()) { $post_type = get_query_var(‘post_type’); if($post_type) $post_type = $post_type; else $post_type = array(‘post’,’cpt’); // replace cpt to your custom post type $query->set(‘post_type’,$post_type); return $query; } }
Getting invalid user ID error when creating a new user with wp_insert_user
Getting invalid user ID error when creating a new user with wp_insert_user
Where other than wp-config can database access details be defined?
A quick way to disable all plugins is to rename the wp-content\plugins folder. You’ll get some complaints on the wp-admin pages about missing plugins getting disabled, but you knew that. Database access details are in the wp-config.php file in the root of your WP installation. Usually plugins are the main cause of weirdness. Error logs … Read more
Share or sync user table data with another user table
Welcome to WPSE. Asking for plugin recommendations is considered off-topic here, so here’s an action approach to the problem. wp_insert_user() takes care of adding new users to the database. The last action the function fires is user_register, which “Fires immediately after a new user is registered”. You could hook your function to this action and … Read more
Need SQL query to find&replace image URL
If you don’t have WPCLI installed, but still have commandline access or access via PHPMyAdmin, run: UPDATE wp_posts SET post_content = REPLACE(post_content,'<old URL>’,'<new URL>’); UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'<old URL>’,'<new URL>’);