date:20170410

Re: [Arches] Cannot import sample dropdowns reference data for Arches v4 dev

2017-04-10 Thread Alexei Peters

Thanks Joel, I think Ryan updated the documentation to reflect that.
Cheers,
Alexei


Director of Web Development - Farallon Geographics, Inc. - 971.227.3173

On Mon, Apr 10, 2017 at 12:01 PM, Joel Aldor  wrote:

> Thank you very much Alex. Now I got the Arches v4 dev environment up and
> running!
>
> However I noticed that I got this error when importing business data.
>
> (ENV) ubuntu@ARCHESv4PROD:~/Projects/arches$ python manage.py packages -o
> import_business_data -s tests/fixtures/data/csv/
> heritage_resource_model.csv
> operation: import_business_data
> package: arches
> 
> 
> No overwrite option indicated. Please rerun command with '-ow' parameter.
> 
> 
>
>
>
> May I suggest an edit to this command: it should be run like this:
>
> (ENV) ubuntu@ARCHESv4PROD:~/Projects/arches$ python manage.py packages -o
> import_business_data -s /home/ubuntu/Projects/arches/
> tests/fixtures/data/csv/heritage_resource_model.csv -ow overwrite
> operation: import_business_data
> package: arches
> Time to import_business_data = 0:00:40.954979
> No import errors
>
>
> The reason is because the* -ow overwrite* parameter needs the absolute
> path of the CSV file, in order to import the business data properly.
>
> Thanks,
>
> Joel
>
> On Tuesday, April 11, 2017 at 1:42:03 AM UTC+8, Alexei Peters wrote:
>>
>> Hi Joel,
>> The name of the file has changed actually.  Instead of dropdowns.rdf it's
>> now "arches_concept_collections.rdf".  I've updated the wiki to reflect
>> the change.  You should be able to run the following command now.
>>
>> *python manage.py packages -o import_reference_data -s
>> arches/db/schemes/arches_concept_collections.rdf -ow overwrite -st keep*
>>
>> Cheers
>> Alexei
>>
>>
>> Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
>> <(971)%20227-3173>
>>
>> On Mon, Apr 10, 2017 at 10:21 AM, Alexei Peters 
>> wrote:
>>
>>> Hi Joel,
>>> That file needs to be fixed.  It was messed up recently and just hasn't
>>> been fixed.  I"ll make sure that gets fixed today.
>>> Cheers,
>>> Alexei
>>>
>>>
>>> Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
>>>
>>> On Fri, Apr 7, 2017 at 9:02 PM, Joel Aldor  wrote:
>>>
 Hi all,

 Tried to follow the instructions on https://github.com/archespr
 oject/arches/wiki/Developer-Installation and I get this error when I
 started to import the dropdown lists reference data:

 ubuntu@ARCHESv4PROD:~/Projects/arches$ python manage.py packages -o
 impo
  _reference_data -s arches/db/schemes/dropdowns.rdf
 -ow overwrite -st keep
 operation: import_reference_data
 package: arches
 Traceback (most recent call last):
   File "manage.py", line 27, in 
 execute_from_command_line(sys.argv)
   File 
 "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/

management/__init__.py", line 353, in execute_from_command_line
 utility.execute()
   File 
 "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/

management/__init__.py", line 345, in execute
 self.fetch_command(subcommand).run_from_argv(self.argv)
   File 
 "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/

management/base.py", line 348, in run_from_argv
 self.execute(*args, **cmd_options)
   File 
 "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/

management/base.py", line 399, in execute
 output = self.handle(*args, **options)
   File 
 "/home/ubuntu/Projects/arches/arches/management/commands/packages.py",
 li
ne 160, in handle
 self.import_reference_data(options['source'],
 options['overwrite'], options[
'stage'])
   File 
 "/home/ubuntu/Projects/arches/arches/management/commands/packages.py",
 li
ne 351, in import_reference_data
 rdf = skos.read_file(data_source)
   File "/home/ubuntu/Projects/arches/arches/app/utils/skos.py", line
 56, in read
