ali1212

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

Hi

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 2 years, 9 months ago by ali1212.
• This reply was modified 2 years, 9 months ago by ali1212.

Hi

I’m not using a plugin it’s actually the theme workscout with wp job manager installed.

But workscout uses https://leafletjs.com/ for the maps if that helps.

Best regards,
Alistair

• This reply was modified 2 years, 9 months ago by ali1212.

Resolved