Well you do not need to redo your site, just manually update the adoptables ids from prefix.adoptables and prefix.adoptables_conditions so the two ids match each other. This should solve your problem. For instance, if you have a species whose id is 5 from table prefix.adoptables, and the id is 6 from table prefix.adoptables_conditions, you will need to change at least one of them so they are the same id. Now understand?