@klemens you are most definitely not alone.
I made a router that would allow me to have one database per app and I
get exactly the same type of error on both postgres and sqlite. Doing
syncdb on the default db work as it should but when I in this case do
a ./manage.py syncdb --database=ads I get the same error as above. A
relation to django_content_type doesn't exist.
.../lib/python2.6/site-packages/django/db/backends/postgresql_psycopg2/
base.py", line 44, in execute
return self.cursor.execute(query, args)
django.db.utils.DatabaseError: relation "django_content_type" does not
exist
LINE 1: ..."."app_label", "django_content_type"."model" FROM
"django_co...
My router looks like this
==dbrouter.py==
APPS_WITH_DB=('ads',
)
class AppRouter(object):
"""A router to control all database operations on models in
that belongs to a app in APPS_WITH_DB"""
def db_for_read(self, model, **hints):
if model._meta.app_label in APPS_WITH_DB:
return model._meta.app_label
return None
def db_for_write(self, model, **hints):
if model._meta.app_label in APPS_WITH_DB:
return model._meta.app_label
return None
def allow_relation(self, obj1, obj2, **hints):
if (obj1._meta.app_label in APPS_WITH_DB) or
(obj2._meta.app_label in APPS_WITH_DB):
return True
return None
def allow_syncdb(self, db, model):
"Make sure the app only appears on the db where it belongs"
#print "db=%s, app=%s, model=%s" % (db, model._meta.app_label,
model)
if db in APPS_WITH_DB:
return db == model._meta.app_label
elif model._meta.app_label in APPS_WITH_DB:
return False
return None
See
http://groups.google.com/group/django-developers/browse_thread/thread/3a40a72b4e419ad6
for the first
On Feb 3, 4:02 pm, Klemens Mantzos <klemens.mant...@gmail.com> wrote:
> thx!
>
> syncdbis now calling the database router before actually syncing to
> the db. but...
>
> ...stumbled upon a new problem:
>
> if i do
> python manage.pysyncdb--database=default
> before i sync the users database this error comes up (which seems ok to me):
> django.db.utils.DatabaseError: (1146, "Table
> 'multidb_user.auth_permission' doesn't exist")
>
> but if i do this:
> python manage.pysyncdb--database=users
> i get that every time (no matter if django_content_type already exists
> in the default db or not):
> django.db.utils.DatabaseError: (1146, "Table
> 'multidb_user.django_content_type' doesn't exist")
> (Tracebackhttp://pastie.org/807571.txt)
>
> seems that i'm the only one with this problem...but could find this
> ticket:http://code.djangoproject.com/ticket/11828(fixed aka. not
> reproduceable aka. wontfix)
>
> pretty sad. i need a extra user db, so i thought its pretty much the
> same as in the example in the docu
> (http://docs.djangoproject.com/en/dev/topics/db/multi-db/). except the
> masterslave stuff. but it seems like i'm constantly overseeing stuff.
>
> here is my code (again):
> # don't know but OtherRouter is maybe obsolete.
> DATABASE_ROUTERS = ['dbrouter.AuthRouter', 'dbrouter.OtherRouter']
>
> ### project/dbrouter.py
>
> class AuthRouter(object):
> """A router to control all database operations on models in
> the contrib.auth application"""
>
> ....
>
> def allow_syncdb(self, db, model):
> "Make sure the auth app only appears on the 'credentials' db"
> if db == 'users':
> return model._meta.app_label == 'auth'
> elif model._meta.app_label == 'auth':
> return False
> return None
>
> class OtherRouter(object):
> """A router that sets up a simple master/slave configuration"""
>
> ...
>
> def allow_syncdb(self, db, model):
> "Explicitly put all models on alldatabases."
> return True
>
> any suggestions?
>
> thx for your time,
> klemens
>
> On Wed, Feb 3, 2010 at 13:21, Russell Keith-Magee
>
>
>
> <freakboy3...@gmail.com> wrote:
> > On Mon, Feb 1, 2010 at 11:07 PM, Klemens Mantzos
> > <klemens.mant...@gmail.com> wrote:
> >> hi list,
>
> >> checked out the new multidb feature
> >> (http://docs.djangoproject.com/en/dev/topics/db/multi-db/).
>
> >> i assumed thatsyncdbwould only sync those models in the database
> >> when calling allow_syncdb() of the database routers return True. is
> >> that true?
>
> >> my problem:syncdbsyncs the complete model in the db. and i couldnt
> >> even figure out if the DATABASE_ROUTERS are correctly configured and
> >> working (django don't throws an error if the DATABASE_ROUTERS =
> >> ['foo.bar'])
>
> >> ### Django version 1.2 alpha 1 SVN-12120
>
> > Database routers weren't implemented until SVN-12272. You won't see
> > any errors with an earlier checkout because the DATABASE_ROUTERS
> > setting isn't being used at all.
>
> > Yours
> > Russ Magee %-)
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Django users" group.
> > To post to this group, send email to django-us...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > django-users+unsubscr...@googlegroups.com.
> > For more options, visit this group
> > athttp://groups.google.com/group/django-users?hl=en.
>
> --
> klemens mantzoshttp://fetzig.at/
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
