Error submitting info for Callichthys callichthys

[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

[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

[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

[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

[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

[MatsP]

Bump - tried to alter

Farlowella amazonum

, 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

[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.

[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

[MatsP]

I merged Marc's "bug" with mine - as the cause is the same.

--
Mats

[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