Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)
-   Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)
-   -   View Public Trade Offers not working. (http://www.mysidiaadoptables.com/forum/showthread.php?t=4420)

Pear 03-02-2014 12:28 PM
[Unsolved] View Public Trade Offers not working. :s
 
I have been informed by one of my members that when they go on the public trade offers page, this comes up:
Code:
Fatal error: Uncaught exception 'AdoptNotfoundException' with message 'Adoptable 9 does not exist...' in /home/capifore/public_html/classes/class_adoptable.php:26 Stack trace: #0 /home/capifore/public_html/classes/class_tradehelper.php(299): Adoptable->__construct(9) #1 /home/capifore/public_html/view/tradeview.php(120): TradeHelper->getAdoptList(Object(Resource\Collection\ArrayList)) #2 /home/capifore/public_html/classes/class_frontcontroller.php(100): TradeView->publics() #3 /home/capifore/public_html/index.php(74): FrontController->render() #4 /home/capifore/public_html/index.php(78): IndexController::main() #5 {main} thrown in /home/capifore/public_html/classes/class_adoptable.php on line 26
It is also appearing for me. Is there a way I could fix this? c:

Hall of Famer 03-02-2014 01:42 PM
umm was that adoptable deleted in your database?

Pear 03-03-2014 10:56 AM
No, it exists, except I did change it to the alt form. (Also when I edit pets, it comes up with a relatively same message. Is there a way I can edit the pets without this happening?) c:

IntoRain 03-03-2014 11:10 AM
From the control panel no, that message appears because something is wrong with that Adoptable 9. If it can't find it, it will throw a fatal error. Go to your database directly to make edits, search for that adoptable and check what's wrong with it. If you deleted an adoptable, maybe there are traces of it still in tables like owned_adoptables, adoptables_conditions, levels, etc

Pear 03-03-2014 01:27 PM
The adoptable still exists, I just changed it from normal to the alt version. c:

IntoRain 03-03-2014 02:25 PM
The error means it tried to create an adoptable with the ID 9 from the database and it didn't exist. It doesn't mean necessarily you removed it, changing it might have caused it as well (sorry, I don't understand what you meant with changing it to the alt version). The error is thrown in line 26 of class_adoptable.php which has this:

PHP Code:
$whereClause = (is_numeric($adoptinfo))?"id ='{$adoptinfo}'":"type ='{$adoptinfo}'";
 $row = $mysidia->db->select("adoptables", array(), $whereClause)->fetchObject();
[B]      
 if(!is_object($row)) throw new AdoptNotfoundException("Adoptable {$adoptinfo} does not exist...");[/B] 
It's when it recieves an ID and tries to fetch an object from the database.

Can you go to your database, table adoptables, and check what's up with the adoptable with an aid of 9?

Pear 03-03-2014 06:14 PM
I don't quite understand what you are saying. c: I am in my database, but I don't know what you mean by table adoptables? c:

IntoRain 03-03-2014 06:53 PM
Sorry. Your database should have various tables, all start with the same prefix you chose when installing, for example adopts_. So a table adoptables would be adopts_adoptables. If you are using phpMyAdmin, after clicking on your database a list of all these tables would appear on the left side (for example http://i.imgur.com/uECJR2s.png - look at the left side, ignore the other stuff I used this image somewhere else)

Pear 03-04-2014 06:23 PM
Ah! I found it. Oddly enough, it doesn't exist in the database, but it's still on my site? x) But then again, neither do the other 100+. (Except a random 19 adoptables?)



(Also thank you for helping me! I really appreciate it. c: I'd be completely hopeless without it..haha c:)


So now that I've found adopts_adoptables, what do I do now? c:

IntoRain 03-09-2014 08:18 PM
(I'm really sorry, I completely forgot about this thread x.x' )

Do you mean the adoptable with ID of 9 doesn't exist in the table?

Pear 03-09-2014 10:53 PM
(Haha it's okay<3 c:.)

So I think the adopts_adoptables is only showing the 18 different designed creatures and not the individual adoptables. The adoptable with the ID of nine is called a Blood Lynx Capi, so it has the ID of 7 in the database, just like all other Blood Lynx Capiis. But I can't seem to find the exact adoptable with the exact ID. x) haha

Edit:
So I've found it in adopts_owned_adoptables...And I don't quite know what would be wrong with it. . haha c:

Hall of Famer 03-10-2014 02:56 PM
umm what do you mean by this? Are you saying that the adoptables ID actually exists? If so, the script should be able to create an adoptable object based on the given ID, apparently this is not the case. Would you mind posting screenshots of the table adopts_adoptables and adopts_owned_adoptables? This way we can help you identify the issue.

Pear 03-10-2014 05:52 PM
Yes, if I understand your question right. c:
adopts_adoptables:
http://www.freeimagehosting.net/newuploads/z85p5.png

adopts_owned_adoptables:
http://www.freeimagehosting.net/newuploads/dgl92.png

This is the exact adoptable that it is talking about:
http://capiforest.elementfx.com/picu...4c91dd0da6.png

IntoRain 03-10-2014 06:16 PM
The system is trying to create an adoptable (not owned adoptable) with an ID of 9, which doesn't exist in your adoptables table.

Can you also screenshot your _trade table?

Pear 03-10-2014 06:22 PM
http://www.freeimagehosting.net/newuploads/pkkdp.png

I removed the 9 from the one that had the 9 on it, and it's fixed now. ^-^

Thank you guys so much for your help! <3 :D I really appreciate it..haha c:

IntoRain 03-10-2014 06:24 PM
Awesome! Sorry it took long to figure it out xD But I'm glad it worked out!

Pear 03-10-2014 06:29 PM
I don't mind the wait, I'm sure my users don't either. ^-^ <3 I am so glad that there are people here *cough* you and Hall of Famer *cough* *cough* that are willing to help people like me who do not understand stuff like this. c: <3


All times are GMT -5. The time now is 08:49 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.