Hello !
I am getting a strange query from the archive_index generic view :
SELECT DISTINCT CAST(DATE_FORMAT(`news_news`.`publication_date`,
'%Y-01-01 00:00:00') AS DATETIME) FROM `news_news` WHERE
`news_news`.`publication_date` IS NULL ORDER BY 1 ASC
I dont understand where the "IS NULL" comes from. As all the news in
my database have a publication_date, this query returns nothing and no
news is displayed.
Any help appreciated !
Here is my ulrs.py :
urlpatterns = patterns('',
url(r'^$',
date_based.archive_index,
{
'queryset' : News.objects.all(),
'date_field' : 'publication_date',
'allow_future' : True,
},
),
)
and the model :
class News(models.Model):
""" News model """
title = models.CharField(max_length=100, unique=True)
slug = models.SlugField(prepopulate_from=("title",),
unique_for_date='publication_date')
author = models.ForeignKey(User)
creation_date = models.DateField(auto_now_add=True)
modification_date = models.DateField(auto_now=True)
publication_date = models.DateField(blank=True, null=True)
ask_promotion = models.BooleanField(default=False,
help_text=_("Ask for this news
to be promoted on the front page. For example, an artist might be able
to write news for its next gig, and have the news appear on the
artist's page, but not on the front page. The artist can ask a
moderator to promote the news on the front page by checking this
field."))
promoted = models.BooleanField(default=False,
help_text=_("If this field is
checked, the news will appear on the front page."))
trock_news = models.BooleanField(default=False,
help_text=_("Check this field if
you want this news to be published in the next TrocK news."))
text = models.TextField(blank=True)
class Meta:
"""
Defines meta data on the model.
"""
verbose_name_plural = _('news')
ordering = ['-publication_date', 'title',]
permissions = (
("export_trock_news", _("Can export the list of news
selected for the next TrocK news")),
)
class Admin:
"""
This model is available in the admin interface.
"""
list_display = ('title', 'publication_date',)
def __unicode__(self):
return '%s' % self.title
@permalink
def get_absolute_url(self):
"""
The URL to this news in the date based view.
"""
return ('news_detail', (), {
'year' : self.publication_date.year,
'month' : self.publication_date.month,
'day' : self.publication_date.day,
'slug' : self.slug,
})
@permalink
def get_absolute_url_by_id(self):
"""
The URL to this news in the ID based view.
"""
return ('news_detail_by_id', (), {
'object_id' : self.pk,
})
--
Jabber : [EMAIL PROTECTED]
Skype : Guillaume.Lederrey
Projects :
* http://rwanda.ledcom.ch/
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
