Adoptables not in Adopt Center?

[AlexC]

So I just added an adoptable to my site, and since I deleted all of the previous ones, it is the only one. It has been set to show up always in the adoption center, but it isn't appearing? It's in the database, but otherwise there isn't anything on the site?

EDIT: I was able to give myself an adoptable via the ACP, so everything else seems to be working, it just isn't showing up here.

 

[Abronsyth]

I had this same problem, with the pets randomly disappearing from where they were supposed to be shown on the site, they were still in the database, just no longer adoptable.

 

[AlexC]

Alright, I wasn't sure if it was just me. I actually had it in the last script too - only like, half showed up, I wasn't sure what it was. I just deleted all of them and was going to start over.

 

[Hall of Famer]

Well is this happening just randomly to any adoptables, or that certain species always wont show up? If the latter is true, check the ids of your adoptables from the table prefix.adoptables and table prefix.adoptables_conditions. The two ids must match each other, or the pets wont show from adoption center. I will incorporate a rebuild_id script for such tables in future, so if by any chance the adoptables or user ids are different from each table, it will sort things out for you.

 

[AlexC]

I went and checked that database and found that the id's didn't match. Also had a spare one floating around. Thank you, guess that was the problem - I have no idea how that got out of whack. xD

 

[Hall of Famer]

Yeah, for adoptables and users that have multiple tables, each is linked together with another with a reference field that contains the same information. If this information does not match, you wont see the adoptables from adoption center, or users from members list.

This usually should not be a problem for anyone of you, unless you have a habit of resetting id increment from phpmyadmin. The below screenshot shows you how you can do this:

The highlighted field increments by 1 whenever you insert a new row into database, and wont decline even if a row is removed. Theoretically the id increases by 1 after you create a new pet, and it stays at the current pointer even if you hard-delete a pet. I am not sure how you can have id mismatches unless you've done more than creating/deleting adoptables in ACP.

 

[AlexC]

I did go through the database to edit a bunch of stuff, so that's problably how it happened- I 'll try to find that thing and fix it.