Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error on updatelayers command default to sqlite3 with error #12327

Open
imperialbeachca opened this issue Jun 12, 2024 · 1 comment
Open

Error on updatelayers command default to sqlite3 with error #12327

imperialbeachca opened this issue Jun 12, 2024 · 1 comment

Comments

@imperialbeachca
Copy link

Expected Behavior

running python manage.py updatelayers -w geonode on the django4geonode container shell should return log like described on point number 9, Geonode documentation, administering, geonode management commands, loading data into geonode, management command (here)
Actual Behavior

DJANGO_SETTINGS_MODULE=geonode.settings python3 manage.py updatelayers -w ibgis returns the following error:
Traceback (most recent call last):
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 423, in execute
return Database.Cursor.execute(self, query, params)
sqlite3.OperationalError: no such table: people_profile

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "/opt/geonode/manage.py", line 29, in
execute_from_command_line(sys.argv)
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/core/management/init.py", line 419, in execute_from_command_line
utility.execute()
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/core/management/init.py", line 413, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/core/management/base.py", line 354, in run_from_argv
self.execute(*args, **cmd_options)
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/core/management/base.py", line 398, in execute
output = self.handle(*args, **options)
File "/opt/geonode/geonode/geoserver/management/commands/updatelayers.py", line 95, in handle
owner = get_valid_user(user)
File "/opt/geonode/geonode/people/utils.py", line 46, in get_valid_user
theuser = get_default_user()
File "/opt/geonode/geonode/people/utils.py", line 32, in get_default_user
if superusers.exists():
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/models/query.py", line 808, in exists
return self.query.has_results(using=self.db)
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/models/sql/query.py", line 561, in has_results
return compiler.has_results()
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1145, in has_results
return bool(self.execute_sql(SINGLE))
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/models/sql/compiler.py", line 1175, in execute_sql
cursor.execute(sql, params)
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/backends/utils.py", line 98, in execute
return super().execute(sql, params)
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/backends/utils.py", line 79, in _execute
with self.db.wrap_database_errors:
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/utils.py", line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/home/ubuntu/.virtualenvs/geonode/lib/python3.10/site-packages/django/db/backends/sqlite3/base.py", line 423, in execute
return Database.Cursor.execute(self, query, params)
django.db.utils.OperationalError: no such table: people_profile

Steps to Reproduce the Problem

Setup Geonode Vanilla
Go to geoserver and import a layer directly from postgis (in my case, a remote postgis server), then publish on ibgis workspace
Access to geonode shell
Run DJANGO_SETTINGS_MODULE=geonode.settings python3 manage.py updatelayers -w ibgis

Specifications

GeoNode version: 4.2.3
Installation method Geonode Vanilla:
Platform: Ubuntu 22.04
Additional details: Server in AWS.  Env variables updated to work on custom domain using https
@mattiagiupponi
Copy link
Contributor

Is the environment file exported in the env? What does env | grep DATABASE_URL return?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants