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 lot.nb_begin AS nb_begin, lot.nb_end AS nb_end, to_char(lot.collecting_date, 'DD/MM/YYYY') AS collecting_date, taxon.id AS taxon_id, taxon.family AS family, taxon.genus AS genus, taxon.genus_author AS genus_author, taxon.genus_year AS genus_year, taxon.species AS species, taxon.species_author AS species_author, taxon.species_year AS species_year, taxon.subspecies AS subspecies, locality.locality AS locality, locality.original_country AS country, CASE locality.long_eo_1 WHEN 'E' THEN dms2dd(locality.long_d_1,locality.long_m_1,locality.long_s_1) WHEN 'O' THEN - dms2dd(locality.long_d_1,locality.long_m_1,locality.long_s_1) ELSE NULL END as longitude_1, CASE locality.lat_ns_1 WHEN 'N' THEN dms2dd(locality.lat_d_1,locality.lat_m_1,locality.lat_s_1) WHEN 'S' THEN - dms2dd(locality.lat_d_1,locality.lat_m_1,locality.lat_s_1) ELSE NULL END AS latitude_1, CASE locality.long_eo_2 WHEN 'E' THEN dms2dd(locality.long_d_2,locality.long_m_2,locality.long_s_2) WHEN 'O' THEN - dms2dd(locality.long_d_2,locality.long_m_2,locality.long_s_2) ELSE NULL END as longitude_2, CASE locality.lat_ns_2 WHEN 'N' THEN dms2dd(locality.lat_d_2,locality.lat_m_2,locality.lat_s_2) WHEN 'S' THEN - dms2dd(locality.lat_d_2,locality.lat_m_2,locality.lat_s_2) ELSE NULL END AS latitude_2, collector.name AS collector, status.name AS status, fishbase.fishbase_nb AS fishbase_nb FROM mrac_albertine_fish.lot lot LEFT JOIN mrac_albertine_fish.taxon_name taxon ON lot.taxon_id = taxon.id LEFT JOIN mrac_albertine_fish.locality locality ON locality.id = lot.locality_id LEFT JOIN mrac_albertine_fish.collector collector ON collector.id = lot.collector_id LEFT JOIN mrac_albertine_fish.type_status status ON status.id = lot.type_status_id LEFT JOIN mrac_albertine_fish.fishbase_link fishbase ON fishbase.taxon_id=taxon.id WHERE lot.id=7482
- Exception traceback:
- File "/usr/local/www/sites/enbi/albertinerift/fish/index.py", line 66, in _render
hdf = _getHDF(req,classname,hdf)
File "/usr/local/www/sites/enbi/albertinerift/fish/index.py", line 85, in _getHDF instance_ = class_.__dict__[classname](req,cfg,hdf)
File "/usr/local/www/sites/enbi/albertinerift/fish/SpecimenInfo.py", line 119, in __init__ cur.execute(query2 % sqlData)