Hello, I tried out Ivan's tags app (http://softwaremaniacs.org/soft/tags/en/) and got the following error at different fairly unrelated tasks (edit object, render object in {{form.tags}}, etc).
Error: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) ORDER BY `tags_tag`.`norm_value` ASC, `tags_tag`.`value` ASC' at line 1") Local Variables: Select ['`tags_tag`.`id`', '`tags_tag`.`value`', '`tags_tag`.`norm_value`'] sql ' FROM `tags_tag` WHERE (`tags_tag`.`id` IN ()) ORDER BY `tags_tag`.`norm_value` ASC, `tags_tag`.`value` ASC' This is the culprit: tags/fields.py 48: ids = [id for id in data if type(id) == int] 49: strs = [id for id in data if type(id) != int] 50: initial_tags = list(self.model.objects.filter(id__in=ids)) If ids is blank, the sql is 'IN ()' which is illegal in MySQL (5.0.24a). The easy fix is something along the lines of: if ids: initial_tags = list(self.model.objects.filter(id__in=ids)) else: initial_tags = [] The reason I'm posting this on django-users instead of just reporting the bug to Ivan directly, is because I'm curious whether this is "correct" behavior. If 'IN ()' is legal in postgres (could someone verify one way or the other?) than maybe this should be ticketed as a django-mysql bug and fixed accordingly? I'm not sure one way or the other, so just looking for some input. Norbert PS. Thanks Ivan for the app! :-) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
