Database error

We were getting no returns on a search. In investigating further, we found GeoDirectory was throwing a database error. Here is the error…

WordPress database error: [Unknown column ‘wp_geodir_gd_place_detail.gd_placecategory’ in ‘where clause’]
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID NOT IN (5972,5973,5974,5975,5976) AND (((wp_posts.post_title LIKE ‘%\\%%’) OR (wp_posts.post_excerpt LIKE ‘%\\%%’) OR (wp_posts.post_content LIKE ‘%\\%%’))) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘events’, ‘buzz’, ‘gd_place’, ‘clickfunnels’, ‘testimonials’) AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘acf-disabled’ OR wp_posts.post_status = ‘virtual’ OR wp_posts.post_author = 41 AND wp_posts.post_status = ‘private’) AND ( FIND_IN_SET(‘176’, wp_geodir_gd_place_detail.gd_placecategory ) ) ORDER BY wp_posts.post_title LIKE ‘%\\%%’ DESC, wp_posts.post_date DESC LIMIT 0, 12

The site is http://bebomia.com

On my dev server, i’ve done the following:
1) disabled the GD plugins and re-activated with no change.
2) Deleted the GD plugins and re-installed – no change
3) Upgraded all the GD plugins to the latest – no change

I’m guessing the tables haven’t been upgraded properly during one of the updates.

What do I need to do to remove the error and get search working again?

Here is a list of the plugins on the site:
Advanced Custom Fields PRO (5.5.9)
ClickFunnels (3.1.1)
Disable XML-RPC (1.0.1)
Facebook Conversion Pixel (1.3.5)
Favicon by RealFaviconGenerator (1.3.10)
GeoDirectory (1.6.17)
GeoDirectory Advance Search Filters (1.4.7)
GeoDirectory Custom Post Types (1.2.0)
GeoDirectory Location Manager (1.5.31)
GeoDirectory Payment Manager (1.4.4)
GeoDirectory Re-Captcha (1.1.4)Google Analyticator (6.5.2)
Gravity Forms (1.9.17.5)
Gravity Forms Infusionsoft Add-On (1.5.12)
Hotjar Connecticator (1.1.1)
Kraken Image Optimizer (2.6.2)
LeadPages connector (1.2.0.5)
List Plugins (1.4.4)
LiteSpeed Cache (1.0.14.1)
ManageWP – Worker (4.2.16)
Pretty Link (2.0.6)
Redirection (2.5)
Regenerate Thumbnails (2.2.6)
Responsive Menu (3.0.18)
Share Buttons by AddThis (5.3.4)
Simple Custom CSS and JS (2.10)
Testimonials Slider (92.9.5)
Theme My Login (6.4.9)
Velvet Blues Update URLs (3.2.7)
Video Thumbnails (2.12.3)
Wordpress Ad Widget (2.11.0)
WPBakery Visual Composer (5.0.1)
Yoast SEO (4.3)

Thanks for the help.
Dave