Opened 16 years ago
Last modified 16 years ago
#9536 closed
sql error (1054, "Unknown column 'scripts_script.id' in 'on clause'") — at Initial Version
| 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
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
- response = callback(request, *callback_args, callback_kwargs)
File "C:\Python25\lib\site-packages\tagging\views.py" in tagged_object_list
- return object_list(request, queryset, kwargs)
File "C:\Python25\lib\site-packages\django\views\generic\list_detail.py" in object_list
- page_obj = paginator.page(page_number)
File "C:\Python25\lib\site-packages\django\core\paginator.py" in page
- number = self.validate_number(number)
File "C:\Python25\lib\site-packages\django\core\paginator.py" in validate_number
- if number > self.num_pages:
File "C:\Python25\lib\site-packages\django\core\paginator.py" in _get_num_pages
- if self.count == 0 and not self.allow_empty_first_page:
File "C:\Python25\lib\site-packages\django\core\paginator.py" in _get_count
- self._count = self.object_list.count()
File "C:\Python25\lib\site-packages\django\db\models\query.py" in count
- return self.query.get_count()
File "C:\Python25\lib\site-packages\django\db\models\sql\query.py" in get_count
- data = obj.execute_sql(SINGLE)
File "C:\Python25\lib\site-packages\django\db\models\sql\query.py" in execute_sql
- cursor.execute(sql, params)
File "C:\Python25\lib\site-packages\django\db\backends\util.py" in execute
- return self.cursor.execute(sql, params)
File "C:\Python25\lib\site-packages\django\db\backends\mysql\base.py" in execute
- return self.cursor.execute(query, args)
File "C:\Python25\lib\site-packages\MySQLdb\cursors.py" in execute
- self.errorhandler(self, exc, value)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py" in defaulterrorhandler
- raise errorclass, errorvalue
Exception Type: OperationalError at /scripts/tag/material/
Exception Value: (1054, "Unknown column 'scripts_script.id' in 'on clause'")