_file
 raise Exception('Error occurred while parsing the file %s' %
 path_to_file)
 Exception: Error occurred while parsing the file
 arches/db/schemes/dropdowns.rdf

 This is the first error I've encountered with the installation process.

 Thanks for the help!

 Joel

 --
 -- To post, send email to arches...@googlegroups.com. To unsubscribe,
 send email to archesprojec...@googlegroups.com. For more information,
 visit https://groups.google.com/d/forum/archesproject?hl=en
 ---
 You

Re: [Arches] Cannot import sample dropdowns reference data for Arches v4 dev

2017-04-10 Thread Joel Aldor

Thank you very much Alex. Now I got the Arches v4 dev environment up and 
running!

However I noticed that I got this error when importing business data. 

(ENV) ubuntu@ARCHESv4PROD:~/Projects/arches$ python manage.py packages -o 
import_business_data -s tests/fixtures/data/csv/heritage_resource_model.csv
operation: import_business_data
package: arches

No overwrite option indicated. Please rerun command with '-ow' parameter.




May I suggest an edit to this command: it should be run like this: 

(ENV) ubuntu@ARCHESv4PROD:~/Projects/arches$ python manage.py packages -o 
import_business_data -s 
/home/ubuntu/Projects/arches/tests/fixtures/data/csv/heritage_resource_model.csv
 
-ow overwrite
operation: import_business_data
package: arches
Time to import_business_data = 0:00:40.954979
No import errors


The reason is because the* -ow overwrite* parameter needs the absolute path 
of the CSV file, in order to import the business data properly.

Thanks,

Joel

On Tuesday, April 11, 2017 at 1:42:03 AM UTC+8, Alexei Peters wrote:
>
> Hi Joel,
> The name of the file has changed actually.  Instead of dropdowns.rdf it's 
> now "arches_concept_collections.rdf".  I've updated the wiki to reflect the 
> change.  You should be able to run the following command now.
>
> *python manage.py packages -o import_reference_data -s 
> arches/db/schemes/arches_concept_collections.rdf -ow overwrite -st keep*
>
> Cheers
> Alexei
>
>
> Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
>
> On Mon, Apr 10, 2017 at 10:21 AM, Alexei Peters  > wrote:
>
>> Hi Joel,
>> That file needs to be fixed.  It was messed up recently and just hasn't 
>> been fixed.  I"ll make sure that gets fixed today.
>> Cheers,
>> Alexei
>>
>>
>> Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
>>
>> On Fri, Apr 7, 2017 at 9:02 PM, Joel Aldor > > wrote:
>>
>>> Hi all,
>>>
>>> Tried to follow the instructions on 
>>> https://github.com/archesproject/arches/wiki/Developer-Installation and 
>>> I get this error when I started to import the dropdown lists reference data:
>>>
>>> ubuntu@ARCHESv4PROD:~/Projects/arches$ python manage.py packages -o impo 
>>> 
>>>_reference_data -s arches/db/schemes/dropdowns.rdf -ow overwrite 
>>> -st keep
>>> operation: import_reference_data
>>> package: arches
>>> Traceback (most recent call last):
>>>   File "manage.py", line 27, in 
>>> execute_from_command_line(sys.argv)
>>>   File 
>>> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/   
>>> 
>>>  management/__init__.py", line 353, in execute_from_command_line
>>> utility.execute()
>>>   File 
>>> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/   
>>> 
>>>  management/__init__.py", line 345, in execute
>>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>>   File 
>>> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/   
>>> 
>>>  management/base.py", line 348, in run_from_argv
>>> self.execute(*args, **cmd_options)
>>>   File 
>>> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/   
>>> 
>>>  management/base.py", line 399, in execute
>>> output = self.handle(*args, **options)
>>>   File 
>>> "/home/ubuntu/Projects/arches/arches/management/commands/packages.py", li   
>>> 
>>>  ne 160, in handle
>>> self.import_reference_data(options['source'], options['overwrite'], 
>>> options[   
>>>  'stage'])
>>>   File 
>>> "/home/ubuntu/Projects/arches/arches/management/commands/packages.py", li   
>>> 
>>>  ne 351, in import_reference_data
>>> rdf = skos.read_file(data_source)
>>>   File "/home/ubuntu/Projects/arches/arches/app/utils/skos.py", line 56, 
>>> in read 
>>>_file
>>> raise Exception('Error occurred while parsing the file %s' % 
>>> path_to_file)
>>> Exception: Error occurred while parsing the file 
>>> arches/db/schemes/dropdowns.rdf
>>>
>>> This is the first error I've encountered with the installation process. 
>>>
>>> Thanks for the help!
>>>
>>>

