SearchKit dB Entity not able to save
When creating a dB Entity in searchkit if the search is complex it will not save. Just get an orange box with a spinning icon. I was able to recreate the issue here https://wpmaster.demo.civicrm.org/.
Details:
- Simple search such as a search for individual contacts saved fine.
- A search with address state also saved fine
- When adding contact address & state abbreviation the error saving occurred.
With the simple searches that save OK I see the message Last refreshed: never. Click "Save" to refresh now.
if I click save I see Checking last refresh date...
when I look in the database I see the table created but no data.
I tested on my test site running CiviCRM 5.63.1 with WordPress 6.2.2 and PHP 8.1.21. I was able to recreate all this in https://wpmaster.demo.civicrm.org/.