multidb Relation fields do not support nested lookups

[gerdkoetje]

He all,

Does anyone know why i can't do any relation lookups on any database other then the default database in 1.8.5 this worked fine in 1.6.1
it keeps trowing me: Relation fields do not support nested lookups

for example on
adds = ProfielenFlirts.objects.filter(vooruserprofielenuserprofilefictief=True).filter(Q(antwoord=) | Q(antwoordisnull=True)).count()

ProfielenFlirts is a non default database, the relation lookup is in the same database do.

my router
class DatingRouter(object):

def db_for_read(self, model, hints):

if model._meta.app_label == 'datingmodels':

return 'dating'

return 'default'

def db_for_write(self, model, hints):

if model._meta.app_label == 'datingmodels':

return 'dating'

return 'default'

def allow_relation(self, obj1, obj2, hints):

if obj1._meta.app_label == 'datingmodels' and obj2._meta.app_label == 'datingmodels':

return True

elif 'datingmodels' not in [obj1._meta.app_label, obj2._meta.app_label]:

return True

return False

def allow_syncdb(self, db, model):

if db == 'dating' or model._meta.app_label == "datingmodels":

return False # we're not using syncdb on our legacy database

else: # but all other models/databases are fine

return True

any help would be appriciated

[Tim Graham]

Please provide a minimal sample project that works on 1.6 and fails on 1.8. The simpler you can make the sample project, the easier it will be to determine if it's a bug in your application or in Django. Thanks!

[gerdkoetje]

test project proving this issue
​https://github.com/gerdkoetje/dualdbtest