Re: [Arches] Cannot import sample dropdowns reference data for Arches v4 dev

2017-04-10 Thread Alexei Peters

Hi Joel,
The name of the file has changed actually.  Instead of dropdowns.rdf it's
now "arches_concept_collections.rdf".  I've updated the wiki to reflect the
change.  You should be able to run the following command now.

*python manage.py packages -o import_reference_data -s
arches/db/schemes/arches_concept_collections.rdf -ow overwrite -st keep*

Cheers
Alexei


Director of Web Development - Farallon Geographics, Inc. - 971.227.3173

On Mon, Apr 10, 2017 at 10:21 AM, Alexei Peters  wrote:

> Hi Joel,
> That file needs to be fixed.  It was messed up recently and just hasn't
> been fixed.  I"ll make sure that gets fixed today.
> Cheers,
> Alexei
>
>
> Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
> <(971)%20227-3173>
>
> On Fri, Apr 7, 2017 at 9:02 PM, Joel Aldor  wrote:
>
>> Hi all,
>>
>> Tried to follow the instructions on https://github.com/archespr
>> oject/arches/wiki/Developer-Installation and I get this error when I
>> started to import the dropdown lists reference data:
>>
>> ubuntu@ARCHESv4PROD:~/Projects/arches$ python manage.py packages -o impo
>>
>>_reference_data -s arches/db/schemes/dropdowns.rdf -ow
>> overwrite -st keep
>> operation: import_reference_data
>> package: arches
>> Traceback (most recent call last):
>>   File "manage.py", line 27, in 
>> execute_from_command_line(sys.argv)
>>   File 
>> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/
>>
>>management/__init__.py", line 353, in execute_from_command_line
>> utility.execute()
>>   File 
>> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/
>>
>>management/__init__.py", line 345, in execute
>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>   File 
>> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/
>>
>>management/base.py", line 348, in run_from_argv
>> self.execute(*args, **cmd_options)
>>   File 
>> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/
>>
>>management/base.py", line 399, in execute
>> output = self.handle(*args, **options)
>>   File "/home/ubuntu/Projects/arches/arches/management/commands/packages.py",
>> li
>>ne 160, in handle
>> self.import_reference_data(options['source'], options['overwrite'],
>> options[
>>  'stage'])
>>   File "/home/ubuntu/Projects/arches/arches/management/commands/packages.py",
>> li
>>ne 351, in import_reference_data
>> rdf = skos.read_file(data_source)
>>   File "/home/ubuntu/Projects/arches/arches/app/utils/skos.py", line 56,
>> in read
>>_file
>> raise Exception('Error occurred while parsing the file %s' %
>> path_to_file)
>> Exception: Error occurred while parsing the file
>> arches/db/schemes/dropdowns.rdf
>>
>> This is the first error I've encountered with the installation process.
>>
>> Thanks for the help!
>>
>> Joel
>>
>> --
>> -- To post, send email to archesproject@googlegroups.com. To
>> unsubscribe, send email to archesproject+unsubscr...@googlegroups.com.
>> For more information, visit https://groups.google.com/d/fo
>> rum/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 archesproject+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
-- To post, send email to archesproject@googlegroups.com. To unsubscribe, send 
email to archesproject+unsubscr...@googlegroups.com. 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 archesproject+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Arches] Re: Using Arches Designer in v4

2017-04-10 Thread Alexei Peters

Sorry, that's right, we recently upgraded to 9.6 (required for spatial
clustering)


Director of Web Development - Farallon Geographics, Inc. - 971.227.3173

On Mon, Apr 10, 2017 at 10:20 AM, Adam Cox  wrote:

