I have the latest version of wp-rentals, db etc. installed and have started to receive the following db error.
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))) AND www_posts.post_type = ‘wpestate_message’ AND (www_posts.post_status = ‘’ at line 1]
SELECT SQL_CALC_FOUND_ROWS www_posts.ID FROM www_posts WHERE 1=1 AND ((())) AND www_posts.post_type = 'wpestate_message' AND (www_posts.post_status = 'publish' OR www_posts.post_status = 'expired' OR www_posts.post_status = 'future' OR www_posts.post_status = 'draft' OR www_posts.post_status = 'pending' OR www_posts.post_status = 'private') ORDER BY www_posts.post_date DESC LIMIT 0, 20
The error is in the www_posts but have no idea how to fix this.
To invoke the error you only need go to any of the sections, Properties, Booking, etc and search with an empty field.
wp rentals have not seen this before only asking to re-install wp.
If anyone can offer any help or advice, its much appreciated.