[gdal-dev] no such function: ST_Line_Interpolate_Point when Spatialite and GDAL are installed and quite up-to-date

[Ann Tulliani]

Dear list members,
I have been trying to use the GDAL tools from within QGIS, more specifically the "Points Along Lines" tool, to find the lines' midpoints in line shapefiles. However, regardless of which file I try, I keep getting this error:


GDAL command output:ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(SELECT ST_Line_Interpolate_Point(geometry, 0.5) AS geometry,* FROM "myshapefile"):
no such function: ST_Line_Interpolate_Point


Searching online, the only reference to that problem is a 5 years old thread from this very list: https://lists.osgeo.org/pipermail/gdal-dev/2015-May/041800.html. Following it, the first obvious thing to suspect is that Spatialite is either missing or outdated. However, neither seem to be the case in my 64bits Ubuntu 18.04 system:

> sudo apt-get install -y spatialite-binReading package lists... DoneBuilding dependency tree       Reading state information... Donespatialite-bin is already the newest version (4.3.0-2build1).

For reference, it seems that GDAL version being used is 3.0.2 and PROJ version is 6.2.1:

QGIS version: 3.10.1-A CoruñaQGIS code revision: 1e6b1a3eQt version: 5.12.6GDAL version: 3.0.2GEOS version: 3.7.2-CAPI-1.11.2 b55d2125PROJ version: Rel. 6.2.1, November 1st, 2019

I am at a loss: if both GDAL and Spatialite are present in my system and up-to-date enough to contain "ST_Line_Interpolate_Point", how could I solve the mentioned issue?
Thanks!
Ann Tulliani

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20210202/c7922f4b/attachment.html>