Posted subsequent e-mail exchange that mistakenly took place off-forum. Go from bottom to top to follow thread....
From: Shiva Shankar Mahato <[email protected]> Date: Sat, Sep 30, 2017 at 11:21 AM Subject: Re: [Arches] error in running the command 'python manage.py packages -o install' To: Adam Cox <[email protected]> Hey Adam, thanks for pointing out the problem I think the problem is with the installation of Postgis . All problem solved after I re-installed everything in another system and when I checked the postgis version it showing like this..: postgis_full_version --------------------------------------------------------------------------------------------------------------------------------------------------------------------- *POSTGIS="2.1.3* r12547" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 2.1.0, released 2016/04/25" LIBXML="2.9.1" LIBJSON="UNKNOWN" RASTER (1 row) Thanx once again. On 29 September 2017 at 17:29, Shiva Shankar Mahato < [email protected]> wrote: I have installed Postgres/postgis using the file *ubuntu_trusty_setup.sh.* On 29 September 2017 at 17:24, Shiva Shankar Mahato < [email protected]> wrote: Thnx once again, This is the output when i selected PostGIS_full_version() in Postgresql tgis_full_version ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ POSTGIS="2.2.2 r14797" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 2.1.0, released 2016/04/25" LIBXML="2.9.1" LIBJSON="0.11.99" TOPOLOGY RASTER (1 row) (END) The problem still remains the same. Again, I tried to run the command *python manage.py packages -o install* It executed properly but I could see some error in between. *Errors are :* psql:/home/sourav/Projects/ENV/local/lib/python2.7/site-packages/arches/db/ddl/db_ddl.sql:2327: ERROR: relation "overlays" does not exist psql:/home/sourav/Projects/ENV/local/lib/python2.7/site-packages/arches/db/ddl/db_ddl.sql:2336: ERROR: relation "overlays" does not exist psql:/home/sourav/Projects/ENV/local/lib/python2.7/site-packages/arches/db/ddl/db_ddl.sql:2355: ERROR: type "public.geometry" does not exist LINE 6: geometry public.geometry(MultiPoint,4326), ^ psql:/home/sourav/Projects/ENV/local/lib/python2.7/site-packages/arches/db/ddl/db_ddl.sql:2357: ERROR: relation "aux.addresses" does not exist psql:/home/sourav/Projects/ENV/local/lib/python2.7/site-packages/arches/db/ddl/db_ddl.sql:2366: ERROR: relation "aux.addresses" does not exist psql:/home/sourav/Projects/ENV/local/lib/python2.7/site-packages/arches/db/ddl/db_ddl.sql:2383: ERROR: type "public.geometry" does not exist LINE 5: geometry public.geometry(MultiPolygon,4326) ^ psql:/home/sourav/Projects/ENV/local/lib/python2.7/site-packages/arches/db/ddl/db_ddl.sql:2385: ERROR: relation "aux.parcels" does not exist psql:/home/sourav/Projects/ENV/local/lib/python2.7/site-packages/arches/db/ddl/db_ddl.sql:2394: ERROR: relation "aux.parcels" does not exist Thanks, Shiva On 28 September 2017 at 22:01, Adam Cox <[email protected]> wrote: Hmm, this looks familiar, doesn't it? It makes me think that postgres/postgis is not installed correctly. In a terminal can you run psql -U postgres and then SELECT PostGIS_full_version(); Let me know the output. Adam On Wed, Sep 27, 2017 at 2:05 PM, Shiva Shankar Mahato < [email protected]> wrote: Thanx for quick reply. I did comment the line RESOURCE_MODEL = {'default': ' my_hip_app.models.resource.Resource'}. and everything working fine. Thank you. I have one more problem, which arise after it . Whenever I am adding the geometry in the location it is showing the error. # I have included the screenshot of the error page. I have one more problem, which arise after it . Whenever I am adding the geometry in the location it is showing the error. # I have included the screenshot of the error page. [error referencing "geometries" relation...] -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
