Remove the call to $wpdb->prepare(): $result = $wpdb->get_var( “SELECT DISTINCT meta_value FROM $metatable WHERE meta_key LIKE ‘%matchme%’ AND meta_value IS NOT NULL AND meta_value <> ”” ); In this case, the $wpdb->prepare() function is not doing anything. There are no variables holding unknown values, therefore there is no need to sanitize them. If you did … Read more
As others have already mentioned, this can be a long process. But it can also be relatively straightforward, and I’ve done this to migrate other non-WP sites to WordPress in the past. Export your site First things first, you’ll need to export your site from Tumblr into a format WordPress can work with. There are … Read more
WordPress actually specifies no table type in the create statements, so it uses MySQL’s default table engine which is InnoDB from version 5.5 onwards.
The GUID should not be used to generate any URLs for the site (caveat below), so it shouldn’t hurt to leave them as they are… unless some badly designed plugin decides that GUIDs are a great shortcut to getting an URL. What the GUID is, is a globally unique identifier– global as in “throughout all … Read more
Today, I was trying to insert an imported data into WordPress. I was using wp_insert_post to insert data, and it threw the following error: WP_Error Object ( [errors] => Array ( [db_update_error] => Array ( [0] => Could not update post in the database ) ) [error_data] => Array ( ) ) My friend said … Read more
TL;DR: It’s not a bug (as we generally understand it), rather it’s a feature that was never fully implemented in WordPress. Status of register_post_status() register_post_status() function was never fully implemented in WordPress. If you check WordPress Codex entry for register_post_status() function, you’ll see it’s clearly mentioned in a notice: NOTICE: This function does NOT add … Read more
As the other gentlemen have mentioned in the comments, due to the libraries that source uses, strings are returned. If you need to convert to an integer for a comparison or function call, just use WordPress’s absint function . $int_id = absint( $wp_posts[0]->ID ); Also, not sure if your DB call is just simply an … Read more
What you’re talking about is a database fallback. It’s possible to set something like this up, but not directly with WordPress. How it would work Instead of accessing the database directly, you’d access a proxy. This proxy would sit in front of both your primary and backup databases and pass traffic through. Essentially, it would … Read more
No, post ID can not be 0 in the DB. But the value 0 has a special meaning in the code, indicating the currently handled post (if the context is set up correctly)
I’ve read that dumping the database as text and searching in it is a good way to go. You can search with phpmyadmin, but it’s limited. Depends on the size of the database and a good text editor, but you can delete post/page revisions before dumping the database to bring it down in size. Or … Read more