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] 
> <javascript:>> 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] <javascript:>. To 
>> unsubscribe, send email to [email protected] <javascript:>. 
>> 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] <javascript:>.
>> 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.

Reply via email to