Hi Jared, the following error:
psql:C:/arches-web/arches-arches-0fa28331b4fc/archesproject/db/Deployment Scripts/DatabaseCleanup.sql:1: ERROR: coulmn "procpid" does not exist LINE 1: SELECT pg_terminate_backend(procpid) from pg_stat_activity w... pg_terminate_backend is not that big a deal. It's a script that was written for postgres <= 9.1. From postgres 9.2 and up, procpid should be pid. I think in most cases, just ignoring this error is fine. You can also just change procpid to pid in this file and in databasecleanup.py (see the previous mails by Eloise Stancioff who ran into the exact same issue). Cheers, Koen ________________________________________ Van: [email protected] [[email protected]] namens Jared Koller [[email protected]] Verzonden: zaterdag 1 november 2014 4:24 Aan: Cyrus Hiatt CC: [email protected]; Alexei Peters Onderwerp: Re: [Arches] Error during CDS package install Hi Cyrus and Alexei, Thank you both for your help. I have done as you have instructed and am still encountering the same error message about Django. In addition, I have noticed two other issues: 1. If I view Arches in IE prior to uploading the package, the map is frozen. I am unable to zoom or navigate to a different area on the map. The pointer still registers the longitude and latitude however when I move it. 2. During the install_arches_db step, I have noticed the following error message appear after entering my password (postgis) for the first time: psql:C:/arches-web/arches-arches-0fa28331b4fc/archesproject/db/Deployment Scripts/DatabaseCleanup.sql:1: ERROR: coulmn "procpid" does not exist LINE 1: SELECT pg_terminate_backend(procpid) from pg_stat_activity w... pg_terminate_backend After I enter my password in again, the following occurs: INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 INSERT 0 1 SET SET SET SET SET SET setval -------- 5 (1 row) SET SET SET SET SET SET SET setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 24 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 1 (1 row) setval -------- 8 (1 row) setval -------- 1 (1 row) VACUUM Any advice you have I would appreciate greatly. Thank you, Jared On Fri, Oct 31, 2014 at 6:07 PM, Cyrus Hiatt <[email protected]<mailto:[email protected]>> wrote: Hi Jared - I ran through the build process and got an empty database and the same error that you were getting (Django.db.utils.ProgrammingError: more than one row returned by a subquery used as an expression). I just pushed a fix the issue, so if you follow the steps Alexei outlined, your install should be okay. Hope that helps, Cyrus On Friday, October 31, 2014 11:46:20 AM UTC-7, Alexei Peters wrote: Hi Jared, Thanks for letting us know what's going on. Just so you know, the proper steps to build arches are: First, though, my assumptions are: 1. you've already run Install_dependencies.bat 2. you've already added 'cds' to your INSTALLED_PACKAGES setting in settings.py 3. you've downloaded the 'cds' package and put it in the archesproject/packages folder 4. you've set the LOAD_TEST_DATA = True in settings.py So, the steps to build are: 1. Install_arches_db.bat 2. Runserver.bat (should open 2 windows, 1 for django's development web server, and 1 for Elasticsearch) 3. Install_packages.bat That's it. You should be able to go to localhost:8000/Arches and see the website with data. We're going to run through the steps you mention above to see if we can reproduce the error (and then fix). We'll let you know what we find out. We'll try and get back to you by Monday (11/3) Cheers, Alexei Director of Web Development - Farallon Geographics, Inc. - 971.227.3173<tel:971.227.3173> On Fri, Oct 31, 2014 at 9:30 AM, Jared Koller <[email protected]> wrote: Hello, I have been working with Scott Branting, a contributor to the forum, to create an Arches project on a remote server. We have run into some difficulties and would appreciate your help. We have had no problem installing and opening the database. Zoom and navigation are working fine. However when we attempt to install the CDS package, we run into issues. The map comes up along with an "initializing" bar that runs on a loop. We are using the same data source data that both Scott and I have been able to use on our local machines during a test run. Here is the workflow: Prior to installing the CDS Package: After PostgreSQL, Java, Python, GEOS, Django, and elasticsearch download and install. 1. Elasticsearch.bat (C:\arches-web\arches-arches-0fa28331b4fc\archesproject\arches\Search\engines\elasticsearch-1.1.1\bin) 2. Install_dependencies.bat (C:\arches-web\arches-arches-0fa28331b4fc\archesproject\install) 3. Runserver.bat (C:\arches-web\arches-arches-0fa28331b4fc) 4. Install_arches_db.bat (C:\arches-web\arches-arches-0fa28331b4fc\archesproject\build) 5. Build.bat (C:\arches-web\arches-arches-0fa28331b4fc\archesproject\build) When I check the browser, everything is working fine with no data showing. So next we: 1. Turn off the server 2. Install_arches_db.bat (C:\arches-web\arches-arches-0fa28331b4fc\archesproject\build) 3. Runserver.bat (C:\arches-web\arches-arches-0fa28331b4fc) 4. Build.bat (C:\arches-web\arches-arches-0fa28331b4fc\archesproject\build) 5. In settings.py (C:\arches-web\arches-arches-0fa28331b4fc\archesproject) Change: INSTALLED_PACKAGES = ( # entries here should correspond to folders within the packages directory 'cds', #'fileupload', ) 6. In settings.py (C:\arches-web\arches-arches-0fa28331b4fc\archesproject\packages\cds) Change: LOAD_TEST_DATA = False 7. Install_packages.bat (C:\arches-web\arches-arches-0fa28331b4fc\archesproject\build) It is at this point that I receive an error: Django.db.utils.ProgrammingError: more than one row returned by a subquery used as an expression >From here, when I open up the browser , I just get the initializing loop. What does everyone think? Jared -- -- 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. -- -- 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. -- -- 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.
