Opened 15 years ago

Last modified 15 years ago

#9536 closed

sql error (1054, "Unknown column 'scripts_script.id' in 'on clause'") — at Version 1

Reported by: sergo Owned by: nobody
Component: Database layer (models, ORM) Version: dev
Severity: Keywords: sql tagging multilingual
Cc: Triage Stage: Unreviewed
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description (last modified by Ramiro Morales)

I'm using django-tagging and django-multilingual applications in my project. I don't know if the problem is in these packages or it is more general. Google gives this ​http://bugs.mysql.com/bug.php?id=16190 , so I thought it is more general problem.

Error page says:

Environment:

Request Method: GET
Request URL: http://127.0.0.1:8000/scripts/tag/material/
Django Version: 1.1 pre-alpha SVN-9285
Python Version: 2.5.2
Installed Applications:
['django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.sites',
 'django.contrib.admin',
 'django.contrib.markup',
 'sergepogosyan.mytags',
 'sergepogosyan.articles',
 'sergepogosyan.scripts',
 'sergepogosyan.about',
 'sergepogosyan.gallery',
 'django.contrib.comments',
 'tagging',
 'multilingual',
 'multilingual.flatpages',
 'localeurl']
Installed Middleware:
('django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.locale.LocaleMiddleware',
 'localeurl.middleware.LocaleURLMiddleware',
 'multilingual.middleware.DefaultLanguageMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.middleware.doc.XViewMiddleware',
 'multilingual.flatpages.middleware.FlatpageFallbackMiddleware')


Traceback:
File "C:\Python25\lib\site-packages\django\core\handlers\base.py" in get_response
  86.                 response = callback(request, *callback_args, **callback_kwargs)
File "C:\Python25\lib\site-packages\tagging\views.py" in tagged_object_list
  52.     return object_list(request, queryset, **kwargs)
File "C:\Python25\lib\site-packages\django\views\generic\list_detail.py" in object_list
  60.             page_obj = paginator.page(page_number)
File "C:\Python25\lib\site-packages\django\core\paginator.py" in page
  37.         number = self.validate_number(number)
File "C:\Python25\lib\site-packages\django\core\paginator.py" in validate_number
  28.         if number > self.num_pages:
File "C:\Python25\lib\site-packages\django\core\paginator.py" in _get_num_pages
  60.             if self.count == 0 and not self.allow_empty_first_page:
File "C:\Python25\lib\site-packages\django\core\paginator.py" in _get_count
  48.                 self._count = self.object_list.count()
File "C:\Python25\lib\site-packages\django\db\models\query.py" in count
  296.         return self.query.get_count()
File "C:\Python25\lib\site-packages\django\db\models\sql\query.py" in get_count
  237.         data = obj.execute_sql(SINGLE)
File "C:\Python25\lib\site-packages\django\db\models\sql\query.py" in execute_sql
  1734.         cursor.execute(sql, params)
File "C:\Python25\lib\site-packages\django\db\backends\util.py" in execute
  19.             return self.cursor.execute(sql, params)
File "C:\Python25\lib\site-packages\django\db\backends\mysql\base.py" in execute
  83.             return self.cursor.execute(query, args)
File "C:\Python25\lib\site-packages\MySQLdb\cursors.py" in execute
  166.             self.errorhandler(self, exc, value)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py" in defaulterrorhandler
  35.     raise errorclass, errorvalue

Exception Type: OperationalError at /scripts/tag/material/
Exception Value: (1054, "Unknown column 'scripts_script.id' in 'on clause'")

Change History (1)

comment:1 by Ramiro Morales, 15 years ago

Description: modified (diff)

(reformatted description)

Note: See TracTickets for help on using tickets.
Back to Top