Are you using a prefix for your WordPress database tables? You can check what this is (I don’t need to know what the prefix is) by editing the wp-config.php file in your wordpress root folder. Does the prefix contain uppercase letters (at least one)? If so, that is the issue. Get back to me if this is the case, and the rest of this post is not relevant to you.
OTHERWISE, the error message probably means that your server environment is preventing the making of the tables. You must manually add them with a database manager tool, such as phpmyadmin, or ARI Adminer (a plugin for WordPress). Please see this post for more details:
https://support.searchandfilter.com/forums/topic/problem-with-caching-tables/#post-73252
You will need to rebuild the search cache (button is in the top right of any edit form page). After making the tables.