Something tells me that it could be the maximum script execution timing out perhaps. The amount of memory your inserts are consuming could also be the culprit. Are you getting any error messages, blank screens or anything like that? You could try adding the following above where you’re calling the wp_insert_post() function: set_time_limit(0);
I am setting up Subdomain based MU on my domain. Just remember, what used to be called “WordPress MU” is now “WordPress Multisite.” It’s not a separate application, just a configuration setting you use within WordPress. Will I be better off setting the MySQL user’s domain as localhost, 127.0.0.1 or with a wildcard %.mydomain.com? Which … Read more
DISCLAIMER : Only a MySQL DBA, not WordPress expert You could migrate the database as follows: Very first thing is to locate the my.ini for MySQL. Search all data volumes until you locate my.ini Next, login to MySQL and run SHOW VARIABLES LIKE ‘datadir’; This will tell you what folder MySQL data is stored. For … Read more
If I understand your question correctly, this should work: function get_event_info($event_id = 0, $info = ” ) { global $wpdb; return $wpdb->get_col( $wpdb->prepare( “SELECT meta_value from $wpdb->postmeta WHERE meta_key = ‘%s’ AND post_id IN (SELECT DISTINCT post_id FROM $wpdb->postmeta WHERE meta_key = ‘event_id’ AND meta_value= %s )”, $info, $event_id ) ); } Use this like … Read more
So I figured out the issue. I wasn’t familiar enough with how urls are handled in XMLHttpRequest. I needed to change downloadUrl(“http://wp-content/themes/oxygen-child/phpsqlajax_genxml3.php”, function(data) { to downloadUrl(“http://www.theworldsflgiht.com/wp-content/themes/oxygen-child/phpsqlajax_genxml3.php”, function(data) { Thanks for the help everyone!
Following the recomendations of @toscho i had a look at get_results and the following edits to the function ended up doing the trick. if ( ! function_exists( ‘get_meta_values’ ) ) { function get_meta_values( $key = ”, $type=”post”, $status=”publish” ) { global $wpdb; if( empty( $key ) ) return; $r = $wpdb->get_results($wpdb->prepare( ” SELECT pm.meta_value, pm.post_id … Read more
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
I would do it in php in two parts rather than one big raw sql statement, for safety reasons, eg in your “functions.php” put: function wpse160706() { $old_post_type=”films”; $new_post_type=”post”; $category_slug = ‘directors’; $taxonomy = ‘category’; global $wpdb; $sql = $wpdb->prepare( ‘SELECT p.ID FROM ‘ . $wpdb->posts . ‘ AS p’ . ‘ JOIN ‘ . … Read more
Although this is possible, it really is not viable. I’ve done a lot of research on this subject, but could not find a straight forward answer I went and had a look at the WP_Query class for a possible solution, and I came to the conclusion that what I was trying to accomplish would not … Read more