Error
An error occurred when you requested this page.
Please email the Webmaster to report this error.
We will work to correct the problem and apologize for the inconvenience.
- Exception type:
- Exception value:
- SELECT se.id AS id, se.specifieke AS specific_location, se.hoogte_m AS altitude, se.opmerking AS notes, to_char(se.datum, 'DD/MM/YYYY') AS date, coalesce(se.m,0)::integer AS specimen_male_count, coalesce(se.v,0)::integer AS specimen_female_count, sp.id AS taxon_id, sp.name AS species, sp.number AS species_number, sp.author AS species_author, sp.catalogue_page AS species_catalogue_page, sp.palaearctic AS species_palaearctic, sp.nearctic AS species_nearctic, sp.afrotropical AS species_afrotropical, sp.neotropical AS species_neotropical, sp.oriental AS species_oriental, sp.europe AS species_europe, sp.australasian AS species_australasian, ge.name AS genus, ge.author AS genus_author, fa.name AS family, fa.author AS family_author, lo.name AS locality, lo.old_name AS original_locality, lo.province AS province, lo.degrees_latitude_n::integer AS lat_d, coalesce(lo.minutes_latitude_n,0)::integer AS lat_m, coalesce(lo.seconds_latitude_n,0)::integer AS lat_s, lo.degrees_longitude_n::integer AS lon_d, coalesce(lo.minutes_longitude_n,0)::integer AS lon_m, coalesce(lo.seconds_longitude_n,0)::integer AS lon_s, co.name AS country, ty.description AS type, substring(sp.male_recto, '^[a-zA-Z0-9]+') AS male_recto, substring(sp.male_verso, '^[a-zA-Z0-9]+') AS male_verso, substring(sp.female_recto, '^[a-zA-Z0-9]+') AS female_recto, substring(sp.female_verso, '^[a-zA-Z0-9]+') AS female_verso FROM mrac_albertine_butterfly.sesiidae se LEFT JOIN mrac_albertine_butterfly.type ty ON se.type=ty.id LEFT JOIN mrac_albertine_butterfly.locality lo ON se.locality=lo.id LEFT JOIN mrac_albertine_butterfly.country co ON lo.country=co.id LEFT JOIN mrac_albertine_butterfly.species sp ON se.species=sp.id LEFT JOIN mrac_albertine_butterfly.genus ge ON sp.genus=ge.id LEFT JOIN mrac_albertine_butterfly.family fa ON ge.family=fa.id WHERE se.id=2243
- Exception traceback:
- File "/usr/local/www/sites/enbi/albertinerift/butterfly/index.py", line 66, in _render
hdf = _getHDF(req,classname,hdf)
File "/usr/local/www/sites/enbi/albertinerift/butterfly/index.py", line 85, in _getHDF instance_ = class_.__dict__[classname](req,cfg,hdf)
File "/usr/local/www/sites/enbi/albertinerift/butterfly/SpecimenInfo.py", line 101, in __init__ cur.execute(query1 % sqlData)