What is the MYSQL Query to bulk update the canonical URL of specific categories of posts in WordPress?
What is the MYSQL Query to bulk update the canonical URL of specific categories of posts in WordPress?
MySQL
SQL. Select category descendants
SQL. Select category descendants
I want to share local developement and staging DB — Is this very smart or very stupid?
WordPress, and many of its plugins, store configuration data in the database. That alone could cause issues for the setup you described, but the urls of every link will also be stored fully canonicalized. So, unless you plan to test your staging setup from “http://localhost“, you will have serious issues trying to click around multiple … Read more
wpdb insert into point column in db
wpdb insert into point column in db
update multiple rows in mysqli table base on two values
update multiple rows in mysqli table base on two values
WordPress Dutch characters encoding problem
It Turns out the problem was with I was using json_enode to convert the data in to json before inserting it in to database and it was causing the encoding of the characters I have used json_encode($url,JSON_UNESCAPED_UNICODE); and now its working properly.
PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
Regular XML-RPC timeouts
I was able to greatly reduce the severity of the problem by installing/activating the PHP extension file-info, which was flagged by WordPress as a configuration issue. While it didn’t eliminate the issue completely, the lockup only happened once more during my post migration and the unavailability was much shorter than previous occurrences. Now that the … Read more
What is this? MySQL array?
WordPress stores meta and option values in a serialized format if they are objects or arrays. So what you have there is an array (a) with an integer (i) key 0 and a string (s) value with 82 characters.
SQL query to change custom field in WordPress database
Recommend a database backup before you do this. ** updated the statement to specify “Y”, empty string, or null ** global $wpdb; $wpdb->query( “update {$wpdb->postmeta} SET meta_value=”X” WHERE meta_key = ‘old_price’ AND ( meta_value=”Y” OR meta_value=”” OR meta_value IS NULL ) );” );