Oh no.

[goofyunicorn]

Hi everyone.

So I am looking for some help.

It seems that a few of my users Adoptables (Indian Ringnecks) have disappeared from "Manage Adoptables" and "My Adopts" and can only manage them when they type in a certain URL. It started happening around St. Patricks Day when I released the Ringnecks. How do I fix this?

Secondly, I made an adoptable yesterday that errored and now it shows up in the list on the ACP but it says "Cockatiel April /'18 doesn't exist" so I can't delete it on the ACP. Anyone who has adopted it off the Adoption Centre now has an errored profile, adoptables page and any page that may feature an owned Cockatiel April /'18. How do I delete this guy for good to stop these errors?

Finally, how do I get rid of the slashes before an apostrophe?

 

[Dinocanid]

You can delete pets manually by going into phpMyAdmin and deleting the pet from both the "adopts_ownedadoptables" table and the species from "adopts_adoptables".

I assume it errored because of the apostrophe and slash. I don't know how to fix it at the moment, but a workaround would be to just use "Cockatiel April 2018" or something.

As for the Ringnecks, I'm not entirely sure. Were they always disappearing after you released them or did it only start after a few days?

 

[goofyunicorn]

You can delete pets manually by going into phpMyAdmin and deleting the pet from both the "adopts_ownedadoptables" table and the species from "adopts_adoptables".

I assume it errored because of the apostrophe and slash. I don't know how to fix it at the moment, but a workaround would be to just use "Cockatiel April 2018" or something.

As for the Ringnecks, I'm not entirely sure. Were they always disappearing after you released them or did it only start after a few days?

For the ringnecks, it is only this one user experiencing this problem.

 

[Dinocanid]

For the ringnecks, it is only this one user experiencing this problem.

Okay. If you look at the adopts_ownedadoptables table and find the row with this user's ringneck, what does it look like?

 

[goofyunicorn]

Okay. If you look at the adopts_ownedadoptables table and find the row with this user's ringneck, what does it look like?

It looks normal.

 

[goofyunicorn]

Okay. If you look at the adopts_ownedadoptables table and find the row with this user's ringneck, what does it look like?

As for the Cockatiel, it is showing up in adopts_adoptables. Should I delete it there?

 

[Dinocanid]

It looks normal.

I mean like what does it say. Was the bird named? Something might be causing it to bug out.

 

[goofyunicorn]

I mean like what does it say. Was the bird named? Something might be causing it to bug out.

The birds in question are all named normal names.

 

[Dinocanid]

I'm not sure then. I even tried adopting one myself and it shows up just fine. I think it would just be best for the user to adopt another ringneck instead.

 

[goofyunicorn]

I'm not sure then. I even tried adopting one myself and it shows up just fine. I think it would just be best for the user to adopt another ringneck instead.

The ringnecks from the previous month are gone now as we restock the birds every month. I will try and give them their ringnecks through a promocode.

 

[goofyunicorn]

I'm not sure then. I even tried adopting one myself and it shows up just fine. I think it would just be best for the user to adopt another ringneck instead.

As for the Cockatiel, it is showing up in adopts_adoptables. Should I delete it there?

 

[Dinocanid]

As for the Cockatiel, it is showing up in adopts_adoptables. Should I delete it there?

Yeah. Also, did you delete the ringnecks from the previous month or did you just make them unobtainable?

 

[goofyunicorn]

Yeah. Also, did you delete the ringnecks from the previous month or did you just make them unobtainable?

Unobtainable.

 

[Dinocanid]

Oh, okay. I was thinking that it was probably related to it not being available; but that doesn't look like the case since it was just made unobtainable and not deleted.

 

[Hall of Famer]

Is this issue resolved? Its better not to add/remove database records directly unless you know what you are doing. If you need help solving this problem, send a pm to me and I will look into that.