sql error

[GoogleCodeExporter]

I've used tagging application in my personal site's blog and everything was
ok until I've add django-multilingual module to it. Now, when you choose
some tag on script's list page  this error message appears:

OperationalError(1054, "Unknown column 'scripts_script.id' in 'on clause'")

also there is some sql code in error page, may be it helps to find a error:

query   
'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 = 14 AND `tagging_taggeditem`.tag_id =
6 AND `scripts_script`.`id` = `tagging_taggeditem`.object_id'

Tags in model are not translatable, everything is simple.

I'm a newbie and I don't know if the problem is in django-multilingual or
django-tagging, so I started from here since this community seems more active.
Does anyone knows how to cope with it?

Original issue reported on code.google.com by sergo.po...@gmail.com on 6 Nov 2008 at 12:29

[GoogleCodeExporter]

I'm using recent versions of tagging and multilingual, and on of the last 
version of
Django, not 0.9x.

Original comment by sergo.po...@gmail.com on 6 Nov 2008 at 12:31

[GoogleCodeExporter]

I've been thinking that it's a multilingual's problem but have fixed it in 
django
code: here's closed ticked at djangoproject - 
http://code.djangoproject.com/ticket/9536

This workaround works for me, and this issue may be closed.

Original comment by sergo.po...@gmail.com on 12 Nov 2008 at 11:58

[GoogleCodeExporter]

Original comment by bros...@gmail.com on 23 Aug 2009 at 5:02

• Changed state: Invalid