Sql Error in CotM.

A historical forum for issues reported in the suggestions and bugs forum that have been subsequently fixed or resolved.
Post Reply
User avatar
sidguppy
Posts: 3827
Joined: 18 Jan 2004, 12:26
My articles: 1
My images: 28
My aquaria list: 5 (i:0)
Spotted: 9
Location 1: Southern Netherlands near Belgium
Location 2: Noord Brabant, Netherlands
Interests: African catfishes and oddballs, Madagascar cichlids; stoner doom and heavy rock; old school choppers and riding them, fantasy novels, travelling and diving in the tropics and all things nature.
Contact:

Sql Error in CotM.

Post by sidguppy »

cool, I'll check up what i got on species not in there

as a side note; are you guys tinkering with that list?

i was reading a few CotM's and after a few entries I ran headlong into this baby:
General Error
SQL ERROR [ mysql4 ]

Unknown column 'hidden' in 'where clause' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: [email protected]
Valar Morghulis
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: Any requests for CotM

Post by MatsP »

sidguppy wrote:cool, I'll check up what i got on species not in there

as a side note; are you guys tinkering with that list?

i was reading a few CotM's and after a few entries I ran headlong into this baby:
General Error
SQL ERROR [ mysql4 ]

Unknown column 'hidden' in 'where clause' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: [email protected]
I believe you may have hit it just as Jools was making an update - to the best of my knowledge, this should now work. I've split the two posts here out to a separate post, as it's got nothing to do with the subject of "requests for CotM".

Sidguppy: Can you confirm that this is fixed - then I can move this to "Resolved"... If not, please post a link to the page where this happens...

--
Mats
User avatar
sidguppy
Posts: 3827
Joined: 18 Jan 2004, 12:26
My articles: 1
My images: 28
My aquaria list: 5 (i:0)
Spotted: 9
Location 1: Southern Netherlands near Belgium
Location 2: Noord Brabant, Netherlands
Interests: African catfishes and oddballs, Madagascar cichlids; stoner doom and heavy rock; old school choppers and riding them, fantasy novels, travelling and diving in the tropics and all things nature.
Contact:

Re: Sql Error in CotM.

Post by sidguppy »

it's on and off

although more 'on' (working as intended) tthan 'off' (the SQL warning)

just re-checked a number of species; but when hitting "chaca chaca" for example I got first the SQL screen and after skipping it, watching another sheet and re-etering Chaca it worked properly

bit of a hiccup i think, but no serious damage
Valar Morghulis
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: Sql Error in CotM.

Post by MatsP »

Well, it shouldn't be "on and off", but it's possible that some sort of caching of the "result" is causing it to be shown more than once.

--
Mats
User avatar
Jools
Expert
Posts: 16286
Joined: 30 Dec 2002, 15:25
My articles: 198
My images: 942
My catfish: 237
My cats species list: 88 (i:235, k:2)
My BLogs: 7 (i:10, p:167)
My Wishlist: 23
Spotted: 452
Location 1: Middle Earth,
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: Sql Error in CotM.

Post by Jools »

I think this is resolved?

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: Sql Error in CotM.

Post by MatsP »

Yes, I think so.

--
Mats
Post Reply

Return to “All Resolved Issues”