antonyvk

I’m looking to adapt my css and other personal tricks for the moment ?? I found a css bug in theme/wppa-styles.css : I think .FotomotoBarLink won’t float left correctly.

Wonderful ! Now I need to prepare updates and test it ??

Hummm, the target is around 20k users/day, so I need to consider lots of new users at start.
Perhaps a good way could be to add a setting for asynchronous creation of users albums (and then call a cron job to check and do it) and an other setting (also activable with shortcode ?) to check if current granted album contains current user album (and then create it if needed, but only for this current granted album). Like that the plugin could be able to create albums once at a turn (so a new user won’t generate lots of inserts at a time), and missing albums will be created by cron job during day or night (with limit or not, depending of server load).
What do you think of this suggestion ?

it’s enabled ?? I looked in log and found that after each flush I have a new line in minify.log but no “adding” line indicating any minified file generation.
What the master.php has to look like when minify is enabled ? I think perhaps there’s a problem in reading config file ?

Haha… basic cookie problem : https://www.wpbeginner.com/wp-tutorials/how-to-fix-wordpress-login-page-refreshing-and-redirecting-issue/

Also found a chmod problem in my config, I don’t have the timeout anymore, but the update request is still processing in mysql, and I’m quite sure it could be useful to paginate my 6000 albums ??

