Skip to content

DB error: Undefined function: st_makepoint(numeric, numeric) does not exist #1663

@inquam

Description

@inquam

Describe the bug

2026-05-14T12:07:14.449395411Z [SimplePlaceResolver] DB error for lat=57.41827, lon=11.983421: An exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR: function st_makepoint(numeric, numeric) does not exist
2026-05-14T12:07:14.449413447Z LINE 5: WHERE geometry && ST_SetSRID(ST_MakePoint(57.418...
2026-05-14T12:07:14.449420569Z ^
2026-05-14T12:07:14.449426357Z HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2026-05-14T12:07:14.449431764Z SQL:
2026-05-14T12:07:14.449437001Z SELECT mp.osm_id, mp.admin_level, mp.name
2026-05-14T12:07:14.449442572Z FROM memories_planet_geometry g
2026-05-14T12:07:14.449448461Z INNER JOIN oc_memories_planet mp ON g.osm_id = mp.osm_id
2026-05-14T12:07:14.449453839Z WHERE geometry && ST_SetSRID(ST_MakePoint(57.41827, 11.983421), 4326) AND ST_Contains(geometry, ST_SetSRID(ST_MakePoint(57.41827, 11.983421), 4326))
2026-05-14T12:07:14.449459932Z ORDER BY mp.admin_level ASC
2026-05-14T12:07:14.449465080Z
2026-05-14T12:07:14.451602331Z [SimplePlaceResolver] DB error for lat=57.41827, lon=11.983421: An exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR: function st_makepoint(numeric, numeric) does not exist
2026-05-14T12:07:14.451615669Z LINE 5: WHERE geometry && ST_SetSRID(ST_MakePoint(57.418...
2026-05-14T12:07:14.451620230Z ^
2026-05-14T12:07:14.451623794Z HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2026-05-14T12:07:14.451627223Z SQL:
2026-05-14T12:07:14.451630178Z SELECT mp.osm_id, mp.admin_level, mp.name
2026-05-14T12:07:14.451633319Z FROM memories_planet_geometry g
2026-05-14T12:07:14.451641814Z INNER JOIN oc_memories_planet mp ON g.osm_id = mp.osm_id
2026-05-14T12:07:14.451663047Z WHERE geometry && ST_SetSRID(ST_MakePoint(57.41827, 11.983421), 4326) AND ST_Contains(geometry, ST_SetSRID(ST_MakePoint(57.41827, 11.983421), 4326))
2026-05-14T12:07:14.451671142Z ORDER BY mp.admin_level ASC
2026-05-14T12:07:14.451674521Z
2026-05-14T12:07:14.453751862Z [SimplePlaceResolver] DB error for lat=57.418265, lon=11.983419: An exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR: function st_makepoint(numeric, numeric) does not exist
2026-05-14T12:07:14.453768585Z LINE 5: WHERE geometry && ST_SetSRID(ST_MakePoint(57.418...
2026-05-14T12:07:14.453775075Z ^
2026-05-14T12:07:14.453780286Z HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Steps To Reproduce

I do nothing specific. The log just seems to be filling up with this as images are processed.

Platform

Docker based Nextcloud AIO running Nextcloud Hub 26 Winter (33.0.3)

Screenshots

No response

Additional context

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions