[Resolved] How to modify view’s query on fly

[Author]

Posts

[Kostas]

I am trying to: build a cpt custom search.

Link to a page where the issue can be seen: hidden link
If radio Blend is checked at Yes (Ναι, second choice) and you press the search button (ΑΝΑΖΗΤΗΣΗ), then mysql server goes to 100% and the query after a while times out.

I expected to see: something like when the search is made with radio Blend set at default No (Όχι, first choice)

Instead, I got: an empty page.

Please note that when the search is made with Blend set at Yes (Ναι, second choice), the query is constructed using wpv_filter_query filter (in functions.php), as per this ticket:
https://toolset.com/forums/topic/conditional-search-how-to/

[Minesh]

Hello. Thank you for contacting the Toolset support.

Well - I need to understand here why there are too many query filter argument is added:

array(
                        'relation' => 'OR',
                        array(
                            'key'     => 'wpcf-variety-member1',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member2',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member3',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member4',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member5',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member6',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member7',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
						),
                    )

Could you please check the server logs what is the cause behind the times out error.

I see there are a number of fields added but it needs to check further. What if you try to remove field arguments one by one and check what field argument is causing the issue?

[Kostas]

Hi Minesh,

Thank you for responding.

The problem started as soon as I added the last filter:

                    array(
                        'key'     => 'wpcf-pungent',
                        'value'   => $_GET['wpv-wpcf-pungent_min'],
                        'type'    => 'NUMERIC',
                        'compare' => '>=',
                    ),
	            array(
                        'key'     => 'wpcf-pungent',
                        'value'   => $_GET['wpv-wpcf-pungent_max'],
                        'type'    => 'NUMERIC',
                        'compare' => '<=',
                    ),

Before that addition it was running fine, although Query Monitor plugin was reporting a slow query (as I found out later).

Kostas

[Minesh]

What if you try, as I think it needs "AND" clause condition:

array(
   'relation' => 'AND',
array(
        'key'     => 'wpcf-pungent',
        'value'   => $_GET['wpv-wpcf-pungent_min'],
        'type'    => 'NUMERIC',
        'compare' => '>=',
    ),
array(
        'key'     => 'wpcf-pungent',
        'value'   => $_GET['wpv-wpcf-pungent_max'],
        'type'    => 'NUMERIC',
        'compare' => '<=',
    ),
)

[Kostas]

I tried it, no difference.

Also please note, Apache logs show this (for my dev machine having an exact site copy):

[Mon Dec 17 12:00:15 2018] [error] [client ::1] FastCGI: comm with server "/Applications/MAMP/fcgi-bin/php7.2.8.fcgi" aborted: idle timeout (30 sec), referer: hidden link
[Mon Dec 17 12:00:15 2018] [error] [client ::1] Handler for fastcgi-script returned invalid result code 1, referer: hidden link

[Minesh]

Well - following query method should work - as it needs "AND" relation with all the greater than and less than query argument which you applied to the same field.:

Could you please try following

$query_args['meta_query'] = array(
                    'relation' => 'AND',
					array('relation' => 'AND',
							array(
								'key'     => 'wpcf-quantity',
								'value'   => $_GET['wpv-wpcf-quantity_min'],
								'type'    => 'NUMERIC',
								'compare' => '>=',
							),
							array(
								'key'     => 'wpcf-quantity',
								'value'   => $_GET['wpv-wpcf-quantity_max'],
								'type'    => 'NUMERIC',
								'compare' => '<=',
							),
					),
                    array(
                        'key'     => 'wpcf-oo-category',
                        'value'   => $_GET['wpv-wpcf-oo-category'],  //
                        'type'    => 'CHAR',
                        'compare' => 'LIKE',
                    ),
					array('relation' => 'AND',
						array(
							'key'     => 'wpcf-oleicacid',
							'value'   => $_GET['wpv-wpcf-oleicacid_min'],
							'type'    => 'NUMERIC',
							'compare' => '>=',
						),
						array(
							'key'     => 'wpcf-oleicacid',
							'value'   => $_GET['wpv-wpcf-oleicacid_max'],
							'type'    => 'NUMERIC',
							'compare' => '<=',
						),
					),
					array('relation' => 'AND',
						array(
							'key'     => 'wpcf-fruity',
							'value'   => $_GET['wpv-wpcf-fruity_min'],
							'type'    => 'NUMERIC',
							'compare' => '>=',
						),
						array(
							'key'     => 'wpcf-fruity',
							'value'   => $_GET['wpv-wpcf-fruity_max'],
							'type'    => 'NUMERIC',
							'compare' => '<=',
						),
					),
					array('relation' => 'AND',
						array(
							'key'     => 'wpcf-bitter',
							'value'   => $_GET['wpv-wpcf-bitter_min'],
							'type'    => 'NUMERIC',
							'compare' => '>=',
						),
						array(
							'key'     => 'wpcf-bitter',
							'value'   => $_GET['wpv-wpcf-bitter_max'],
							'type'    => 'NUMERIC',
							'compare' => '<=',
						),
					),
					array('relation' => 'AND',
						array(
							'key'     => 'wpcf-pungent',
							'value'   => $_GET['wpv-wpcf-pungent_min'],
							'type'    => 'NUMERIC',
							'compare' => '>=',
						),
						array(
							'key'     => 'wpcf-pungent',
							'value'   => $_GET['wpv-wpcf-pungent_max'],
							'type'    => 'NUMERIC',
							'compare' => '<=',
						),
					),
					array(
                        'relation' => 'OR',
                        array(
                            'key'     => 'wpcf-variety-member1',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member2',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member3',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member4',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member5',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member6',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
                        ),
                        array(
                            'key'     => 'wpcf-variety-member7',
                            'value'   => $_GET['wpv-wpcf-variety'],
                            'type'    => 'CHAR',
                            'compare' => 'LIKE',
						),
                    ),	
            );

Does above query makes any difference?

[Kostas]

I 'm afraid not, no difference.

[Minesh]

Sorry hear that there is no difference. I need access details to see whats causing the issue especially FTP access.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I would additionally need your permission to de- and re-activate Plugins and the Theme, and to change configurations on the site. This is also a reason the backup is really important. If you agree to this, please use the form fields I have enabled below to provide temporary access details (wp-admin and FTP).

I have set the next reply to private which means only you and I have access to it.

[Minesh]

Well - I know you shared admin access but that will not be helpful as I need to add/remove things from the functions.php file where you added the code. Please share FTP access details so I can work on it.

[Minesh]

Unfortunately, FTP access details you shared is not working at this end. Could you please send me working FTP/SFTP access details.

I have set the next reply to private which means only you and I have access to it.

[Minesh]

Still - the shared FTP access details not working. I also checked with my colleague for him as well the shared FTP access details not working.

Could you please send me working FTP/SFTP access details.

I have set the next reply to private which means only you and I have access to it.