Skip to content

Instantly share code, notes, and snippets.

@jmalinens
Created June 30, 2015 08:11
Show Gist options
  • Save jmalinens/4321303b1c6d9c222e96 to your computer and use it in GitHub Desktop.
Save jmalinens/4321303b1c6d9c222e96 to your computer and use it in GitHub Desktop.
hvad queryset update fail
Environment:
Request Method: GET
Request URL: http://127.0.0.1:8000/lv/admin/commissions/commission/change_published/?published=true&field_id=4796512&field_name=city
Django Version: 1.7.8
Python Version: 2.7.6
Installed Applications:
('modeltranslation',
'djangocms_text_ckeditor',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'djangocms_admin_style',
'django.contrib.admin',
'django.contrib.sites',
'django.contrib.sitemaps',
'django.contrib.staticfiles',
'django.contrib.messages',
'cms',
'treebeard',
'menus',
'sekizai',
'djangocms_style',
'djangocms_column',
'djangocms_file',
'djangocms_flash',
'djangocms_googlemap',
'djangocms_inherit',
'djangocms_link',
'djangocms_picture',
'djangocms_teaser',
'djangocms_video',
'reversion',
'filer',
'easy_thumbnails',
'aldryn_common',
'hvad',
'testsite',
'testsite.apps.commissions',
'translatable',
'adminsortable',
'meta',
'meta_mixin',
'djangocms_page_meta',
'inline_ordering',
'nocaptcha_recaptcha',
'smart_selects',
'import_export',
'django_select2',
'debug_toolbar')
Installed Middleware:
(u'debug_toolbar.middleware.DebugToolbarMiddleware',
'django.middleware.cache.UpdateCacheMiddleware',
'django.middleware.common.BrokenLinkEmailsMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.locale.LocaleMiddleware',
'django.middleware.doc.XViewMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
'cms.middleware.user.CurrentUserMiddleware',
'cms.middleware.page.CurrentPageMiddleware',
'cms.middleware.toolbar.ToolbarMiddleware',
'cms.middleware.language.LanguageCookieMiddleware',
'django.middleware.cache.FetchFromCacheMiddleware')
Traceback:
File "C:\xampp\htdocs\testsite\env\lib\site-packages\django\core\handlers\base.py" in get_response
111. response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\django\views\decorators\cache.py" in _wrapped_view_func
52. response = view_func(request, *args, **kwargs)
File "C:\xampp\htdocs\testsite\testsite\apps\commissions\admin.py" in changepublished_view
457. nRowsUpdated = GeonamesCity.objects.filter(id=field_id).update(published=published)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\hvad\manager.py" in update
693. count += shared_qs.update(**shared)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\django\db\models\query.py" in update
583. rows = query.get_compiler(self.db).execute_sql(CURSOR)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\django\db\models\sql\compiler.py" in execute_sql
1005. cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\django\db\models\sql\compiler.py" in execute_sql
787. cursor.execute(sql, params)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\debug_toolbar\panels\sql\tracking.py" in execute
159. return self._record(self.cursor.execute, sql, params)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\debug_toolbar\panels\sql\tracking.py" in _record
101. return method(sql, params)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\django\db\backends\utils.py" in execute
81. return super(CursorDebugWrapper, self).execute(sql, params)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\django\db\backends\utils.py" in execute
65. return self.cursor.execute(sql, params)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\django\db\utils.py" in __exit__
94. six.reraise(dj_exc_type, dj_exc_value, traceback)
File "C:\xampp\htdocs\testsite\env\lib\site-packages\django\db\backends\utils.py" in execute
65. return self.cursor.execute(sql, params)
Exception Type: ProgrammingError at /lv/admin/commissions/commission/change_published/
Exception Value: missing FROM-clause entry for table "t3"
LINE 1: ...d < U0.id))) WHERE (U0."master_id" = 4796512 AND (T3.id IS N...
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment