id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
1062	[patch] typecast on date fails	cmaloney@…	Adrian Holovaty	"When using date based generic views with SQLite, the following error occurrs:

Exception Type:  	ValueError
Exception Value: 	need more than 1 value to unpack
Exception Location: 	/usr/local/lib/python2.4/site-packages/django/core/db/typecasts.py in typecast_timestamp, line 22

It seems the typecast for date assumes date+time, whereas the DateField() comes back with only a date.
I have worked around this problem using the following patch:

--- typecasts.py        2005-10-21 11:11:48.000000000 +1000
+++ /usr/lib/python2.4/site-packages/Django-0.90-py2.4.egg/django/core/db/typecasts.py  2005-12-14 12:57:53.000000000 +1100
@@ -20,7 +20,11 @@
     # ""2005-07-29 15:48:00.590358-05""
     # ""2005-07-29 09:56:00-05""
     if not s: return None
+    try:
     d, t = s.split()
+    except ValueError:
+       d = s
+       t = '00:00:01'
     # Extract timezone information, if it exists. Currently we just throw
     # it away, but in the future we may make use of it.
     if '-' in t:
"	defect	closed	Database layer (models, ORM)	dev	normal	fixed		nesh@…	Unreviewed	1	0	0	0	0	0