Ok so I’ve gotten some interesting results. For one I couldn’t get any debug out put with the slideshow on so I removed that. I was hopeful that removing that might fix the random problem but unfortunately it didn’t.
Once I got the debug output it was quite long. Not sure what to make of it all but I did notice that in one of the outputs the orderby line was ORDER BY RAND() DESC.
Is it possible that using the do_shortcode() function is having an adverse effect because that is how I’m implementing it in my theme outside of the post.
this is my code:
echo do_shortcode(‘[mla_gallery mla_debug=\’true\’ attachment_category=\’home-banner-images\’ type=\’default\’ style=\’no-strip\’ fx=\’fade\’ slideshow_height=\’267\’ columns=\’3\’ thumb_width=\’75\’ thumb_height=\’75\’ thumbnail_size=\’thumbnail\’ slide_size=\’thumbnail\’ timeout=\’5000\’ speed=\’1000\’ orderby=\’rand\’ ]’);
and this is the debug output:
mla_debug WHERE filter = ‘ AND ( wp_term_relationships.term_taxonomy_id IN (7) ) AND (wp_posts.post_mime_type LIKE \’image/%\’) AND wp_posts.post_type = \’attachment\’ AND ((wp_posts.post_status = \’inherit\’) OR (wp_posts.post_status = \’inherit\’ AND (p2.post_status = \’inherit\’)))’
mla_debug modified WHERE filter = ‘ AND ( wp_term_relationships.term_taxonomy_id IN (7) ) AND (wp_posts.post_mime_type LIKE \’image/%\’) AND wp_posts.post_type = \’attachment\’ AND ((wp_posts.post_status = \’inherit\’) OR (wp_posts.post_status = \’inherit\’ AND (p2.post_status = \’inherit\’)))’
mla_debug query = array ( ‘attachment_category’ => ‘home-banner-images’, ‘orderby’ => ‘rand’, ‘post_type’ => ‘attachment’, ‘post_status’ => ‘inherit’, ‘post_mime_type’ => ‘image’, ‘nopaging’ => true, ‘ignore_sticky_posts’ => true, ‘no_found_rows’ => true, )
mla_debug request = ‘SELECT wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_posts AS p2 ON (wp_posts.post_parent = p2.ID) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (7) ) AND (wp_posts.post_mime_type LIKE \’image/%\’) AND wp_posts.post_type = \’attachment\’ AND ((wp_posts.post_status = \’inherit\’) OR (wp_posts.post_status = \’inherit\’ AND (p2.post_status = \’inherit\’))) GROUP BY wp_posts.ID ORDER BY RAND() DESC ‘
mla_debug query_vars = array ( ‘attachment_category’ => ‘home-banner-images’, ‘orderby’ => ‘rand’, ‘post_type’ => ‘attachment’, ‘post_status’ => ‘inherit’, ‘post_mime_type’ => ‘image’, ‘nopaging’ => true, ‘ignore_sticky_posts’ => true, ‘no_found_rows’ => true, ‘error’ => ”, ‘m’ => 0, ‘p’ => 0, ‘post_parent’ => ”, ‘subpost’ => ”, ‘subpost_id’ => ”, ‘attachment’ => ”, ‘attachment_id’ => 0, ‘name’ => ”, ‘static’ => ”, ‘pagename’ => ”, ‘page_id’ => 0, ‘second’ => ”, ‘minute’ => ”, ‘hour’ => ”, ‘day’ => 0, ‘monthnum’ => 0, ‘year’ => 0, ‘w’ => 0, ‘category_name’ => ”, ‘tag’ => ”, ‘cat’ => ”, ‘tag_id’ => ”, ‘author_name’ => ”, ‘feed’ => ”, ‘tb’ => ”, ‘paged’ => 0, ‘comments_popup’ => ”, ‘meta_key’ => ”, ‘meta_value’ => ”, ‘preview’ => ”, ‘s’ => ”, ‘sentence’ => ”, ‘fields’ => ”, ‘menu_order’ => ”, ‘category__in’ => array ( ), ‘category__not_in’ => array ( ), ‘category__and’ => array ( ), ‘post__in’ => array ( ), ‘post__not_in’ => array ( ), ‘tag__in’ => array ( ), ‘tag__not_in’ => array ( ), ‘tag__and’ => array ( ), ‘tag_slug__in’ => array ( ), ‘tag_slug__and’ => array ( ), ‘suppress_filters’ => false, ‘cache_results’ => false, ‘update_post_term_cache’ => true, ‘update_post_meta_cache’ => true, ‘posts_per_page’ => 10, ‘comments_per_page’ => ’50’, ‘taxonomy’ => ‘attachment_category’, ‘term’ => ‘home-banner-images’, ‘order’ => ‘DESC’, )
