redeclipse

Great, thank you for the fast response!

Can I ask one other question? If I wanted to search based on TAGS as well as post title names, how can that be done? Does the premium service allow search through Tags as well?

(double post)

I should note that using the Search Everything Plugin, I’ve narrowed down the search results to include only things from Category 26 in the default search bar. Also, when using the Search In Place Plugin’s “MORE RESULTS” link, the results do indeed only show posts of category 26. However the live loading results do not exclude the other categories.

No I have not. I’ve not touched anything. I added a new post to the blog category and the comments disappeared.

Also I should note that for some reason the FB comments are all shared despite the sub pages to the mobile category technically being different pages. It’s the same for the WP comments as well.

I agree, I can’t find any result on this. It really is too long.

Hi David, so the pagination and all works fine now, but it’s still not ordering the content correctly. Changing the coding from DESC to ASC doesn’t do anything either. I’ve tried changing the orderby date to ID, but that did nothing as well. As I mentioned earlier, the current order of the images are random. It is neither alphabetical or by ID/Date. The newest items are see on THIS page. This Test page is displaying gallery items in a peculiar way. Some of these items were uploaded months ago and some just a weeks ago. And it is definitely not alphabetical.

What can we do to get the order right?

Thanks!

Here’s what I have

[mla_gallery my_custom_sql='attachment_category=mobile orderby=date order=DESC' size=medium link=file columns=4 mla_caption='{+parent_title+}' mla_target='_blank' numberposts=40]

<div style="clear: both; float: left">
[mla_gallery attachment_category=mobile posts_per_page=40 mla_output="previous_page,first" mla_link_text='&larr; PREVIOUS' mla_rollover_text="Previous/first page"]
</div>

<div style="float: right">
[mla_gallery attachment_category=mobile posts_per_page=40 mla_output="next_page,last" mla_link_text='NEXT &rarr;' mla_rollover_text="Next/last page"]
</div>

The weird thing is, I don’t even know how what order the current gallery is using. It’s not in alphabetical or date order of any kind.

Yes, is there any way to make the gallery display the LATEST items first and then paginate? It simply isn’t paginating at all now. The PREVIOUS link just refreshes the page.

The loading time is great now, but it’s no longer paginating or showing images based on upload date. It’s just showing the 40. But it’s a step closer! ??

It seems the new Category has stopped showing as well. I think it has something to do with the number of images I have in it. If it is database related I guess there isn’t anything you can do.

Once again, thank you very much for your help.

Thank you. It seems there is a loading time issue when the ATT. Category reaches around 800+ images. The fast attachment loading time I mentioned earlier has now slowed down to a crawl. These images are about 1-3 MB each.

I’ve applied the pagination coding and can clearly feel the lag as it tries to go to the next page. Would this be an issue on my hosts end?

https://www.theforgottenlair.net/test/

Thank you very much for your help.

The Attachment column is accurate and is showing the current number of 1,187. The submenu under ALL ATT Category is also correct in filtering 1,187 items.

I think I’ll reassign a new category to all of them first, before removing “mobile” – if at all. I’ve just tried it and it seems to be working.

I have one more question since I have your help. Right now I’m displaying 40 images on the page to prevent a massive loading problem in displaying thousands. Is there a way to paginate through an entire ATT Category? Let’s say 40 per page and if so, would you foresee any massive loading time in doing this?

Thank you so much for your help. You’ve been extremely kind and patient.

I tested a new Category called “test” and those images displayed fine. (Currently displaying on the TEST Page.) Post_Parent=all also displays just fine. It’s just specifically the “mobile” category stopped displaying, although it is still populating. The “40 out of 1163 wallpapers” uses the number of images in that att. category to auto display that number.

I mentioned earlier this suddenly happened out of nowhere. Just under 24 hours ago it was displaying all images under the “mobile” category just fine. Also, I noticed the attaching process has also sped up since the gallery stopped displaying. It used to take at least 1-2 minutes for the EDIT MEDIA page to update when I attach an image to a category. Now it’s almost instantaneous.

The Mobile Wallpapers page was where this code used to display the same information as the TEST page, however since it stopped working I had to manually input the image ID, which is what you see now.

This is what came up in the debug:

mla_debug empty gallery, query = array ( 'attachment_category' => 'mobile', 'size' => 'medium', 'link' => 'file', 'columns' => '4', 'mla_caption' => '{+parent_title+}', 'mla_target' => '_blank', 'mla_viewer' => 'true', 'numberposts' => '40', 'order' => 'DESC', 'mla_debug' => 'true', 'mla_page_parameter' => 'mla_paginate_current', )
mla_debug $wp_filter[posts_where] priority = 2147483647
filter name = 'MLAShortcodes::mla_shortcode_query_posts_where_filter'
mla_debug $wp_filter[posts_orderby] priority = 2147483647
filter name = 'MLAShortcodes::mla_shortcode_query_posts_orderby_filter'
mla_debug WHERE filter = ' AND ( wp_term_relationships.term_taxonomy_id IN (25) ) 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 (25) ) 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 ORDER BY filter, incoming = 'wp_posts.post_date DESC'
Replacement ORDER BY clause = 'wp_posts.menu_order DESC, wp_posts.ID DESC'
mla_debug posts_clauses filter = array ( 'where' => ' AND ( wp_term_relationships.term_taxonomy_id IN (25) ) 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\')))', 'groupby' => 'wp_posts.ID', 'join' => ' INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_posts AS p2 ON (p2.ID = p2.ID) ', 'orderby' => 'wp_posts.menu_order DESC, wp_posts.ID DESC', 'distinct' => '', 'fields' => 'wp_posts.*', 'limits' => 'LIMIT 0, 40', )
mla_debug posts_clauses_request filter = array ( 'where' => ' AND ( wp_term_relationships.term_taxonomy_id IN (25) ) 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\')))', 'groupby' => 'wp_posts.ID', 'join' => ' INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_posts AS p2 ON (p2.ID = p2.ID) ', 'orderby' => 'wp_posts.menu_order DESC, wp_posts.ID DESC', 'distinct' => '', 'fields' => 'wp_posts.*', 'limits' => 'LIMIT 0, 40', )
mla_debug query = array ( 'attachment_category' => 'mobile', 'post_type' => 'attachment', 'post_status' => 'inherit', 'post_mime_type' => 'image', 'posts_per_page' => 40, 'ignore_sticky_posts' => true, 'no_found_rows' => true, )
mla_debug request = 'SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_posts AS p2 ON (p2.ID = p2.ID) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (25) ) 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 wp_posts.menu_order DESC, wp_posts.ID DESC LIMIT 0, 40'
mla_debug query_vars = array ( 'attachment_category' => 'mobile', 'post_type' => 'attachment', 'post_status' => 'inherit', 'post_mime_type' => 'image', 'posts_per_page' => 40, '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 ( ), 'post_parent__in' => array ( ), 'post_parent__not_in' => array ( ), 'suppress_filters' => false, 'cache_results' => true, 'update_post_term_cache' => true, 'update_post_meta_cache' => true, 'nopaging' => false, 'comments_per_page' => '2', 'taxonomy' => 'attachment_category', 'term' => 'mobile', 'order' => 'DESC', )
mla_debug post_count = 0

Empty Gallery did indeed come up. Thank you for your help on this.

Excellent, it worked! Thank yo so much! I really appreciate the help!