In the post meta you can find the, attachment ID, you need lockup the org file name, and then ether loop throw the images sizes (In the meta data of the attachment) or append -600×600 to the file name if upload and image bigger then 600.
You can’t simply “merge categories” you have to change the category that each post is associated with. The table WP_TERM_RELATIONSHIPS links posts with categories. You could try something like this: UPDATE wp_term_relationships SET term_taxonomy_id = (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 112748) WHERE term_taxonomy_id = (SELECT term_taxonomy_id FROM wp_term_taxonomy WHERE term_id = 112747) You … Read more
Found a problem. Basically there were 2 options that forced my permalinks to https: Settings > General: change the site url from https to http. SEO by Yoast plugin, under section permalinks needed to change Canonical Settings to force HTTP.
I know this is an old question, but for anyone still looking how to achieve this, the following query should do the job: UPDATE wp_users INNER JOIN wp_usermeta AS fn_meta ON wp_users.ID = fn_meta.user_id AND fn_meta.meta_key = ‘first_name’ INNER JOIN wp_usermeta AS ln_meta ON wp_users.ID = ln_meta.user_id AND ln_meta.meta_key = ‘last_name’ SET wp_users.display_name = CONCAT(fn_meta.meta_value, … Read more
Here is an example of getting the user IDs, looping through each, grabbing a meta_key as an array, adding new values to it and remove old values, saving the meta back, then grabbing it again to loop through each item in the array for output. Array is just an example of duplicate keys. $user_query = … Read more
Yes, you can accomplish it by WP default functionality. Let me explain it. 1. While switch theme: There is a switch_theme action that runs right after the theme is switched. switch_theme is triggered when the blog’s theme is changed. Specifically, it fires after the theme has been switched but before the next request. Theme developers … Read more
We ported WP to SQL Server almost three years and have been maintaining it ever since. Provided you are planning to use SQL Express 2012 or higher, this should be the solution you are looking for: Project Nami Simply put, replacing WPDB isn’t enough. So we went a step further and rewrote any MySQL-specific syntax … Read more
Scheduled Post Guardian solved it. I guess scheduling strictly from database is not possible.
In my experience… I would keep using Multisite for your setup for organizational purposes and ease of management. Here’s a list of things you could try before emptying out the pockets: Consider caching options. (Personally, I like using W3TC), but there’s many options for this. Consider Jetpack CDN for images. (I’ve had reasonable success with … Read more
Merging WordPress Standalone Installation with WordPress Multisite Installation Before You Begin: Create a new site in your Multisite Network, which will be the site you’re migrating from the Standalone installation. (Take note of the site ID #, you’ll need it later.) You need to make sure that all of the users from the Standalone installation, … Read more