#4954: problems with sqlite3
-----------------------+----------------------------------------------------
Reporter: anonymous | Owner: adrian
Status: new | Component: Database wrapper
Version: SVN | Keywords: sqlite3 timefield
Stage: Unreviewed | Has_patch: 0
-----------------------+----------------------------------------------------
My model (excerpt):
{{{
class TimeClock(models.Model):
user = models.ForeignKey(User)
day = models.DateField()
start_time = models.TimeField()
end_time = models.TimeField(blank=True, null=True)
pause = models.IntegerField(help_text="In Minutes", blank=True,
default=0)
}}}
The error:
{{{
Traceback (most recent call last):
File "/usr/lib/python2.5/site-packages/django/core/handlers/base.py" in
get_response
77. response = callback(request, *callback_args, **callback_kwargs)
File "/usr/lib/python2.5/site-
packages/django/contrib/admin/views/decorators.py" in _checklogin
55. return view_func(request, *args, **kwargs)
File "/usr/lib/python2.5/site-packages/django/views/decorators/cache.py"
in _wrapped_view_func
39. response = view_func(request, *args, **kwargs)
File "/usr/lib/python2.5/site-packages/django/contrib/admin/views/main.py"
in change_list
772. cl = ChangeList(request, model)
File "/usr/lib/python2.5/site-packages/django/contrib/admin/views/main.py"
in __init__
578. self.get_results(request)
File "/usr/lib/python2.5/site-packages/django/contrib/admin/views/main.py"
in get_results
636. result_list = list(self.query_set)
File "/usr/lib/python2.5/site-packages/django/db/models/query.py" in
__iter__
113. return iter(self._get_data())
File "/usr/lib/python2.5/site-packages/django/db/models/query.py" in
_get_data
480. self._result_cache = list(self.iterator())
File "/usr/lib/python2.5/site-packages/django/db/models/query.py" in
iterator
188. cursor.execute("SELECT " + (self._distinct and "DISTINCT " or "") +
",".join(select) + sql, params)
File "/usr/lib/python2.5/site-packages/django/db/backends/util.py" in
execute
19. return self.cursor.execute(sql, params)
File "/usr/lib/python2.5/site-packages/django/db/backends/sqlite3/base.py"
in execute
94. return Database.Cursor.execute(self, query, params)
File "/usr/lib/python2.5/site-packages/django/db/backends/util.py" in
typecast_time
68. return datetime.time(int(hour), int(minutes), int(seconds),
int(float('.'+microseconds) * 1000000))
ValueError at /admin/timeclock/timeclock/
invalid literal for int() with base 10: '2007-07-22 21'
}}}
It occurs viewing the admin list view, after inserting an object like
this:
{{{ new = TimeClock(user=request.user,day=now,start_time=now ) }}}
where now = datetime.datetime.now()
In sqlite3 it looks like this:
{{{
sqlite> select * from timeclock_timeclock;
1|1|2007-07-22|2007-07-22 21:48:17.782227||0
}}}
--
Ticket URL: <http://code.djangoproject.com/ticket/4954>
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
-~----------~----~----~----~------~----~------~--~---
