Hi Alexei, >> I am completely installed PostgreSQL, Java, Python, GEOS, Django, and elasticsearch.
>> http://localhost:8000/Arches/index.htm It's opened, but no data, I couldn't make Add/Edit resource on it. so, i installed cds package with following steps . . . 1. I've already run Install_dependencies.bat >> it's okay 2. I've already added 'cds' to your INSTALLED_PACKAGES setting in settings.py >>settings.py located on C:\arches-web\archesproject\settings.py INSTALLED_PACKAGES = ( # entries here should correspond to folders within the packages directory 'cds', ) 3. I've downloaded the 'cds' package and put it in the archesproject/packages folder >> downloaded and copy cds to C:\arches-web\archesproject\packages\ 4. I've set the LOAD_TEST_DATA = True in settings.py >> setting.py located on C:\arches-web\archesproject\packages\cds\settings.py LOAD_TEST_DATA = True in And Then, 1. I run Install_arches_db.bat >> It's okay 2. Then I run runserver.bat >> It's okay 3. Then run Install_packages.bat >>> I got following Error !!!! So, Please Advice Me C:\arches-web\archesproject\build>cd C:\arches-web\archesproject\build\.. C:\arches-web\archesproject>call "virtualenv/ENV/Scripts/activate.bat" operation: install .Traceback (most recent call last): File "../manage.py", line 28, in <module> execute_from_command_line(sys.argv) File "C:\arches-web\archesproject\virtualenv\ENV\lib\site-packages\django\core \management\__init__.py", line 399, in execute_from_command_line utility.execute() File "C:\arches-web\archesproject\virtualenv\ENV\lib\site-packages\django\core \management\__init__.py", line 392, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "C:\arches-web\archesproject\virtualenv\ENV\lib\site-packages\django\core \management\base.py", line 242, in run_from_argv self.execute(*args, **options.__dict__) File "C:\arches-web\archesproject\virtualenv\ENV\lib\site-packages\django\core \management\base.py", line 285, in execute output = self.handle(*args, **options) File "C:\arches-web\archesproject\build\management\commands\packages.py", line 41, in handle self.load_package(package) File "C:\arches-web\archesproject\build\management\commands\packages.py", line 46, in load_package install(settings.ROOT_DIR) File "C:\arches-web\archesproject\packages\cds\setup.py", line 45, in install concepts.load_concepts(package_settings.ROOT_DIR) File "C:\arches-web\archesproject\packages\cds\install\concepts.py", line 18, in load_concepts load_concepts_from_nodes_and_edges(os.path.join(packagepath, 'source_data', 'concepts'), 'concept_schema_nodes.csv','concept_schema_edges.csv') File "C:\arches-web\archesproject\packages\cds\install\concepts.py", line 122, in load_concepts_from_nodes_and_edges insert_concept(concept_node["CONCEPTSCHEMENAME"], concept_node["LABEL"], '', 'en-us', concept_node["ID"]) File "C:\arches-web\archesproject\packages\cds\install\concepts.py", line 168, in insert_concept """ % (conceptschemename,label.replace("'","''"),note,languageid,legacyid)) File "C:\arches-web\archesproject\virtualenv\ENV\lib\site-packages\django\db\b ackends\util.py", line 69, in execute return super(CursorDebugWrapper, self).execute(sql, params) File "C:\arches-web\archesproject\virtualenv\ENV\lib\site-packages\django\db\b ackends\util.py", line 53, in execute return self.cursor.execute(sql, params) File "C:\arches-web\archesproject\virtualenv\ENV\lib\site-packages\django\db\u tils.py", line 99, in __exit__ six.reraise(dj_exc_type, dj_exc_value, traceback) File "C:\arches-web\archesproject\virtualenv\ENV\lib\site-packages\django\db\b ackends\util.py", line 51, in execute return self.cursor.execute(sql) django.db.utils.IntegrityError: null value in column "conceptschemeid" violates not-null constraint DETAIL: Failing row contains (99328e78-7cbb-11e4-b234-a3dc68264d0c, null, dff1a 82c-dacc-11e2-9dba-fb74e0fc7ace). CONTEXT: SQL statement "INSERT INTO concepts.concepts(conceptid, conceptschemei d, legacyoid) VALUES (v_conceptid,v_conceptschemeid, p_legacyid)" PL/pgSQL function insert_concept(text,text,text,text,text) line 11 at SQL statem ent Press any key to continue . . . How do i fix it . On Saturday, November 1, 2014 1:16:20 AM UTC+6:30, 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.
