Rahul, this is a str.split() error and it happens when there are less
pieces than str.split() expects.
An example:
>>> fullname = 'John Smith'
>>> (first_name, last_name) = fullname.split(" ")
>>> print 'first:', first_name, '- last:', last_name
John - Smith
>>> fullname = 'John'
>>> (first_name, last_name) = fullname.split(" ")
Traceback (most recent call last):
File "<pyshell#6>", line 1, in <module>
(first_name, last_name) = fullname.split(" ")
ValueError: need more than 1 value to unpack
>>>
There weren't 2 parts in fullname. That's why the error occured.
Back to your problem, the same is happening with your updated_on
field. I'd make default=request.now on it.
BTW, try organize the traceback. It helps people helping you.
--
Vinicius Assef.
On Mon, Nov 21, 2011 at 10:48 AM, Rahul <[email protected]> wrote:
> Hi All,
> Is there a solution for below traceback I posted (I am on 1.99.2,
> win7, firefox,ie9). Tried search for a solution in below thread .. no
> help ...
>
> http://groups.google.com/group/web2py/browse_thread/thread/fc4a30879f5590e/59d060e8ded6eae0
>
>
> Traceback
> 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.
> Traceback (most recent call last): File "D:\WEB2PY\web2py\gluon
> \restricted.py", line 194, in restricted exec ccode in environment
> File "D:/WEB2PY/web2py/applications/Link_IT/controllers/default.py",
> line 276, in <module> File "D:\WEB2PY\web2py\gluon\globals.py", line
> 149, in <lambda> self._caller = lambda f: f() File "D:/WEB2PY/
> web2py/applications/Link_IT/controllers/default.py", line 58, in
> index return dict(form=form, list_updates=db(db.updates).select())
> File "D:\WEB2PY\web2py\gluon\dal.py", line 5697, in select return
> self.db._adapter.select(self.query,fields,attributes) File "D:\WEB2PY
> \web2py\gluon\dal.py", line 1233, in select rows = response(sql)
> File "D:\WEB2PY\web2py\gluon\dal.py", line 1223, in response
> self.execute(sql) File "D:\WEB2PY\web2py\gluon\dal.py", line 1309, in
> execute return self.log_execute(*a, **b) File "D:\WEB2PY\web2py
> \gluon\dal.py", line 1304, in log_execute ret =
> self.cursor.execute(*a,**b) File "C:\Python27\lib\sqlite3\dbapi2.py",
> line 66, in convert_timestamp datepart, timepart = val.split("
> ")ValueError: need more than 1 value to unpack
>
> here is my controller (default.py) --------------
>
> def index():
> return dict( list_updates=db(db.updates).select())
>
> here is the view (index.html) ---------
>
> {{right_sidebar_enabled=False}}
> {{extend 'layout.html'}}
> {{=list_updates}}
>
> my model (db.py)-------------
>
> db.define_table('updates',
> Field('description', 'text'),
> Field('updated_on','date', readable=False,
> writable=False, default=now),
> Field('posted_by', readable=False, writable=False,
> length=512)
> )
>
>
> Please help .. what could be the issue.. I even cleared the db. the
> issue still persists.
>
> Regards, Rahul
>
