trying to use manage identifications as I normally do, getting error.
Searched & found this specimen: https://arctos.database.museum/guid/UAM:Ento:505233
used tools menu manage->identifications
filled out the ID as normal
in this case:
ID=Staphylinidae
date= 2026-05-15
ID agent = Derek Sikes
+2 attributes:
nature of ID = fine features, Derek Sikes, date
confidence = high, Derek Sikes, date
repeated with same result
ERROR_ID F1A24C33-3F09-4D94-AFEB64C01EE9D881
ERROR_TYPE SQL
ERROR_MESSAGE ERROR: column "sensu_publication_id" of relation "cf_temp_identification" does not exist Position: 192
ERROR_DETAIL
ERROR_SQL insert into cf_temp_identification ( username, guid, scientific_name, identification_order, existing_order_change, made_date, identification_remarks, sensu_publication_id, agent_1, agent_2, agent_3, agent_4, agent_5, agent_6, attribute_type_1, attribute_value_1, attribute_units_1, attribute_remark_1, attribute_method_1, attribute_determiner_1, attribute_date_1, attribute_type_2, attribute_value_2, attribute_units_2, attribute_remark_2, attribute_method_2, attribute_determiner_2, attribute_date_2, attribute_type_3, attribute_value_3, attribute_units_3, attribute_remark_3, attribute_method_3, attribute_determiner_3, attribute_date_3, attribute_type_4, attribute_value_4, attribute_units_4, attribute_remark_4, attribute_method_4, attribute_determiner_4, attribute_date_4, status )( select 'ffdss', 'https://arctos.database.museum/guid/' || flat.guid, 'Staphylinidae', 1, '0', '2026-05-15', null, null, 'Derek S. Sikes', null, null, null, null, null, 'identification confidence', 'high', null, null, null, 'Derek S. Sikes', '2026-05-15', 'nature of identification', 'fine features', null, null, null, 'Derek S. Sikes', '2026-05-15', null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'autoload' from api_ffdss_2026051504051531_813 inner join flat on api_ffdss_2026051504051531_813.collection_object_id=flat.collection_object_id )
trying to use manage identifications as I normally do, getting error.
Searched & found this specimen: https://arctos.database.museum/guid/UAM:Ento:505233
used tools menu manage->identifications
filled out the ID as normal
in this case:
ID=Staphylinidae
date= 2026-05-15
ID agent = Derek Sikes
+2 attributes:
nature of ID = fine features, Derek Sikes, date
confidence = high, Derek Sikes, date
repeated with same result
ERROR_ID F1A24C33-3F09-4D94-AFEB64C01EE9D881
ERROR_TYPE SQL
ERROR_MESSAGE ERROR: column "sensu_publication_id" of relation "cf_temp_identification" does not exist Position: 192
ERROR_DETAIL
ERROR_SQL insert into cf_temp_identification ( username, guid, scientific_name, identification_order, existing_order_change, made_date, identification_remarks, sensu_publication_id, agent_1, agent_2, agent_3, agent_4, agent_5, agent_6, attribute_type_1, attribute_value_1, attribute_units_1, attribute_remark_1, attribute_method_1, attribute_determiner_1, attribute_date_1, attribute_type_2, attribute_value_2, attribute_units_2, attribute_remark_2, attribute_method_2, attribute_determiner_2, attribute_date_2, attribute_type_3, attribute_value_3, attribute_units_3, attribute_remark_3, attribute_method_3, attribute_determiner_3, attribute_date_3, attribute_type_4, attribute_value_4, attribute_units_4, attribute_remark_4, attribute_method_4, attribute_determiner_4, attribute_date_4, status )( select 'ffdss', 'https://arctos.database.museum/guid/' || flat.guid, 'Staphylinidae', 1, '0', '2026-05-15', null, null, 'Derek S. Sikes', null, null, null, null, null, 'identification confidence', 'high', null, null, null, 'Derek S. Sikes', '2026-05-15', 'nature of identification', 'fine features', null, null, null, 'Derek S. Sikes', '2026-05-15', null, null, null, null, null, null, null, null, null, null, null, null, null, null, 'autoload' from api_ffdss_2026051504051531_813 inner join flat on api_ffdss_2026051504051531_813.collection_object_id=flat.collection_object_id )