Page 1 of 1
Error submitting info for Callichthys callichthys
Posted: 29 May 2008, 10:55
by MatsP
I got this error when trying to submit new data for the
C. callichthys
General Error
SQL ERROR [ mysql4 ]
Unknown column 'synonym_id10' in 'field list' [1054]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
I didn't "try again to see if the error persists", because I'm pretty sure it's a case of "lots of synonyms".
--
Mats
Re: Error submitting info for Callichthys callichthys
Posted: 04 Aug 2008, 19:54
by MatsP
Bump. I'm fairly sure this is a generic problem with any species with 10 or more synonyms (there are few of those).
--
Mats
Re: Error submitting info for Callichthys callichthys
Posted: 11 Aug 2008, 13:47
by Jools
Yes, there is a hard limit of 10 at present. Either I add a silly amount of fields that will nearly always be blank to the submissions table, or I do what I perhaps should have done from the start and make synonyms and common names relational.
So, this will take time. In the meantime, I've put in a rather ugly limit to 9 synonyms but I think if you try and add one it will still fail and so that will need to be done manually in the meantime.
Jools
Re: Error submitting info for Callichthys callichthys
Posted: 11 Aug 2008, 13:50
by MatsP
I'm actually not changing the synonyms at all - I just want to change some other information on the page - which makes it even more annoying, really.
--
Mats
Re: Error submitting info for Callichthys callichthys
Posted: 11 Aug 2008, 14:14
by MatsP
By the way, there are 14 species that have 10 or more synonyms:
Code: Select all
Rhamdia quelen 42
Clarias gariepinus 20
Ompok bimaculatus 15
Hexanematichthys seemanni 13
Callichthys callichthys 13
Hoplosternum littorale 13
Hemibagrus menoda 12
Ameiurus nebulosus 12
Plotosus lineatus 12
Auchenoglanis occidentalis 11
Aphanotorulus unicolor 11
Zungaro zungaro 11
Arius thalassinus 10
Ageneiosus inermis 10
--
Mats
Re: Error submitting info for Callichthys callichthys
Posted: 22 Apr 2009, 13:18
by MatsP
Bump - tried to alter
, which has 8 official synonyms, but the "next new" lists as 10 - not sure if you are using base 9 numbers, or if number 9 is "lost" somewhere.
--
Mats
Error when trying to delete synonym
Posted: 03 Nov 2009, 23:15
by Marc van Arc
When trying to delete the synonym O. siluroides from the O. bimaculatus data sheet, I get the following message:
General Error
SQL ERROR [ mysql4 ]
Unknown column 'synonym_original_desc16' in 'field list' [1054]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Re: Error submitting info for Callichthys callichthys
Posted: 05 Dec 2009, 14:38
by MatsP
I've run into this one at least twice today [sorry, didn't keep track EXACTLY], but it essentially means I can't submit changes to size/distribution that I've looked up. I've still added them to the occurrence database, so they now have SOME distribution data. But it's a bit annoying when it happens.
One species which this happens for is: Hemibagrus menoda
--
Mats
Re: Error submitting info for Callichthys callichthys
Posted: 14 Dec 2009, 13:08
by MatsP
I merged Marc's "bug" with mine - as the cause is the same.
--
Mats
Re: Error submitting info for Callichthys callichthys
Posted: 14 Feb 2010, 18:41
by Jools
I have fixed this in the sense that it "gracefully" handles species with more than 9 synonyms. That's to say, you can edit or add up to a maximum of 9 and if there are any more then you need to ask me to make the change - even if they are already in the database.
It should prevent errors submitting any other data. As the data sub is designed to only work with 9, any more would be an enhancement (and not one that I would do as I would take the editing of synonyms out to a new admin function), so this is "bug fixed"!
Jools
