Projection issues with GRASS 7.8 on Windows

[MiKatt]

Using GRASS 7.8 there might be projection problems resulting in an error message in setup_grass_environment:
ERROR 1: PROJ: proj_create_geographic_crs: 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.
Subsequent import of data using import_data is also not possible.

A quick solution is to install GRASS 7.6.1 (https://grass.osgeo.org/download/) and use this version (i.e. set the program path to this version e.g. on Windows as "gisBase = c:/Program Files/GRASS GIS 7.6" in setup_grass_environment).

This seems to be no problem on unix based systems. I am working on it and will upload an update as soon as possible.

[MiKatt]

I have not found a solution yet for GRASS 7.8 stand alone installations, but for installation via OsGeo4W this script for setting the environmental variables within the R session does the trick:
https://gist.github.com/obrl-soil/d74f58b137970364458ad41270a1c8f9.

[MiKatt]

Another script to set these variables can be found here:
https://userwikis.fu-berlin.de/display/gis/2020/06/24/Grass%2C+R+and+rgrass7+and+its+problems.

[MiKatt]

I still have not found a solution for this. There seem to be several problems with GRASS 7.8 on Windows system. So, the safest options seems to be using GRASS 7.6 at the moment. Sorry for any inconvenience because of this!

[ostefankiv-NOAA]

@MiKatt Hello, do you by any chance have a copy of the GRASS 7.6 software you can upload here or direct me to a safe location where it is possible to download it? I can't seem to find a repository for older GRASS releases. Thank you.

[ostefankiv-NOAA]

Never mind, I found the correct repository for old GRASS releases. For anyone looking for 7.6.1 release, it is available here: https://old.grass.osgeo.org/download/software/ms-windows/#g76x