> Hi Alexei, Arches actually requires 9.6, as far as I've understood it (and
> how we currently have it documented).
>
> Scott, it is a postgres version issue that you're seeing, just as Alexei
> said. If you do need to have multiple postgres versions on your machine,
> that is fine, you'll just have to make sure that Arches knows which port to
> find 9.6 on (you can do this in the settings.py or settings_local.py file).
>
> Adam
>
> On Mon, Apr 10, 2017 at 12:15 PM, Alexei Peters 
> wrote:
>
>> Hi Scott,
>> What version of Postgres are you running?  Arches requires 9.5  Looking
>> at the error it looks like db schema wasn't loaded properly because of a
>> reference to a jsonb column.  As far as I know, jsonb wan't available until
>> Postgres 9.4
>> Just so you know, you can run multiple versions of Postgres on a single
>> machine if you're worried about upgrading (I'm in fact running 9.3, 9.4,
>> 9.5 and 9.6).
>> Cheers,
>> Alexei
>>
>>
>> Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
>> <(971)%20227-3173>
>>
>> On Sat, Apr 8, 2017 at 9:11 AM, Scott Branting 
>> wrote:
>>
>>> Perhaps related to this, I thought that Adam's .bat file ran through the
>>> setup_db step.  However, with Susan's issue with needing to do that step
>>> and Joel running into an error on the additional setup database commands, I
>>> tried to try recreating the database to see if I could solve this issue.  I
>>> ran python manage.py packages -o setup.db and ran into the following error.
>>>
>>> (ENV) C:\ArchesProjects\arches>python manage.py packages -o setup_db
>>> operation: setup_db
>>> package: arches
>>> Password for user postgres:
>>>  pg_terminate_backend
>>> --
>>> (0 rows)
>>>
>>>
>>> DROP DATABASE
>>> CREATE DATABASE
>>> Operations to perform:
>>>   Apply all migrations: sessions, admin, guardian, auth, models,
>>> contenttypes
>>> Running migrations:
>>>   Rendering model states... DONE
>>>   Applying contenttypes.0001_initial... OK
>>>   Applying auth.0001_initial... OK
>>>   Applying admin.0001_initial... OK
>>>   Applying admin.0002_logentry_remove_auto_add... OK
>>>   Applying contenttypes.0002_remove_content_type_name... OK
>>>   Applying auth.0002_alter_permission_name_max_length... OK
>>>   Applying auth.0003_alter_user_email_max_length... OK
>>>   Applying auth.0004_alter_user_username_opts... OK
>>>   Applying auth.0005_alter_user_last_login_null... OK
>>>   Applying auth.0006_require_contenttypes_0002... OK
>>>   Applying auth.0007_alter_validators_add_error_messages... OK
>>>   Applying guardian.0001_initial... OK
>>>   Applying models.0001_initial...Traceback (most recent call last):
>>>   File "manage.py", line 27, in 
>>> execute_from_command_line(sys.argv)
>>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>>> ent\__init__.
>>> py", line 353, in execute_from_command_line
>>> utility.execute()
>>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>>> ent\__init__.
>>> py", line 345, in execute
>>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>>> ent\base.py",
>>>  line 348, in run_from_argv
>>> self.execute(*args, **cmd_options)
>>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>>> ent\base.py",
>>>  line 399, in execute
>>> output = self.handle(*args, **options)
>>>   File "C:\ArchesProjects\arches\arches\management\commands\packages.py",
>>> line 1
>>> 25, in handle
>>> self.setup_db(package_name)
>>>   File "C:\ArchesProjects\arches\arches\management\commands\packages.py",
>>> line 2
>>> 62, in setup_db
>>> management.call_command('migrate')
>>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>>> ent\__init__.
>>> py", line 119, in call_command
>>> return command.execute(*args, **defaults)
>>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>>> ent\base.py",
>>>  line 399, in execute
>>> output = self.handle(*args, **options)
>>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>>> ent\commands\
>>> migrate.py", line 200, in handle
>>> executor.migrate(targets, plan, fake=fake, fake_initial=fake_initial)
>>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\migration
>>> s\executor.py
>>> ", line 92, in migrate
>>> self._migrate_all_forwards(plan, full_plan, fake=fake,
>>> fake_initial=fake_ini
>>> tial)
>>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\migration
>>> s\executor.py
>>> ", line 121, in _migrate_all_forwards
>>> state = self.apply_migration(state, migration, fake=fake,
>>> fake_initial=fake_
>>> initial)
>>>

