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 <[email protected]> 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 <module> > 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", line 110, in execute > cursor.execute(sql, params) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\backends\utils.py", > li > ne 79, in execute > return super(CursorDebugWrapper, self).execute(sql, params) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\backends\utils.py", > li > ne 64, in execute > return self.cursor.execute(sql, params) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\utils.py", line > 95, in > __exit__ > six.reraise(dj_exc_type, dj_exc_value, traceback) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\backends\utils.py", > li > ne 62, in execute > return self.cursor.execute(sql) > django.db.utils.ProgrammingError: type "jsonb" does not exist > LINE 1: ...OT NULL, "id" uuid NOT NULL PRIMARY KEY, "config" jsonb NULL... > > > > > Following this, when I try to run the Django server it now fails once I > login to localhost:8000 with the following error. (Previously it brought > up the landing page without any issues.) > > > (ENV) C:\ArchesProjects\arches>python manage.py runserver > Performing system checks... > > System check identified no issues (0 silenced). > > You have unapplied migrations; your app may not work properly until they > are app > lied. > Run 'python manage.py migrate' to apply them. > April 08, 2017 - 12:04:01 > Django version 1.9.2, using settings 'arches.settings' > Starting development server at http://127.0.0.1:8000/ > Quit the server with CTRL-BREAK. > Internal Server Error: / > Traceback (most recent call last): > File "C:\ArchesProjects\ENV\lib\site-packages\django\core\handlers\base.py", > l > ine 123, in get_response > response = middleware_method(request) > File "C:\ArchesProjects\arches\arches\app\utils\set_anonymous_user.py", > line 6 > , in process_request > if request.user.is_anonymous(): > File "C:\ArchesProjects\ENV\lib\site-packages\django\utils\functional.py", > lin > e 204, in inner > self._setup() > File "C:\ArchesProjects\ENV\lib\site-packages\django\utils\functional.py", > lin > e 351, in _setup > self._wrapped = self._setupfunc() > File "C:\ArchesProjects\ENV\lib\site-packages\django\contrib\ > auth\middleware.p > y", line 22, in <lambda> > request.user = SimpleLazyObject(lambda: get_user(request)) > File "C:\ArchesProjects\ENV\lib\site-packages\django\contrib\ > auth\middleware.p > y", line 10, in get_user > request._cached_user = auth.get_user(request) > File "C:\ArchesProjects\ENV\lib\site-packages\django\contrib\ > auth\__init__.py" > , line 167, in get_user > user_id = _get_user_session_key(request) > File "C:\ArchesProjects\ENV\lib\site-packages\django\contrib\ > auth\__init__.py" > , line 59, in _get_user_session_key > return get_user_model()._meta.pk.to_python(request.session[ > SESSION_KEY]) > File "C:\ArchesProjects\ENV\lib\site-packages\django\contrib\ > sessions\backends > \base.py", line 48, in __getitem__ > return self._session[key] > File "C:\ArchesProjects\ENV\lib\site-packages\django\contrib\ > sessions\backends > \base.py", line 198, in _get_session > self._session_cache = self.load() > File "C:\ArchesProjects\ENV\lib\site-packages\django\contrib\ > sessions\backends > \db.py", line 33, in load > expire_date__gt=timezone.now() > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\models\manager.py", > li > ne 122, in manager_method > return getattr(self.get_queryset(), name)(*args, **kwargs) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\models\query.py", > line > 381, in get > num = len(clone) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\models\query.py", > line > 240, in __len__ > self._fetch_all() > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\models\query.py", > line > 1074, in _fetch_all > self._result_cache = list(self.iterator()) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\models\query.py", > line > 52, in __iter__ > results = compiler.execute_sql() > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\ > models\sql\compiler.py > ", line 848, in execute_sql > cursor.execute(sql, params) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\backends\utils.py", > li > ne 79, in execute > return super(CursorDebugWrapper, self).execute(sql, params) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\backends\utils.py", > li > ne 64, in execute > return self.cursor.execute(sql, params) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\utils.py", line > 95, in > __exit__ > six.reraise(dj_exc_type, dj_exc_value, traceback) > File "C:\ArchesProjects\ENV\lib\site-packages\django\db\backends\utils.py", > li > ne 64, in execute > return self.cursor.execute(sql, params) > ProgrammingError: relation "django_session" does not exist > LINE 1: ...ession_data", "django_session"."expire_date" FROM "django_se... > ^ > > Thanks, > > Scott > ASOR CHI > > -- > -- 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.
