MYSQL Join on meta key value?
You can update just joining both table on comparing same userid. like: update t1 join t2 on t1.user_id = t2.user_id set t1.meta_value = t2.desc;
mysql
XML RPC post produces immediate revision with odd post_date_gmt
Alright. I think I cracked it. <dateTime.iso8601>20140111T20:39:15</dateTime.iso8601> Should be: <dateTime.iso8601>20140111T20:39:15Z</dateTime.iso8601> Looks like the toolkit I was using didn’t quite implement iso8601 perfectly (or wordpress isn’t – not sure). I’m using Node WordPress and tracked down that it uses the module Node XML RPC to actually send the XML RPC. This seems to be where the … Read more
optimise SQL wordpress call
The query itself may need to be optimized (SQL is not my speciality, though). However, don’t forget you can store the results of an expensive operation in cached memory. WordPress offers a Transients API to make things easy. Here’s a quick example: // Try to load the value from cache $transient_key = ‘my_query’; $value = … Read more
Splitting One Big WordPress Site into Multiple Small Sites
If the content is interconnected, and your content is as you have posts in both categories, you can’t split it without losing some of the capabilities that you have now (search will be one of them). 4.- Yes, improve your server settings or use more servers.
“MySQL server has gone away” since update to 3.8
Fixed this by setting max_allowed_packet = 16M in my.cnf and restarting mysql
meta_query dates from an array
If you store the meta as a serialized array, you should do meta query like this: $args = array( ‘post_type’ => ‘income’, ‘meta_query’ => array( array( ‘key’ => ‘income_dates’, ‘value’ => “2014-02-01”, ‘compare’ => ‘LIKE’ ), ) );
Linking Plugin Files to WP
You need to include the “capability” to use $wpdb in your page. Include this in your page and see what happens. <?php $path = $_SERVER[‘DOCUMENT_ROOT’]; include_once $path . ‘/wp-load.php’;
Plugin data shared in Multisite
You are asking a question that is specific to a plugin and not WordPress. How the plugin functions depends entirely on the plugin author’s design. Reading the article above, sure the plugin works in WP multsite, but as the author mentions extra works needs to be done to share that content among other mulisite sites. … Read more
Using the same shortcode to show any table from the database
Using the same shortcode to show any table from the database
wp_postmeta – lot of meta fields
Those are not Core entries so far as I know. That means that a plugin or a theme has inserted them. Since I don’t know which plugin or theme it is, or whether you are still using that plugin/theme, I can’t say whether you should delete the entries. If you are still using the plugin … Read more