Re: [Arches] Cannot import sample dropdowns reference data for Arches v4 dev

2017-04-10 Thread Alexei Peters

Hi Joel,
That file needs to be fixed.  It was messed up recently and just hasn't
been fixed.  I"ll make sure that gets fixed today.
Cheers,
Alexei


Director of Web Development - Farallon Geographics, Inc. - 971.227.3173

On Fri, Apr 7, 2017 at 9:02 PM, Joel Aldor  wrote:

> Hi all,
>
> Tried to follow the instructions on https://github.com/
> archesproject/arches/wiki/Developer-Installation and I get this error
> when I started to import the dropdown lists reference data:
>
> ubuntu@ARCHESv4PROD:~/Projects/arches$ python manage.py packages -o impo
>
>_reference_data -s arches/db/schemes/dropdowns.rdf -ow
> overwrite -st keep
> operation: import_reference_data
> package: arches
> Traceback (most recent call last):
>   File "manage.py", line 27, in 
> execute_from_command_line(sys.argv)
>   File 
> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/
>
>management/__init__.py", line 353, in execute_from_command_line
> utility.execute()
>   File 
> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/
>
>management/__init__.py", line 345, in execute
> self.fetch_command(subcommand).run_from_argv(self.argv)
>   File 
> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/
>
>management/base.py", line 348, in run_from_argv
> self.execute(*args, **cmd_options)
>   File 
> "/home/ubuntu/Projects/ENV/local/lib/python2.7/site-packages/django/core/
>
>management/base.py", line 399, in execute
> output = self.handle(*args, **options)
>   File "/home/ubuntu/Projects/arches/arches/management/commands/packages.py",
> li
>ne 160, in handle
> self.import_reference_data(options['source'], options['overwrite'],
> options[
>  'stage'])
>   File "/home/ubuntu/Projects/arches/arches/management/commands/packages.py",
> li
>ne 351, in import_reference_data
> rdf = skos.read_file(data_source)
>   File "/home/ubuntu/Projects/arches/arches/app/utils/skos.py", line 56,
> in read
>_file
> raise Exception('Error occurred while parsing the file %s' %
> path_to_file)
> Exception: Error occurred while parsing the file
> arches/db/schemes/dropdowns.rdf
>
> This is the first error I've encountered with the installation process.
>
> Thanks for the help!
>
> Joel
>
> --
> -- To post, send email to archesproject@googlegroups.com. To unsubscribe,
> send email to archesproject+unsubscr...@googlegroups.com. 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 archesproject+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
-- To post, send email to archesproject@googlegroups.com. To unsubscribe, send 
email to archesproject+unsubscr...@googlegroups.com. 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 archesproject+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Arches] Re: Using Arches Designer in v4

2017-04-10 Thread Adam Cox

Hi Alexei, Arches actually requires 9.6, as far as I've understood it (and
how we currently have it documented).

Scott, it is a postgres version issue that you're seeing, just as Alexei
said. If you do need to have multiple postgres versions on your machine,
that is fine, you'll just have to make sure that Arches knows which port to
find 9.6 on (you can do this in the settings.py or settings_local.py file).

Adam

On Mon, Apr 10, 2017 at 12:15 PM, Alexei Peters  wrote:

