Fatal error: Error loading records in Dataface_QueryTool::loadSet(): Unknown column 'roster.NICKNAME' in 'order clause'
SELECT length(`roster`.`LAST NAME`) as `__LAST NAME_length`,`roster`.`LAST NAME`,length(`roster`.`FIRST NAME`) as `__FIRST NAME_length`,`roster`.`FIRST NAME`,length(`roster`.`MIDDLE NAME`) as `__MIDDLE NAME_length`,`roster`.`MIDDLE NAME`,length(`roster`.`NICKNAME/OTHER`) as `__NICKNAME/OTHER_length`,`roster`.`NICKNAME/OTHER`,length(`roster`.`PREFIX`) as `__PREFIX_length`,`roster`.`PREFIX`,length(`roster`.`SUFFIX`) as `__SUFFIX_length`,`roster`.`SUFFIX`,length(`roster`.`RANK`) as `__RANK_length`,`roster`.`RANK`,length(`roster`.`SERIAL NUMBER`) as `__SERIAL NUMBER_length`,`roster`.`SERIAL NUMBER`,length(`roster`.`ARM OR SERVICE`) as `__ARM OR SERVICE_length`,`roster`.`ARM OR SERVICE`,length(`roster`.`UNIT`) as `__UNIT_length`,`roster`.`UNIT`,length(`roster`.`NARA CAMP CODE`) as `__NARA CAMP CODE_length`,`roster`.`NARA CAMP CODE`,length(`roster`.`CAMP NAME`) as `__CAMP NAME_length`,`roster`.`CAMP NAME`, in /var/www/vhosts/worldwar2database.com/httpdocs/xataface/Dataface/QueryTool.php on line 287