Database

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 ) );” );

+ More