I have Alabama and Alaska for example aspost filters but some states are not showing any listings for example Alabama shows listings but Alaska is not displaying the listings. When I try to recreate table and index all posts it shows succesful and shows the complete amount which is currently 5286 but when I select save it goes back to 3400. Im using Percona Server (GPL), Release ‘7’, Revision ‘9a19f1fd’ v8.4.7-7. Here is a video of the problem.

The issue was that I switched to a different server that was using MYSQL instead of MariaDB. I switched it over in https://website.com/wp-admin/admin.php?page=voxel-settings&tab=db from MariaDB to MySQL clicked SAVE CHANGES

then went here

https://website.com/wp-admin/edit.php?post_type=places&page=edit-post-type-places&tab=filters.status Then selected “recreate table and index all posts”