From 904b87f1d98f178557a51593b95a7efe1332c7b3 Mon Sep 17 00:00:00 2001 From: Greg Roach Date: Sun, 26 Jun 2016 20:29:39 +0100 Subject: MySQL 5.7 compatibility --- autocomplete.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/autocomplete.php b/autocomplete.php index 62810fd461..8c3073e496 100644 --- a/autocomplete.php +++ b/autocomplete.php @@ -508,7 +508,7 @@ case 'IFS': */ function get_FAM_rows(Tree $tree, $term) { return Database::prepare( - "SELECT DISTINCT 'FAM' AS type, f_id AS xref, f_gedcom AS gedcom" . + "SELECT DISTINCT 'FAM' AS type, f_id AS xref, f_gedcom AS gedcom, husb_name.n_sort, wife_name.n_sort" . " FROM `##families`" . " JOIN `##name` AS husb_name ON f_husb = husb_name.n_id AND f_file = husb_name.n_file" . " JOIN `##name` AS wife_name ON f_wife = wife_name.n_id AND f_file = wife_name.n_file" . -- cgit v1.3