diff options
| author | Greg Roach <fisharebest@gmail.com> | 2016-06-26 20:29:39 +0100 |
|---|---|---|
| committer | Greg Roach <fisharebest@gmail.com> | 2016-06-26 20:29:39 +0100 |
| commit | 904b87f1d98f178557a51593b95a7efe1332c7b3 (patch) | |
| tree | cb615bb29743ce62d54b86f4a754443d04e07fc5 | |
| parent | 04ecbb4b5760bee4b24fdd98058277377c163384 (diff) | |
| download | webtrees-904b87f1d98f178557a51593b95a7efe1332c7b3.tar.gz webtrees-904b87f1d98f178557a51593b95a7efe1332c7b3.tar.bz2 webtrees-904b87f1d98f178557a51593b95a7efe1332c7b3.zip | |
MySQL 5.7 compatibility
| -rw-r--r-- | autocomplete.php | 2 |
1 files changed, 1 insertions, 1 deletions
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" . |