Django ValueError: Can't do subqueries with queries on different DBs

[InTheEnd]

Problem is here: http://stackoverflow.com/q/31912252/5209805

Traceback:

Environment:

Request Method: GET
Request URL: http://kapremontomsk.ru/houses/test/

Django Version: 1.8.3
Python Version: 2.7.6
Installed Applications:
('django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'django.contrib.sitemaps',
'project',
'news',
'competition',
'documentation',
'houses',
'django_bootstrap_breadcrumbs',
'bootstrapform',
'tastypie',
'sorl.thumbnail',
'redactor',
'djangular',
'cacheops',
'django_cleanup')
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.auth.middleware.SessionAuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware')

Traceback:
File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response

1.                 response = wrapped_callback(request, _callback_args, *_callback_kwargs)
   

   File "./houses/views.py" in districtreport

2. if kao_ro_accounts:
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/query.py" in nonzero

3.     return type(self).**bool**(self)
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/query.py" in bool

4.     self._fetch_all()
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/query.py" in _fetch_all

5.         self._result_cache = list(self.iterator())
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/cacheops/query.py" in iterator

6.         cache_key = self._cache_key()
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/cacheops/query.py" in _cache_key

7.         md.update(smart_str(self.query))
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/utils/encoding.py" in smart_bytes

8. return force_bytes(s, encoding, strings_only, errors)
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/utils/encoding.py" in force_bytes

9.             return bytes(s)
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/sql/query.py" in str

10.     sql, params = self.sql_with_params()
    

    File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/sql/query.py" in sql_with_params

11.     return self.get_compiler(DEFAULT_DB_ALIAS).as_sql()
    

    File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in as_sql

12.         where, w_params = self.compile(self.query.where)
    

    File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in compile

13.         sql, params = node.as_sql(self, self.connection)
    

    File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/sql/where.py" in as_sql

14.                 sql, params = compiler.compile(child)
    

    File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py" in compile

15.         sql, params = node.as_sql(self, self.connection)
    

    File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/sql/where.py" in as_sql

16.             raise ValueError("Can't do subqueries with queries on different DBs.")
    

Exception Type: ValueError at /houses/test/
Exception Value: Can't do subqueries with queries on different DBs.

[Suor]

Fixed, thanks for reporting this.

[InTheEnd]

Thx, this error is gone, but now other problem:

Environment:

Request Method: GET
Request URL: http://kapremontomsk.ru/houses/test/

Django Version: 1.8.3
Python Version: 2.7.6
Installed Applications:
('django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'django.contrib.sitemaps',
'project',
'news',
'competition',
'documentation',
'houses',
'django_bootstrap_breadcrumbs',
'bootstrapform',
'tastypie',
'sorl.thumbnail',
'redactor',
'djangular',
'cacheops',
'django_cleanup')
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.auth.middleware.SessionAuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware')

Traceback:
File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/core/handlers/base.py" in get_response

1.                 response = wrapped_callback(request, _callback_args, *_callback_kwargs)
   

   File "./houses/views.py" in districtreport

2. if kao_ro_accounts:
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/query.py" in nonzero

3.     return type(self).**bool**(self)
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/query.py" in bool

4.     self._fetch_all()
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/django/db/models/query.py" in _fetch_all

5.         self._result_cache = list(self.iterator())
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/cacheops/query.py" in iterator

6.         cache_key = self._cache_key()
   

   File "/home/intheend/kapremontomsk.ru/kapremontomsk_env/local/lib/python2.7/site-packages/cacheops/query.py" in _cache_key

7.         md.update(smart_str(sql % params))
   

Exception Type: UnicodeDecodeError at /houses/test/
Exception Value: 'ascii' codec can't decode byte 0xd0 in position 0: ordinal not in range(128)

[Suor]

This means you are passing some non-ascii text as non-unicode somewhere into queryset, like:

SomeModel.objects.filter(title='фыва')

Note no u before string literal containing non-ascii.

[InTheEnd]

Thank you, my bad.