error message in "show other keepers"

A historical forum for issues reported in the suggestions and bugs forum that have been subsequently fixed or resolved.
Post Reply
User avatar
pleco_breeder
Posts: 892
Joined: 09 Dec 2003, 16:51
My articles: 2
My cats species list: 17 (i:0, k:0)
Location 1: Arizona
Interests: breeding plecos and corys
Contact:

error message in "show other keepers"

Post by pleco_breeder »

Clicking show other keepers from the my cats page gives the following error message:

Error with database: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM arn_my_fish INNER JOIN arn_species ON arn_my_fish.species_id = arn_speci' at line 8


Larry
Impossible only means that somebody hasn't done it correctly yet.
User avatar
Jools
Expert
Posts: 16277
Joined: 30 Dec 2002, 15:25
My articles: 198
My images: 941
My catfish: 237
My cats species list: 87 (i:235, k:1)
My BLogs: 7 (i:10, p:167)
My Wishlist: 23
Spotted: 450
Location 1: Middle Earth,
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: error message in "show other keepers"

Post by Jools »

Thanks Larry we'll have a look at that...

Jools
User avatar
MatsP
Posts: 21038
Joined: 06 Oct 2004, 13:58
My articles: 4
My images: 28
My cats species list: 117 (i:33, k:0)
My aquaria list: 10 (i:8)
My BLogs: 4 (i:0, p:164)
Spotted: 187
Location 1: North of Cambridge
Location 2: England.

Re: error message in "show other keepers"

Post by MatsP »

Change #392 should fix this. I expect Jools doesn't want to spend £10 per MB to download and check my changes while on holiday in Africa, so I expect it won't be fixed until Jools gets home.

Thanks to Larry for pointing this out. Judging by the type and number of different small errors, I suspect it's been broken for some time...

--
Mats
User avatar
MatsP
Posts: 21038
Joined: 06 Oct 2004, 13:58
My articles: 4
My images: 28
My cats species list: 117 (i:33, k:0)
My aquaria list: 10 (i:8)
My BLogs: 4 (i:0, p:164)
Spotted: 187
Location 1: North of Cambridge
Location 2: England.

Re: error message in "show other keepers"

Post by MatsP »

Jools has now uploaded the fixes for this one. Can someone else try it out (go to your "My Cats" page, and then click one of the "Show other keepers" links).

--
Mats
User avatar
Martin S
Posts: 2100
Joined: 26 Mar 2003, 11:14
I've donated: $20.00!
My images: 9
My cats species list: 90 (i:19, k:0)
Spotted: 17
Location 1: Guildford, Surrey
Location 2: UK
Interests: Aquatics

Re: error message in "show other keepers"

Post by Martin S »

Mats - tried this and works as expected for me. So guess that means it can me moved to resolved?
Martin
User avatar
MatsP
Posts: 21038
Joined: 06 Oct 2004, 13:58
My articles: 4
My images: 28
My cats species list: 117 (i:33, k:0)
My aquaria list: 10 (i:8)
My BLogs: 4 (i:0, p:164)
Spotted: 187
Location 1: North of Cambridge
Location 2: England.

Re: error message in "show other keepers"

Post by MatsP »

Resolved.

--
Mats
Post Reply

Return to “All Resolved Issues”