diff options
| author | David Drury <ddrury@users.noreply.github.com> | 2026-03-02 20:54:56 +0000 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2026-03-02 20:54:56 +0000 |
| commit | fae1734e30e0767a0091e1338713dc9ef0137476 (patch) | |
| tree | d445aa48a1edb2b0829696cf064290414f595845 | |
| parent | 27719772b50adb162ee51f773ba93aa6b9381d5d (diff) | |
| download | webtrees-fae1734e30e0767a0091e1338713dc9ef0137476.tar.gz webtrees-fae1734e30e0767a0091e1338713dc9ef0137476.tar.bz2 webtrees-fae1734e30e0767a0091e1338713dc9ef0137476.zip | |
Fix Selection of data after Schema 45/46 update (#5326)
| -rw-r--r-- | app/Services/MapDataService.php | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/app/Services/MapDataService.php b/app/Services/MapDataService.php index c94046610a..a664bd31d7 100644 --- a/app/Services/MapDataService.php +++ b/app/Services/MapDataService.php @@ -75,11 +75,9 @@ class MapDataService $children = []; $rows = DB::table('places') - ->join('gedcom', 'gedcom.gedcom_id', '=', 'p_file') - ->join('gedcom_setting', 'gedcom_setting.gedcom_id', '=', 'gedcom.gedcom_id') - ->where('setting_name', '=', 'title') + ->join('gedcom', 'gedcom_id', '=', 'p_file') ->whereIn('p_parent_id', $parents) - ->select(['p_place', 'gedcom_name AS tree_name', 'setting_value AS tree_title', 'p_id']) + ->select(['p_place', 'gedcom_name AS tree_name', 'title AS tree_title', 'p_id']) ->get() ->map(static fn (object $row): object => (object) [ 'p_place' => $row->p_place, |