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 2918 """ValueError: too many values to unpack"" when doing the tutorial." tklopp@… nobody "hi, I did my first django installation on a debian/unstable. I installed sqlite3 and pysqlite2 from debian packages. I installed django-0.95 like shown on http://www.djangoproject.com/documentation/install/. Here's what I entered and what happened (you can see the error at the bottom): {{{ ... File settings.py saved tklopp@muschel:~/Projekte/django/mysite$ python manage.py sql polls BEGIN; CREATE TABLE ""polls_poll"" ( ""id"" integer NOT NULL PRIMARY KEY, ""question"" varchar(200) NOT NULL, ""pub_date"" datetime NOT NULL ); CREATE TABLE ""polls_choice"" ( ""id"" integer NOT NULL PRIMARY KEY, ""poll_id"" integer NOT NULL REFERENCES ""polls_poll"" (""id""), ""choice"" varchar(200) NOT NULL, ""votes"" integer NOT NULL ); COMMIT; tklopp@muschel:~/Projekte/django/mysite$ python manage.py validate polls 0 errors found. tklopp@muschel:~/Projekte/django/mysite$ python manage.py sqlinitialdata polls BEGIN; COMMIT; tklopp@muschel:~/Projekte/django/mysite$ python manage.py syncdb Creating table polls_poll Creating table polls_choice Adding permission 'poll | Can add poll' Adding permission 'poll | Can change poll' Adding permission 'poll | Can delete poll' Adding permission 'choice | Can add choice' Adding permission 'choice | Can change choice' Adding permission 'choice | Can delete choice' tklopp@muschel:~/Projekte/django/mysite$ python manage.py shell Python 2.4.4c1 (#2, Oct 12 2006, 21:41:47) [GCC 4.1.2 20061007 (prerelease) (Debian 4.1.1-16)] on linux2 Type ""help"", ""copyright"", ""credits"" or ""license"" for more information. (InteractiveConsole) >>> from mysite.polls.models import Poll, Choice >>> Poll.Objects.all() Traceback (most recent call last): File """", line 1, in ? AttributeError: type object 'Poll' has no attribute 'Objects' >>> Poll.objects.all() [] >>> from datetime import datetime >>> p = Poll(question=""What's up?"", pub_date=datetime.now()) >>> p.save() >>> p.id() Traceback (most recent call last): File """", line 1, in ? TypeError: 'int' object is not callable >>> p.id 1 >>> p.question ""What's up?"" >>> p.pub_date datetime.datetime(2006, 10, 16, 21, 3, 5, 31007) >>> p.pub_date = (2006,10,15,21,3,5,31007) >>> p.save > >>> p.save)= File """", line 1 p.save)= ^ SyntaxError: invalid syntax >>> p.save() >>> p.pub_date (2006, 10, 15, 21, 3, 5, 31007) >>> Poll.objects.all() Traceback (most recent call last): File """", line 1, in ? File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/models/query.py"", line 97, in __repr__ return repr(self._get_data()) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/models/query.py"", line 430, in _get_data self._result_cache = list(self.iterator()) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/models/query.py"", line 172, in iterator cursor.execute(""SELECT "" + (self._distinct and ""DISTINCT "" or """") + "","".join(select) + sql, params) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/backends/util.py"", line 12, in execute return self.cursor.execute(sql, params) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/backends/sqlite3/base.py"", line 77, in execute return Database.Cursor.execute(self, query, params) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/backends/util.py"", line 62, in typecast_timestamp d, t = s.split() ValueError: too many values to unpack >>> Poll.objects.all() Traceback (most recent call last): File """", line 1, in ? File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/models/query.py"", line 97, in __repr__ return repr(self._get_data()) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/models/query.py"", line 430, in _get_data self._result_cache = list(self.iterator()) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/models/query.py"", line 172, in iterator cursor.execute(""SELECT "" + (self._distinct and ""DISTINCT "" or """") + "","".join(select) + sql, params) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/backends/util.py"", line 12, in execute return self.cursor.execute(sql, params) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/backends/sqlite3/base.py"", line 77, in execute return Database.Cursor.execute(self, query, params) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/backends/util.py"", line 62, in typecast_timestamp d, t = s.split() ValueError: too many values to unpack >>> >>> >>> >>> >>> Poll.objects.all() Traceback (most recent call last): File """", line 1, in ? File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/models/query.py"", line 97, in __repr__ return repr(self._get_data()) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/models/query.py"", line 430, in _get_data self._result_cache = list(self.iterator()) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/models/query.py"", line 172, in iterator cursor.execute(""SELECT "" + (self._distinct and ""DISTINCT "" or """") + "","".join(select) + sql, params) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/backends/util.py"", line 12, in execute return self.cursor.execute(sql, params) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/backends/sqlite3/base.py"", line 77, in execute return Database.Cursor.execute(self, query, params) File ""/usr/lib/python2.4/site-packages/Django-0.95-py2.4.egg/django/db/backends/util.py"", line 62, in typecast_timestamp d, t = s.split() ValueError: too many values to unpack >>> quit 'Use Ctrl-D (i.e. EOF) to exit.' >>> tklopp@muschel:~/Projekte/django/mysite$ ####################################################### Next I inserted a line ""print s"" before line 62. The output was: >>> Poll.objects.all() (2006, 10, 15, 21, 3, 5, 31007) Traceback (most recent call last): ... }}} " defect closed Database layer (models, ORM) blocker fixed Accepted 0 0 0 0 0 0