Jill eagle casino promo code.Makakuha ng libreng 700pho sa bawat deposito

ali1212
(@ali1212)

3 years, 1 month ago

Hi

We are an issue with the plugin, its stopping us from using WP Job Manger. When we have MAS Companies plugin activated we are unable to search using keywords, location

https://apprenticeships.completeapprenticeshipguide.com/

For example when I try and search accountant there are no results when MAS Companies plugin is activate

https://apprenticeships.completeapprenticeshipguide.com/apprenticeships/?customize_autosaved=on&customize_changeset_uuid=24a3b4dd-feaf-4b48-a442-334d24fd11c5&search_keywords=accountant&search_location=&search_category=0

However there is a job with accountant in its job title

https://apprenticeships.completeapprenticeshipguide.com/job/assistant-accountant-apprenticeship/?customize_changeset_uuid=24a3b4dd-feaf-4b48-a442-334d24fd11c5&customize_autosaved=on

And it’s the same for location; searching just location as ‘Tonbridge’ we have zero results again when MAS Companies plugin is active

https://apprenticeships.completeapprenticeshipguide.com/apprenticeships/?customize_autosaved=on&customize_changeset_uuid=24a3b4dd-feaf-4b48-a442-334d24fd11c5&search_keywords=chef&search_location=&search_category=0

And for the Geocoding most of the jobs aren’t even showing on the map when MAS Companies plugin is active

Is there a simple code change that we can make to fix both issues?

Kind regards,
Alistair

The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)

Thread Starter

(@ali1212)

Seems to not have a problem with the keyword Chef but doesn’t work with any other keyword

https://apprenticeships.completeapprenticeshipguide.com/browse-jobs/?search_keywords=marketing&search_location=Crowborough%2C+UK&search_category=0

Best regards,
Alistair`

This reply was modified 3 years, 1 month ago by ali1212.
This reply was modified 3 years, 1 month ago by ali1212.

Thread Starter

ali1212

(@ali1212)

3 years, 1 month ago

This is the error code

Warning: mysqli_query(): (21000/1242): Subquery returns more than 1 row in /home/clasmawb/apprenticeships.completeapprenticeshipguide.com/wp-includes/wp-db.php on line 2162

WordPress database error: [Subquery returns more than 1 row]
SELECT SQL_CALC_FOUND_ROWS wpft_posts.ID FROM wpft_posts INNER JOIN wpft_postmeta ON ( wpft_posts.ID = wpft_postmeta.post_id ) WHERE 1=1 AND ( (((wpft_posts.post_title LIKE '%accountant%') OR (wpft_posts.post_excerpt LIKE '%accountant%') OR (wpft_posts.post_content LIKE '%accountant%'))) OR ( wpft_posts.ID IN ( SELECT post_id FROM wpft_postmeta WHERE meta_key IN ( '_job_location','_company_name','_application','_company_name','_company_tagline','_company_website','_company_twitter' ) AND meta_value LIKE '%accountant%' ) OR wpft_posts.ID IN ( SELECT object_id FROM wpft_term_relationships AS tr LEFT JOIN wpft_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id LEFT JOIN wpft_terms AS t ON tt.term_id = t.term_id WHERE t.name LIKE '%accountant%' ) OR wpft_posts.ID IN ( SELECT post_id FROM wpft_postmeta WHERE meta_key IN ( '_company_id' ) AND meta_value Like ( SELECT ID FROM wpft_posts WHERE post_type IN ( 'company' ) AND post_title LIKE '%accountant%' ) ) ) ) AND ( ( ( wpft_postmeta.meta_key = 'geolocation_formatted_address' AND wpft_postmeta.meta_value LIKE '%Tonbridge, UK%' ) OR ( wpft_postmeta.meta_key = '_job_location' AND wpft_postmeta.meta_value LIKE '%Tonbridge, UK%' ) OR ( wpft_postmeta.meta_key = 'geolocation_state_long' AND wpft_postmeta.meta_value LIKE '%Tonbridge, UK%' ) ) ) AND wpft_posts.post_type = 'job_listing' AND ((wpft_posts.post_status = 'publish' OR wpft_posts.post_status = 'expired')) GROUP BY wpft_posts.ID ORDER BY wpft_posts.menu_order ASC, wpft_posts.post_date DESC, wpft_posts.ID DESC LIMIT 0, 10

Plugin Contributor

Kader Ibrahim S

(@ibndawood)

2 years, 11 months ago

Hello Alistair,

Thank you for trying out our plugin. We are sorry that we could not respond earlier.

I looked into the issue that you’ve raised. Can you please de-activate the all other plugins and the theme. Just use only WPJM and our plugin along with WordPress default theme. Are you able to reproduce this issue? Please confirm.

Kindest Regards,
Ibrahim

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Search Logic and Geocoding Not Working’ is closed to new replies.