It seems like a problem with the cases of created aliases: 'u0' was
expected but 'U0' is used as the table alias.
But I couldn't find any reference to u0 or U0 when debugging. In the
query object, the table name "tagging_taggeditem" is used in the
query.
For the sake of completeness, the referenced Tag model is as follows:
class Tag(models.Model):
name = models.CharField(_('name'), max_length=50, unique=True,
db_index=True)
slug = models.SlugField(unique=True)
forward = models.ForeignKey('self', blank=True, null=True)
rank = models.IntegerField(default=0)
relevance = models.IntegerField(default=0)
added = models.DateTimeField(auto_now_add=True)
Thanks...
On Feb 2, 9:46 am, omat <[email protected]> wrote:
> I just remembered that the above error occured when running on
> Postgresql 8.2. Sorry for the misinformation about SQLite.
>
> Then to give it a try with SQLite, I built a fresh database with
> syncdb on SQLite.
>
> This time, at the same point, I get a:
>
> OperationalError: no such column: tagging_taggeditem.added
>
> This is very strange, because the column 'added' is surely there.
>
> On Feb 1, 11:39 pm,omat<[email protected]> wrote:
>
> > Hi,
>
> > TaggedItem model is as follows:
>
> > class TaggedItem(models.Model):
> > tag = models.ForeignKey(Tag, verbose_name=_('tag'),
> > related_name='items')
> > added = models.DateTimeField(auto_now_add=True)
> > content_type = models.ForeignKey(ContentType, verbose_name=_
> > ('content type'))
> > object_id = models.PositiveIntegerField(_('object id'),
> > db_index=True)
> > object = generic.GenericForeignKey('content_type', 'object_id')
>
> > And I am using sqlite on Mac OS X with django revison 9781.
>
> > Thanks,oMat
>
> > On Feb 1, 1:12 am, Russell Keith-Magee <[email protected]> wrote:
>
> > > On Sun, Feb 1, 2009 at 12:44 AM,omat<[email protected]> wrote:
>
> > > > Hi all,
>
> > > > I obtain a list of tag ids by:
> > > > tag_ids = TaggedItem.objects.all().order_by('-added__max').annotate(Max
> > > > ('added'))[:10]
>
> > > > and try to use it in the following query to obtain tag objects:
> > > > Tag.objects.filter(id__in=tag_ids)
>
> > > > But i get "invalid reference to FROM-clause" error:
>
> > > > Caught an exception while rendering: invalid reference to FROM-clause
> > > > entry for table "tagging_taggeditem"
> > > > LINE 1: ...RE "tagging_tag"."id" IN (SELECT U0."tag_id", MAX
> > > > ("tagging_t...
> > > > ^
> > > > HINT: Perhaps you meant to reference the table alias "u0".
>
> > > > If I force the first query to be evaluated, using the step syntax (ie
> > > > [:10:1] instead of [:10]), then everthing works fine.
>
> > > > Seems like a bug?
>
> > > I'm not seeing this failure on SQLite, Postgres or MySQL. However, I
> > > was testing using my own test models, not your models - it's possible
> > > that the problem could be caused by the interaction of some other
> > > property of your model on the aggregate query.
>
> > > Can you provide the full definition of the TaggedItem model you are
> > > using? It would also be helpful to know the database version and
> > > operating system you are using.
>
> > > Yours,
> > > Russ Magee %-)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