A look in mysql processlist shows me this :
UPDATE wp_options SET option_value = ‘a:5298:{i:1;a:2:{i:0;s:1:\”0\”;i:1;s:1:\”0\…. WHERE option_name = ‘wppa_counts_tree’

the option_value contains more than 216000 chars when I display the full update… looks a bit big !

They don’t need to have the custom field checked. Isn’t this only to sort results ?

Good idea to ask about the theme ! This part is due to it : wp_options.option_name LIKE CONCAT('_ait_directory2-child_elements_opts_page_', wp_posts.ID)
And when I try the query without it it’s really faster (0.12 sec in MySQL).
Now I just have to find how to disable it ! ??

My need is just to find a word in post titles (post titles corresponds to city names, so between 1 and 3 words in each title). So I’d like to disable the params that build the query looking in content and option_value. I also don’t understand why it joins to wp_term_relationships twice (seems to be useless !).

Here is var_dump of $wp_query (with search query that have 3 results) :
object(WP_Query)#2711 (50) { ["query"]=> array(1) { ["s"]=> string(8) "toulouse" } ["query_vars"]=> array(69) { ["s"]=> string(0) "" ["error"]=> string(0) "" ["m"]=> string(0) "" ["p"]=> int(0) ["post_parent"]=> string(0) "" ["subpost"]=> string(0) "" ["subpost_id"]=> string(0) "" ["attachment"]=> string(0) "" ["attachment_id"]=> int(0) ["name"]=> string(0) "" ["static"]=> string(0) "" ["pagename"]=> string(0) "" ["page_id"]=> int(0) ["second"]=> string(0) "" ["minute"]=> string(0) "" ["hour"]=> string(0) "" ["day"]=> int(0) ["monthnum"]=> int(0) ["year"]=> int(0) ["w"]=> int(0) ["category_name"]=> string(0) "" ["tag"]=> string(0) "" ["cat"]=> string(0) "" ["tag_id"]=> string(0) "" ["author"]=> string(0) "" ["author_name"]=> string(0) "" ["feed"]=> string(0) "" ["tb"]=> string(0) "" ["paged"]=> int(0) ["meta_key"]=> string(0) "" ["meta_value"]=> string(0) "" ["preview"]=> string(0) "" ["sentence"]=> string(0) "" ["title"]=> string(0) "" ["fields"]=> string(0) "" ["menu_order"]=> string(0) "" ["embed"]=> string(0) "" ["category__in"]=> array(0) { } ["category__not_in"]=> array(0) { } ["category__and"]=> array(0) { } ["post__in"]=> array(1) { [0]=> int(0) } ["post__not_in"]=> array(0) { } ["post_name__in"]=> array(0) { } ["tag__in"]=> array(0) { } ["tag__not_in"]=> array(0) { } ["tag__and"]=> array(0) { } ["tag_slug__in"]=> array(0) { } ["tag_slug__and"]=> array(0) { } ["post_parent__in"]=> array(0) { } ["post_parent__not_in"]=> array(0) { } ["author__in"]=> array(0) { } ["author__not_in"]=> array(0) { } ["tax_query"]=> array(0) { } ["lang"]=> string(2) "fr" ["post_type"]=> string(8) "ait-item" ["meta_query"]=> array(2) { ["relation"]=> string(3) "AND" ["featured_clause"]=> array(2) { ["key"]=> string(23) "_ait-item_item-featured" ["compare"]=> string(6) "EXISTS" } } ["posts_per_page"]=> int(10) ["orderby"]=> array(2) { ["featured_clause"]=> string(4) "DESC" ["date"]=> string(3) "ASC" } ["ignore_sticky_posts"]=> bool(false) ["suppress_filters"]=> bool(false) ["cache_results"]=> bool(true) ["update_post_term_cache"]=> bool(true) ["update_post_meta_cache"]=> bool(true) ["nopaging"]=> bool(false) ["comments_per_page"]=> string(2) "50" ["no_found_rows"]=> bool(false) ["taxonomy"]=> string(8) "language" ["term"]=> string(2) "fr" ["order"]=> string(4) "DESC" } ["tax_query"]=> object(WP_Tax_Query)#35326 (6) { ["queries"]=> array(1) { [0]=> array(5) { ["taxonomy"]=> string(8) "language" ["terms"]=> array(1) { [0]=> string(2) "fr" } ["field"]=> string(4) "slug" ["operator"]=> string(2) "IN" ["include_children"]=> bool(true) } } ["relation"]=> string(3) "AND" ["table_aliases":protected]=> array(1) { [0]=> string(21) "wp_term_relationships" } ["queried_terms"]=> array(1) { ["language"]=> array(2) { ["terms"]=> array(1) { [0]=> string(2) "fr" } ["field"]=> string(4) "slug" } } ["primary_table"]=> string(8) "wp_posts" ["primary_id_column"]=> string(2) "ID" } ["meta_query"]=> object(WP_Meta_Query)#35331 (9) { ["queries"]=> array(2) { ["featured_clause"]=> array(2) { ["key"]=> string(23) "_ait-item_item-featured" ["compare"]=> string(6) "EXISTS" } ["relation"]=> string(2) "OR" } ["relation"]=> string(3) "AND" ["meta_table"]=> string(11) "wp_postmeta" ["meta_id_column"]=> string(7) "post_id" ["primary_table"]=> string(8) "wp_posts" ["primary_id_column"]=> string(2) "ID" ["table_aliases":protected]=> array(1) { [0]=> string(11) "wp_postmeta" } ["clauses":protected]=> array(1) { ["featured_clause"]=> array(4) { ["key"]=> string(23) "_ait-item_item-featured" ["compare"]=> string(6) "EXISTS" ["alias"]=> string(11) "wp_postmeta" ["cast"]=> string(4) "CHAR" } } ["has_or_relation":protected]=> bool(false) } ["date_query"]=> bool(false) ["queried_object"]=> NULL ["queried_object_id"]=> NULL ["request"]=> string(699) "SELECT DISTINCT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_options ON wp_options.option_name LIKE CONCAT('_ait_directory2-child_elements_opts_page_', wp_posts.ID) WHERE 1=1 AND wp_posts.ID IN (0) AND ( wp_term_relationships.term_taxonomy_id IN (305) ) AND ( wp_postmeta.meta_key = '_ait-item_item-featured' ) AND wp_posts.post_type = 'ait-item' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS CHAR) DESC, wp_posts.post_date ASC LIMIT 0, 10" ["posts"]=> &array(0) { } ["post_count"]=> int(0) ["current_post"]=> int(-1) ["in_the_loop"]=> bool(false) ["comment_count"]=> int(0) ["current_comment"]=> int(-1) ["found_posts"]=> int(0) ["max_num_pages"]=> float(0) ["max_num_comment_pages"]=> int(0) ["is_single"]=> bool(false) ["is_preview"]=> bool(false) ["is_page"]=> bool(false) ["is_archive"]=> bool(false) ["is_date"]=> bool(false) ["is_year"]=> bool(false) ["is_month"]=> bool(false) ["is_day"]=> bool(false) ["is_time"]=> bool(false) ["is_author"]=> bool(false) ["is_category"]=> bool(false) ["is_tag"]=> bool(false) ["is_tax"]=> bool(false) ["is_search"]=> bool(true) ["is_feed"]=> bool(false) ["is_comment_feed"]=> bool(false) ["is_trackback"]=> bool(false) ["is_home"]=> bool(false) ["is_404"]=> bool(false) ["is_embed"]=> bool(false) ["is_paged"]=> bool(false) ["is_admin"]=> bool(false) ["is_attachment"]=> bool(false) ["is_singular"]=> bool(false) ["is_robots"]=> bool(false) ["is_posts_page"]=> bool(false) ["is_post_type_archive"]=> bool(false) ["query_vars_hash":"WP_Query":private]=> string(32) "46c1c1898f55c4ade62968b94a788bad" ["query_vars_changed":"WP_Query":private]=> bool(true) ["thumbnails_cached"]=> bool(false) ["stopwords":"WP_Query":private]=> NULL ["compat_fields":"WP_Query":private]=> array(2) { [0]=> string(15) "query_vars_hash" [1]=> string(18) "query_vars_changed" } ["compat_methods":"WP_Query":private]=> array(2) { [0]=> string(16) "init_query_flags" [1]=> string(15) "parse_tax_query" } }

seems to call it like that (it’s an AIT template) :

{block content}
{? global $wp_query}
{var $query = $wp_query}

{if $query->have_posts()}
	{includePart portal/parts/search-filters, current => $query->post_count, max => $query->found_posts}

	{if defined("AIT_ADVANCED_FILTERS_ENABLED")}
		{includePart portal/parts/advanced-filters, query => $query}
	{/if}

	{includePart parts/pagination, location => pagination-above, max => $query->max_num_pages}

	<div class="items-container">
		{customLoop from $query as $post}
			{includePart parts/post-content}
		{/customLoop}
	</div>

	{includePart parts/pagination, location => pagination-below, max => $query->max_num_pages}

{else}
	{includePart parts/none, message => nothing-found}
{/if}

Not including sub-albums in pcount ? Possible with use_treecounts param ?

Thanks ! I will duplicate my dev environnement to test this pre-release, not sure to have enough time today, probably tomorrow evening !
I have other features questions, I will open a new post for them.

Sure I did it in an ugly way, thanks for the tips ! I will wait for your news and try with good code ??