On Thu, Sep 10, 2020 at 12:21 PM Xavier Robert <xavier.robert@univ-grenoble-alpes.fr> wrote:

I am trying to compile the last Therion version on my Macos 10.14.6. The compilation fails with the ./utest with the error:
./utest
proj_create: cannot build projectedCRS 32634: cannot build geodeticCRS 4326: SQLite error on SELECT name, ellipsoid_auth_name, ellipsoid_code, prime_meridian_auth_name, prime_meridian_code, area_of_use_auth_name, area_of_use_code, publication_date, deprecated FROM geodetic_datum WHERE auth_name = ? AND code = ?: no such column: publication_date
(null): error -- PROJ library: -61 (generic error of unknown origin): epsg:32634
make: *** [tests] Error 1

Hi, this looks like a Proj version mismatch (Proj compiled into Therion trying to open a database belonging to another version of Proj installed in the system). Check if Proj command line utilities work (run e.g. "projinfo EPSG:32634"), check the version and check if the version matches the version of Proj used in Therion.

With the master (6c41c82) version:
A « tclsh thcdata.tcl » gives « No PROJ system definitions imported ».
If I do a search for « 32634 » in thcsdata.cxx, I find only 1 line:

This is expected as the latest commits call Proj API to get the definitions instead of preprocessing them.

I also have the sqlite3 from Anaconda installed.

The sqlite error is produced by sqlite linked to Proj directly, it doesn't use external/system sqlite3.

On the other side, I also tried to recompile the 5.4.4 version (that I already have and that is running fine), and I could recompile it without any errors (with proj 6.3.2, I did not tried with proj 7).

5.4.4 used different handling of Proj definitions (they were compiled into therion binary).

Martin