<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class="">I’m running ArchivesSpace 2.8.1 under current MariaDB 10.5.9 and I’m not getting any errors on any of those reports. </div><div class="">It’s our intention to support current versions of both MySQL and MariaDB, but not everything can be tested against every version, especially those reports. </div><div class=""><br class=""></div><div class="">Wendy: are you getting the same error message reported in that JIRA issue? </div><div class=""><blockquote type="cite" class=""><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div dir="ltr" class=""><div class="" style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt;"><span class="" style="font-size: 14px; background-color: rgb(255, 255, 255); display: inline;"><a href="https://archivesspace.atlassian.net/jira/software/c/projects/ANW/issues/ANW-1200" class="">https://archivesspace.atlassian.net/jira/software/c/projects/ANW/issues/ANW-1200</a> </span></div></div></blockquote></div></blockquote><br class=""></div><div class="">Wendy and/or Blake: </div><div class="">(I have a hunch) Can you try editing:</div><div class=""><span class="Apple-tab-span" style="white-space:pre"> </span>archivesspace/reports/accessions/accession_names_subreport/accession_names_subreport.rb</div><div class="">And in the line: role_id as function, quote the word function:</div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">12c12</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">< role_id as function,</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">---</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">> role_id as 'function',</span></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">class AccessionNamesSubreport < AbstractSubreport</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254); min-height: 19px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> def initialize(parent_report, accession_id)</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> super(parent_report)</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> @accession_id = accession_id</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> end</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254); min-height: 19px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> def query_string</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> "select</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> ifnull(ifnull(ifnull(name_person.sort_name, name_family.sort_name),</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> name_corporate_entity.sort_name), 'Unknown') as name,</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> role_id as function,</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> relator_id as role</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> from linked_agents_rlshp</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> left outer join name_person</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> on name_person.agent_person_id = linked_agents_rlshp.agent_person_id</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> left outer join name_family</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> on name_family.agent_family_id = linked_agents_rlshp.agent_family_id</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> left outer join name_corporate_entity</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> on name_corporate_entity.agent_corporate_entity_id = </span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> linked_agents_rlshp.agent_corporate_entity_id</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> where accession_id = #{db.literal(@accession_id)}"</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> end</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254); min-height: 19px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> def fix_row(row)</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> ReportUtils.get_enum_values(row, [:function, :role])</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""> end</span></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254); min-height: 19px;" class=""><span style="font-variant-ligatures: no-common-ligatures" class=""></span><br class=""></div><div style="margin: 0px; font-stretch: normal; line-height: normal; background-color: rgb(203, 255, 254);" class=""><span style="font-variant-ligatures: no-common-ligatures" class="">end</span></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Or else replace it with this edited version:</div><div class=""><br class=""></div><div class=""></div></body></html>