Re: [GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS

2020-08-07 Thread Helmut Kudrnovsky
[in a windows console/osgeo4w console you can mark the content with the mouse, then press return on the keybord, then you can paste the content as normal text into a mail, no screenshot needed}   >When I run the where from the windows console I get this:  there is a sqlite dll hell caused by

Re: [GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS

2020-08-07 Thread DAmico, Ellen
-Original Message- From: grass-user On Behalf Of Helmut Kudrnovsky Sent: Friday, August 07, 2020 8:32 AM To: grass-user@lists.osgeo.org Subject: Re: [GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS >I am getting this error: > >Process ended with non-ze

Re: [GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS

2020-08-07 Thread DAmico, Ellen
- From: Moritz Lennert Sent: Friday, August 7, 2020 5:54 AM To: grass-user@lists.osgeo.org; DAmico, Ellen ; GRASS user list Subject: Re: [GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS Hi Ellen, Am 6. August 2020 22:03:24 MESZ schrieb "DAmico, Ellen"

Re: [GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS

2020-08-07 Thread Helmut Kudrnovsky
>I am getting this error: > >Process ended with non-zero return code 3221225785. See errors in the (error) it's a dll mixing/mismatch due to more of the same dll in your %PATH%. which library errored the message above? (sqlite? gdal?)

Re: [GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS

2020-08-07 Thread Moritz Lennert
Hi Ellen, Am 6. August 2020 22:03:24 MESZ schrieb "DAmico, Ellen" : >Good Afternoon, >I have been going around in circles with this error. >When I run this piece of code: >g.run_command(r'C:\OSGeo4W64\apps\grass\grass78\bin\g.proj.exe', >georef=geotiff, location = locationGeonet) >I am getting

[GRASS-user] Sqlite error when calling GRASS GIS outside of GRASS

2020-08-06 Thread DAmico, Ellen
Good Afternoon, I have been going around in circles with this error. When I run this piece of code: g.run_command(r'C:\OSGeo4W64\apps\grass\grass78\bin\g.proj.exe', georef=geotiff, location = locationGeonet) I am getting this error: Process ended with non-zero return code 3221225785. See errors

Re: [GRASS-user] SQLite Error

2015-02-12 Thread Mark Wynter
Hi Moritz - the SQLite DB seems to be inheriting the schema from the previous PG driver? Even if I db.dropdb…. I don’t encounter this if I create a new location… e.g. test GRASS 7.0.0svn (nodeclean):~ db.dropdb database='/var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db' GRASS 7.0.0svn

Re: [GRASS-user] SQLite Error

2015-02-12 Thread Moritz Lennert
On 12/02/15 11:16, Mark Wynter wrote: Hi Moritz - the SQLite DB seems to be inheriting the schema from the previous PG driver? Even if I db.dropdb…. I don’t encounter this if I create a new location… e.g. test Can you set schema='' or something like that ? Moritz GRASS 7.0.0svn

Re: [GRASS-user] SQLite Error

2015-02-12 Thread Mark Wynter
Thanks Moritz - good suggestion - I just need to these as deliverables out to 2 separate clients (nice to get paid work for this stuff) - then I will write up and contribute back via Wiki. The slow rate of writing out the v.net.allpair results from PostgreSQL was due to the sheer volume of

Re: [GRASS-user] SQLite Error

2015-02-12 Thread Moritz Lennert
On 12/02/15 02:14, Mark Wynter wrote: #(2) RESET THE DATABASE DRIVER FOR THE CURRENT MAPSET TO SQLITE db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db' schema=grass db.connect -p #Output driver: sqlite database: /var/tmp/nodeclean/PERMANENT/sqlite/sqlite.db

Re: [GRASS-user] SQLite Error

2015-02-12 Thread Mark Wynter
Haven’t come across anything to that effect Can you set schema='' or something like that ? Moritz I’ve reverted back to using solely PG driver - notwithstanding this SQLite issue. As a prologue to the several issues I encountered with Grass over the last few days… The slow rate of

Re: [GRASS-user] SQLite Error

2015-02-12 Thread Moritz Lennert
On 12/02/15 13:30, Mark Wynter wrote: Haven’t come across anything to that effect Can you set schema='' or something like that ? Moritz I’ve reverted back to using solely PG driver - notwithstanding this SQLite issue. As a prologue to the several issues I encountered with Grass over the

[GRASS-user] SQLite Error

2015-02-11 Thread Mark Wynter
Thanks Moritz. I am getting an SQLite error when trying to run v.net.allpairs. This is my latest workflow, incl. my checks and output messages of each step. #(1) CREATE A COPY OF MY ROAD NETWORK, AND DROP THE ATTRIBUTE TABLE (CURRENTLY SET WITH PG DRIVER) db.connect driver=pg

Re: [GRASS-user] sqlite error using v.patch -a -e in GRASS 7.0

2012-06-14 Thread Marti Christian
On 13/06/12 13:38, Marti Christian wrote: All the maps I append have cat columns starting with a value of 1. As far as I understand, v.patch -e -a adds all the elements in the table of the map to be appended to the table of the patched map with new values for 'cat', so I do not understand

[GRASS-user] sqlite error using v.patch -a -e in GRASS 7.0

2012-06-13 Thread Marti Christian
Hi, I encountered a problem using v.patch -a -e. I am using v.patch in a loop (python script) to append vector maps with parts of a street network to a map (so that map would contain the entire network in the end). While running the script, for a while the code works fine, i.e. some maps get

Re: [GRASS-user] sqlite error using v.patch -a -e in GRASS 7.0

2012-06-13 Thread Moritz Lennert
On 13/06/12 13:38, Marti Christian wrote: All the maps I append have cat columns starting with a value of 1. As far as I understand, v.patch -e -a adds all the elements in the table of the map to be appended to the table of the patched map with new values for 'cat', so I do not understand how

[GRASS-user] SQlite Error, Mac OS X

2012-02-28 Thread Johannes Radinger
Hi, When I try to open the attribute table (sqlite db) of a line vector with around 100 columns and several 1000 lines I get an error message in GRASS6.5 SVN (Mac OSX). After the error message pops up (saying only error, no specific description) the attribute table opens and shows the column

Re: [GRASS-user] SQlite Error, Mac OS X

2012-02-28 Thread Johannes Radinger
ArcView. Just a suggestion: Maybe the Error message should be more specific for the user. cheers, /johannes Original-Nachricht Datum: Tue, 28 Feb 2012 12:01:08 +0100 Von: Johannes Radinger jradin...@gmx.at An: grass user list grass-user@lists.osgeo.org Betreff: [GRASS-user

Re: [GRASS-user] SQlite Error, Mac OS X

2012-02-28 Thread Hamish
Johannes wrote: When I try to open the attribute table (sqlite db) of a line vector with around 100 columns and several 1000 lines I get an error message in GRASS6.5 SVN (Mac OSX). After the error message pops up (saying only error, no specific description) the attribute table opens and shows

Re: [GRASS-user] SQlite Error, Mac OS X

2012-02-28 Thread Hamish
Johannes wrote: When I try to open the attribute table (sqlite db) of a line vector with around 100 columns and several 1000 lines I get an error message in GRASS6.5 SVN (Mac OSX). After the error message pops up (saying only error, no specific description) the attribute table opens and shows

[GRASS-user] SQLite error using db.copy

2011-05-02 Thread rvanderweide
Dear GRASS users,I use the Windows version of GRASS 6.4.1.I loaded a shapefile with attribute table pse@pov2. By default GRASS stores the attribute tablein DBF. Using db.copy i tried to convert the table to SQLite (so i could later join it to a tablefrom a CSV file). The dbf-to-sqlite option of