create stream error in QGIS 2.16.8-Ubuntu 20.04

[andry rustanto]

Dear All,

I got an error when creating streams with message :

PitRemove version 5.3.9

ERROR 1: PROJ: proj_as_wkt: 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: area_of_use_auth_name

I run QSWAT+ on ubuntu 20.04 with QGIS 2.16.8 installed. I appreciate for any help.

Thank you and kind regards,

Andry

[andry rustanto]

[Chris George]

I haven't seen this error before, but it seems to be a problem with the
projection data in a database somewhere: it looks like it occurs withing
the GDAL software: perhaps a mismatched version. I presume your QGIS
version is 3.16.8 not 2.16.8 or things would certainly not work.

Some things you can try:

- use an earlier version of QGIS. I am running 3.16.7 on Ubuntu and
haven't had any problems like this.

- try using a different projection for your project. If it is a
mismatch in database structure this probably won't help, but it is worth
trying

- check that you haven't got more than one version of GDAL

- try on a different machine, or a different OS if you are able to

If none of this seems to work send me your project folder and I will try
on my machine. If something does work please let me know!

Chris

> --
> You received this message because you are subscribed to the Google
> Groups "QSWAT+" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to qswatplus+...@googlegroups.com
> <mailto:qswatplus+...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/qswatplus/CAEuUSdsSdBvrM3U25%2BVLc_53UDx_JHxCKbUDr2aZTwJwCnmFHw%40mail.gmail.com
> <https://groups.google.com/d/msgid/qswatplus/CAEuUSdsSdBvrM3U25%2BVLc_53UDx_JHxCKbUDr2aZTwJwCnmFHw%40mail.gmail.com?utm_medium=email&utm_source=footer>.

[andry rustanto]

Hi Chris,

Thanks for your suggestion. I just solved this problem by QGIS clean reinstallation and remove the old libproj (libproj15 libproj-dev libproj19). I works well now.

 Andry