We need to print event badges in alphabetical order instead of the date registered order that you initially get from a participant search. The PDF creation completes successfully with the default sort, but after changing to alphabetical order, you get a yellow screen DB Error: unknown error. Is there a way around this? Thanks!
We are on CiviCRM 5.4.0 on Drupal 7.63
image_URL
, contac...") #5..[internal function](): PEAR->_raiseError(Object(DB_mysqli), NULL, -1, NULL, NULL, "SELECT contact_a.id as contact_id, contact_a.image_URL asimage_URL
, contac...", "DB_Error", TRUE) #8..1907): PEAR->raiseError(NULL, -1, NULL, NULL, "SELECT contact_a.id as contact_id, contact_a.image_URL asimage_URL
, contac...", "DB_Error", TRUE) #9..(933): DB_common->raiseError(-1, NULL, NULL, NULL, "1052 ** Column 'sort_name' in order clause is ambiguous") – Larry K. Feb 22 '19 at 2:13