Change the category of all posts in it
UPDATE wp_term_relationships SET term_taxonomy_id = 112 WHERE term_taxonomy_id = 1448 Try this
mysql
Removing a wordpress multisite installation and preserving the database before migrate to nginx
You can try a couple of things. WordPress has a built-in Importer/Exporter you can find under the Tools menu: The tool is a bit hit or miss, your mileage may vary. Alternatively, you can do the following: First, take backups of everything!! It sounds like you already have, but do it again, just in case. … Read more
Get WooCommerce product details and transfer them to a custom DB table
With wc_get_products() you will get an array of WC_Product Objects. Get product properties Each WC_Product Object is a CRUD object with protected data. That data is accessible using related WC_Product and WC_Data methods. For custom meta data (or custom fields), you will use the WC_Data get_meta() method on your specific meta_keys that you can find … Read more
Bulk edit existing shortcode within custom field
In phpMyAdmin: update wp_postmeta set meta_value = replace(meta_value,'[idx-listings’,'[idx-listings showlargerphotos=”true”‘); As long as you’ve always typed the shortcode starting with [idx-listings and not, say, [ idx-listings, this will add your new attribute everywhere the shortcode has been used.
Show MySQL errors that occur when I excute $wpdb->insert()
This doesn’t answer your question directly, but the solution here is to validate the data before you chuck it at the database and pray. Sending bad data ‘down the line’ so that something else can check it and report back to you if it wasn’t what they were expecting is bad design. You don’t know … Read more
mysqli_error() expects parameter 1 to be mysqli, null given in own db class
This isn’t a WordPress question it’s a PHP question, but probably what’s happening is that you need to declare global $con everywhere before you both use and set $con. So in your sql.inc.php put a global $con; before you set it the first time. Then obviously make sure you do global con; before every place … Read more
How to remove Database Table in WordPress via Function file?
Add this to functions.php function delete_wpbr_rank_math_sc_analytics() { if ( ! isset( $_GET[‘delete_wpbr_rank_math_sc_analytics’] ) ) { return; } global $wpdb; $wpdb->query( “DROP TABLE IF EXISTS wpbr_rank_math_sc_analytics” ); } add_action( ‘admin_init’, ‘delete_wpbr_rank_math_sc_analytics’ ); Visit this URL: https://yoursite.com/wp-admin/?delete_wpbr_rank_math_sc_analytics Obviously change “yoursite.com” to your actual domain. I made it so you have to visit a specific URL so it … Read more
why update and delete query not worked in custom table?
On the line where you’re defining $id: <?php $id= $result->id; global $wpdb; You’re getting the $id field in $result. $result is an array of the objects returned from the database get_results call. It looks like you want to use the $print variable for the current row in the loop, so $id = $print->id.
add_post_meta does not respect the content
Why the content is not being respected And it’s not just add_post_meta(), but any functions like add_term_meta() and add_user_meta() that uses add_metadata(). And the reason why the value gets serialized again is because add_metadata() will automatically serialize the meta value using maybe_serialize() which (unfortunately) will serialize the value even if it’s already serialized. How to … Read more
MySQL CPU Usage Surge up When Multiple Post Editor Pages are open
After searching the web over the night I found out that the problem is common and the same query I posted above is the culprit. According to WordPress Post Editor Performance, this is caused by Slow meta_form() database query The safest solution he provided was a piece of code the function.php. I did that and … Read more