#8416: Using Sqlite as database backend causes list_filter and date_hierarchy misbehave in Admin pages -----------------------------+---------------------------------------------- Reporter: amiroff | Owner: nobody Status: new | Milestone: 1.0 Component: django-admin.py | Version: SVN Keywords: | Stage: Unreviewed Has_patch: 0 | -----------------------------+---------------------------------------------- list_filter and date_hierarchy in Admin do not work properly when using Sqlite as a db backend and filtering by DateField / DateTimeField field types.
To see the bug in action: 1. Create a Django project and an app 2 Set sqlite as db backend 3. Create a test model with DateTimeField 4. Sync the database 5. Add some entries. 6. Observe how clicking "Today" or "This month" does not reveal the entries that were just created. 7. Also, date_hierarchy behaves wierd too, displaying Current month's name and returning no results when clicked. I came across this bug while following the official tutorial at http://www.djangoproject.com/documentation/tutorial01/ Switching to Mysql as a db backend solves the problem. Software: Using latest (1.0-beta_1-SVN-8437) SVN checkout Python 2.5.2 Sqlite bundled with Python 2.5.2 Windows XP Pro SP2 -- Ticket URL: <http://code.djangoproject.com/ticket/8416> Django Code <http://code.djangoproject.com/> The web framework for perfectionists with deadlines --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django updates" 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-updates?hl=en -~----------~----~----~----~------~----~------~--~---
