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 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1SETSETSETSETSETSET setval-------- 5(1 row)* *SETSETSETSETSETSETSET 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]> 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 >> >> 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-0 >>> fa28331b4fc\archesproject\arches\Search\engines\elasticsearch-1.1.1\bin) >>> >>> >>> *2. Install_dependencies.bat* (C:\arches-web\arches-arches-0fa28 >>> 331b4fc\archesproject\install) >>> >>> >>> >>> *3. Runserver.bat* (C:\arches-web\arches-arches-0fa28331b4fc) >>> >>> >>> >>> *4. Install_arches_db.bat* (C:\arches-web\arches-arches-0fa28 >>> 331b4fc\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-0fa28331b >>> 4fc\archesproject\build) >>> >>> >>> >>> *3. Runserver.bat* (C:\arches-web\arches-arches-0fa28331b4fc) >>> >>> >>> >>> *4. Build.bat* (C:\arches-web\arches-arches-0fa28331b4fc\archespr >>> oject\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-0fa28331b4 >>> fc\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]. For more options, visit https://groups.google.com/d/optout.
