[GRASS-user] unable to open database sqlite

[Maris Nartiss]

Hello Sibylle,
I have bad news for you – you'll have to change your name (or at least
move GRASS DB to a folder without non-ascii characters in its path).
Thanks to Windows quirks (up to three different encodings for a single
session!), non-ascii chars are a frequent source of problems and there
is nothing much we can do to fix the issue. If you wonder how I know,
just check my name ;-)

TLDR: move grassdata to a folder without "ö" in its path. There is a
really high chance it will instantly solve your problem. Or – even
better – just use Linux.

Good luck,
Māris.

trešd., 2024. g. 17. apr., plkst. 11:36 — lietotājs sibylle via
grass-user (<grass-user at lists.osgeo.org>) rakstīja:
>
> Dear community
>
>
>
> I am new to GRASS GIS and I got the following error:
>
>
>
> r.boxplot -o input=Bombus_test at PERMANENT
>
>
>
> > Note, you need to close the figure to finish the script
>
>
>
> Reducing number of bins from 1000000 to 132480
>
> Computing histogram
>
> Computing bins
>
> Binning data
>
> Sorting bins
>
> Computing quantiles
>
> WARNING: Unable to open database <C:\Users\Sibylle Stöckli\grassdata\Switzerland2\PERMANENT\sqlite\sqlite.db> by driver <sqlite>
>
> ERROR: Unable to open database <$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db> by driver <sqlite>
>
> WARNING: Unable to open database <C:\Users\Sibylle Stöckli\grassdata\Switzerland2\PERMANENT\sqlite\sqlite.db> by driver <sqlite>
>
> WARNING: Unable open database <C:\Users\Sibylle Stöckli\grassdata\Switzerland2\PERMANENT\sqlite\sqlite.db> by driver <sqlite>
>
> WARNING: Unable to find table <tmpvec02b00ce38c645a48848f01f3d94c6cd2a9> linked to vector map <tmpvec02b00ce38c645a48848f01f3d94c6cd2a9>
>
> Traceback (most recent call last):
>
>
>
> However, when going to that directory, the location produced before (Switzerland2) is there:
>
>
>
> C:\Users\Sibylle Stöckli\grassdata\Switzerland2\PERMANENT
>
>
>
>
>
> Kind regards
>
> Sibylle
>
> _______________________________________________
> grass-user mailing list
> grass-user at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/grass-user