> Hi Scott,
> What version of Postgres are you running?  Arches requires 9.5  Looking at
> the error it looks like db schema wasn't loaded properly because of a
> reference to a jsonb column.  As far as I know, jsonb wan't available until
> Postgres 9.4
> Just so you know, you can run multiple versions of Postgres on a single
> machine if you're worried about upgrading (I'm in fact running 9.3, 9.4,
> 9.5 and 9.6).
> Cheers,
> Alexei
>
>
> Director of Web Development - Farallon Geographics, Inc. - 971.227.3173
> <(971)%20227-3173>
>
> On Sat, Apr 8, 2017 at 9:11 AM, Scott Branting 
> wrote:
>
>> Perhaps related to this, I thought that Adam's .bat file ran through the
>> setup_db step.  However, with Susan's issue with needing to do that step
>> and Joel running into an error on the additional setup database commands, I
>> tried to try recreating the database to see if I could solve this issue.  I
>> ran python manage.py packages -o setup.db and ran into the following error.
>>
>> (ENV) C:\ArchesProjects\arches>python manage.py packages -o setup_db
>> operation: setup_db
>> package: arches
>> Password for user postgres:
>>  pg_terminate_backend
>> --
>> (0 rows)
>>
>>
>> DROP DATABASE
>> CREATE DATABASE
>> Operations to perform:
>>   Apply all migrations: sessions, admin, guardian, auth, models,
>> contenttypes
>> Running migrations:
>>   Rendering model states... DONE
>>   Applying contenttypes.0001_initial... OK
>>   Applying auth.0001_initial... OK
>>   Applying admin.0001_initial... OK
>>   Applying admin.0002_logentry_remove_auto_add... OK
>>   Applying contenttypes.0002_remove_content_type_name... OK
>>   Applying auth.0002_alter_permission_name_max_length... OK
>>   Applying auth.0003_alter_user_email_max_length... OK
>>   Applying auth.0004_alter_user_username_opts... OK
>>   Applying auth.0005_alter_user_last_login_null... OK
>>   Applying auth.0006_require_contenttypes_0002... OK
>>   Applying auth.0007_alter_validators_add_error_messages... OK
>>   Applying guardian.0001_initial... OK
>>   Applying models.0001_initial...Traceback (most recent call last):
>>   File "manage.py", line 27, in 
>> execute_from_command_line(sys.argv)
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>> ent\__init__.
>> py", line 353, in execute_from_command_line
>> utility.execute()
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>> ent\__init__.
>> py", line 345, in execute
>> self.fetch_command(subcommand).run_from_argv(self.argv)
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>> ent\base.py",
>>  line 348, in run_from_argv
>> self.execute(*args, **cmd_options)
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>> ent\base.py",
>>  line 399, in execute
>> output = self.handle(*args, **options)
>>   File "C:\ArchesProjects\arches\arches\management\commands\packages.py",
>> line 1
>> 25, in handle
>> self.setup_db(package_name)
>>   File "C:\ArchesProjects\arches\arches\management\commands\packages.py",
>> line 2
>> 62, in setup_db
>> management.call_command('migrate')
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>> ent\__init__.
>> py", line 119, in call_command
>> return command.execute(*args, **defaults)
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>> ent\base.py",
>>  line 399, in execute
>> output = self.handle(*args, **options)
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\managem
>> ent\commands\
>> migrate.py", line 200, in handle
>> executor.migrate(targets, plan, fake=fake, fake_initial=fake_initial)
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\migration
>> s\executor.py
>> ", line 92, in migrate
>> self._migrate_all_forwards(plan, full_plan, fake=fake,
>> fake_initial=fake_ini
>> tial)
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\migration
>> s\executor.py
>> ", line 121, in _migrate_all_forwards
>> state = self.apply_migration(state, migration, fake=fake,
>> fake_initial=fake_
>> initial)
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\migration
>> s\executor.py
>> ", line 198, in apply_migration
>> state = migration.apply(state, schema_editor)
>>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\migration
>> s\migration.p
>> y", line 123, in apply
>> operation.database_forwards(self.app_label, schema_editor,
>>

Re: [Arches] Re: Using Arches Designer in v4

2017-04-10 Thread Alexei Peters

Hi Scott,
What version of Postgres are you running?  Arches requires 9.5  Looking at
the error it looks like db schema wasn't loaded properly because of a
reference to a jsonb column.  As far as I know, jsonb wan't available until
Postgres 9.4
Just so you know, you can run multiple versions of Postgres on a single
machine if you're worried about upgrading (I'm in fact running 9.3, 9.4,
9.5 and 9.6).
Cheers,
Alexei


Director of Web Development - Farallon Geographics, Inc. - 971.227.3173

On Sat, Apr 8, 2017 at 9:11 AM, Scott Branting 
wrote:

