Getting 'DatabaseOperations' object has no attribute 'geo_db_type' error when doing a syncdb
I'm attempting to run heroku run python manage.py syncdb
on my GeoDjango app on Heroku, but I get the following error:
AttributeError: 'DatabaseOperations' object has no attribute 'geo_db_type'
All of my research has yielded the same solution: make sure to use django.contrib.gis.db.backends.postgis
as the database engine. Funny thing is that I'm already doing this (and I also have django.contrib.gis
in INSTALLED_APPS
):
settings.py
DATABASES = {
'default': {
'ENGINE': 'django.contrib.gis.db.backends.postgis',
'NAME': '...',
'HOST': '...',
'PORT': ...,
'USER': '...',
'PASSWORD': '...'
}
}
INSTALLED_APPS = (
...,
'django.contrib.gis',
)
Is there something else I am missing? Any help is greatly appreciated, below is the full error trace for reference:
Running `python manage.py syncdb` attached to terminal... up, run.1
Creating tables ...
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_user_permissions
Creating table auth_user_groups
Creating table auth_user
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table django_admin_log
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "/app/lib/python2.7/site-packages/django/core/management/__init__.py", line 443, in execute_from_command_line
utility.execute()
File "/app/lib/python2.7/site-packages/django/core/management/__init__.py", line 382, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/app/lib/python2.7/site-packages/django/core/management/base.py", line 196, in run_from_argv
self.execute(*args, **options.__dict__)
File "/app/lib/python2.7/site-packages/django/core/management/base.py", line 232, in execute
output = self.handle(*args, **options)
File "/app/lib/python2.7/site-packages/django/core/management/base.py", line 371, in handle
return self.handle_noargs(**options)
File "/app/lib/python2.7/site-packages/django/core/management/commands/syncdb.py", line 91, in handle_noargs
sql, references = connection.creation.sql_create_model(model, self.style, seen_models)
File "/app/lib/python2.7/site-packages/django/db/backends/creation.py", line 44, in sql_create_model
col_type = f.db_type(connection=self.connection)
File "/app/lib/python2.7/site-packages/django/contrib/gis/db/models/fields.py", line 200, in db_type
return connection.ops.geo_db_type(self)
AttributeError: 'DatabaseOperations' object has no attribute 'geo_db_type'
Update: I followed the GeoDjango tutorial and Heroku/Django tutorial, and built a simple app that works on my dev machine. I pushed it to Heroku using a custom GeoDjango buildpack, and tried syncdb, but get the same error. Is this an issue with Django/GeoDjango, Heroku, or the buildpack? My dev environment is using PostgreSQL 9.1 and PostGIS 2.0, but Heroku uses 9.0.9 and 1.5, could that be the issue?
Solution 1:
The OP was using the GeoDjango buildpack, but in case anyone gets here using Geo buildpack and dj_database_url
like I was, in settings.py
don't forget the last line:
import dj_database_url
DATABASES['default'] = dj_database_url.config()
DATABASES['default']['ENGINE'] = 'django.contrib.gis.db.backends.postgis'
UPDATE
dj_database_url
directly supports PostGIS. You can do without the last line in the code above if you can change your database URL to start with postgis
.
Solution 2:
I got this error when trying to run tests with the test db set like so:
if 'test' in sys.argv:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
'NAME': '_testdb',
}
}
The problem is that the sqlite3 DatabaseOperations
object doesn't have the attribute geo_db_type
(like the title of this post suggests).
My solution was to change the backend to the sqlite equivalent GIS engine:
'ENGINE': 'django.contrib.gis.db.backends.spatialite'
See the Django docs on GeoDjango installation for all the possible backends, with installation instructions: https://docs.djangoproject.com/en/3.0/ref/contrib/gis/install/#spatial-database
Solution 3:
I was having the same problem and I had to change:
'ENGINE': 'django.db.backends.postgresql_psycopg2',
to:
'ENGINE': 'django.contrib.gis.db.backends.postgis',
Solution 4:
for me helped
1) add 'django.contrib.gis',
to INSTALLED_APPS
2) change from
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
to
DATABASES = {
'default': {
'ENGINE': 'django.contrib.gis.db.backends.mysql',