django tagging + multilingual doesn't work
I'm writing about my problem again, to bring your attention I've made
my long report short:
I'm using django-tagging and django-multilingual applications in my
project. Tagging worked ok until I've added multilingual application
to the
project, and now I don't know if problem is in tagging or in
multilingual.
Here's model class:
class Script(models.Model):
pub_date = models.DateTimeField()
slug = models.SlugField(max_length=120)
tags = TagField()
class Translation(multilingual.Translation):
headline = models.CharField(max_length=200)
description = models.TextField()
body = models.TextField()
class Meta:
ordering = ('-pub_date',)
Then I'm starting manage.py shell command in my project folder and
enter next few lines:
my_tag = Tag.objects.get(name='sometag')
TaggedItem.objects.get_by_model(Script, my_tag)
error appeares - OperationalError: (1054, "Unknown
column'scripts_script.id' in 'on clause'")clause'
all application are at latest svn versions.
Thanks, in advance, for your help.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---
Re: sql error (1054, "Unknown column 'scripts_script.id' in 'on clause'")
I've tried to JOIN instead of ", " in sql query and it works but only
in sql frontend. I don't know where to fix this statement in Django.
On Nov 6, 5:52 pm, sergo <[EMAIL PROTECTED]> wrote:
> 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 thishttp://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'")
>
> and here's sql query in error page:
>
> SELECT COUNT(*) FROM `scripts_script` , `tagging_taggeditem` LEFT JOIN
> `scripts_script_translation` AS `scripts_script_translation_en` ON
> ((`scripts_script_translation_en`.master_id = `scripts_script`.`id`)
> AND (`scripts_script_translation_en`.language_id = 2)) LEFT JOIN
> `scripts_script_translation` AS `scripts_script_translation_ru` ON
> ((`scripts_script_translation_ru`.master_id = `scripts_script`.`id`)
> AND (`scripts_script_translation_ru`.language_id = 1)) WHERE
> `tagging_taggeditem`.content_type_id = %s AND
> `tagging_taggeditem`.tag_id = %s AND `scripts_script`.`id` =
> `tagging_taggeditem`.object_id
>
> Thank you!
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---
sql error (1054, "Unknown column 'scripts_script.id' in 'on clause'")
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'")
and here's sql query in error page:
SELECT COUNT(*) FROM `scripts_script` , `tagging_taggeditem` LEFT JOIN
`scripts_script_translation` AS `scripts_script_translation_en` ON
((`scripts_script_translation_en`.master_id = `scripts_script`.`id`)
AND (`scripts_script_translation_en`.language_id = 2)) LEFT JOIN
`scripts_script_translation` AS `scripts_script_translation_ru` ON
((`scripts_script_translation_ru`.master_id = `scripts_script`.`id`)
AND (`scripts_script_translation_ru`.language_id = 1)) WHERE
`tagging_taggeditem`.content_type_id = %s AND
`tagging_taggeditem`.tag_id = %s AND `scripts_script`.`id` =
`tagging_taggeditem`.object_id
Thank you!
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~--~~~~--~~--~--~---