> Perhaps related to this, I thought that Adam's .bat file ran through the
> setup_db step.  However, with Susan's issue with needing to do that step
> and Joel running into an error on the additional setup database commands, I
> tried to try recreating the database to see if I could solve this issue.  I
> ran python manage.py packages -o setup.db and ran into the following error.
>
> (ENV) C:\ArchesProjects\arches>python manage.py packages -o setup_db
> operation: setup_db
> package: arches
> Password for user postgres:
>  pg_terminate_backend
> --
> (0 rows)
>
>
> DROP DATABASE
> CREATE DATABASE
> Operations to perform:
>   Apply all migrations: sessions, admin, guardian, auth, models,
> contenttypes
> Running migrations:
>   Rendering model states... DONE
>   Applying contenttypes.0001_initial... OK
>   Applying auth.0001_initial... OK
>   Applying admin.0001_initial... OK
>   Applying admin.0002_logentry_remove_auto_add... OK
>   Applying contenttypes.0002_remove_content_type_name... OK
>   Applying auth.0002_alter_permission_name_max_length... OK
>   Applying auth.0003_alter_user_email_max_length... OK
>   Applying auth.0004_alter_user_username_opts... OK
>   Applying auth.0005_alter_user_last_login_null... OK
>   Applying auth.0006_require_contenttypes_0002... OK
>   Applying auth.0007_alter_validators_add_error_messages... OK
>   Applying guardian.0001_initial... OK
>   Applying models.0001_initial...Traceback (most recent call last):
>   File "manage.py", line 27, in 
> execute_from_command_line(sys.argv)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\
> management\__init__.
> py", line 353, in execute_from_command_line
> utility.execute()
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\
> management\__init__.
> py", line 345, in execute
> self.fetch_command(subcommand).run_from_argv(self.argv)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\
> management\base.py",
>  line 348, in run_from_argv
> self.execute(*args, **cmd_options)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\
> management\base.py",
>  line 399, in execute
> output = self.handle(*args, **options)
>   File "C:\ArchesProjects\arches\arches\management\commands\packages.py",
> line 1
> 25, in handle
> self.setup_db(package_name)
>   File "C:\ArchesProjects\arches\arches\management\commands\packages.py",
> line 2
> 62, in setup_db
> management.call_command('migrate')
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\
> management\__init__.
> py", line 119, in call_command
> return command.execute(*args, **defaults)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\
> management\base.py",
>  line 399, in execute
> output = self.handle(*args, **options)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\core\
> management\commands\
> migrate.py", line 200, in handle
> executor.migrate(targets, plan, fake=fake, fake_initial=fake_initial)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\
> migrations\executor.py
> ", line 92, in migrate
> self._migrate_all_forwards(plan, full_plan, fake=fake,
> fake_initial=fake_ini
> tial)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\
> migrations\executor.py
> ", line 121, in _migrate_all_forwards
> state = self.apply_migration(state, migration, fake=fake,
> fake_initial=fake_
> initial)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\
> migrations\executor.py
> ", line 198, in apply_migration
> state = migration.apply(state, schema_editor)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\
> migrations\migration.p
> y", line 123, in apply
> operation.database_forwards(self.app_label, schema_editor, old_state,
> projec
> t_state)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\
> migrations\operations\
> models.py", line 59, in database_forwards
> schema_editor.create_model(model)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\contrib\
> gis\db\backends\p
> ostgis\schema.py", line 56, in create_model
> super(PostGISSchemaEditor, self).create_model(model)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\
> backends\base\schema.p
> y", line 284, in create_model
> self.execute(sql, params or None)
>   File "C:\ArchesProjects\ENV\lib\site-packages\django\db\
> backends\base\schema.p
> y",

Re: [Arches] Cannot import sample dropdowns reference data for Arches v4 dev

Re: [Arches] Cannot import sample dropdowns reference data for Arches v4 dev

Re: [Arches] Cannot import sample dropdowns reference data for Arches v4 dev

Re: [Arches] Re: Using Arches Designer in v4

Re: [Arches] Cannot import sample dropdowns reference data for Arches v4 dev

Re: [Arches] Re: Using Arches Designer in v4

Re: [Arches] Re: Using Arches Designer in v4

7 matches

Site Navigation

Mail list logo

Footer information