This error comes from appadmin. Exactly what were you doing in appadmin to generate this error (what URL was requested)?
Anthony On Tuesday, January 7, 2014 1:10:45 PM UTC-5, Akash Agrawall wrote: > > Traceback (most recent call last): > File > "/home/hornet632/webapps/joyofreading/web2py/applications/AK_M14/controllers/appadmin.py", > line 243, in select > limitby=(start, stop)) > File "/home/hornet632/webapps/joyofreading/web2py/gluon/dal.py", line > 10335, in select > return adapter.select(self.query,fields,attributes) > File "/home/hornet632/webapps/joyofreading/web2py/gluon/dal.py", line 2388, > in select > return super(SQLiteAdapter, self).select(query, fields, attributes) > File "/home/hornet632/webapps/joyofreading/web2py/gluon/dal.py", line 1831, > in select > return self._select_aux(sql,fields,attributes) > File "/home/hornet632/webapps/joyofreading/web2py/gluon/dal.py", line 1796, > in _select_aux > self.execute(sql) > File "/home/hornet632/webapps/joyofreading/web2py/gluon/dal.py", line 1916, > in execute > return self.log_execute(*a, **b) > File "/home/hornet632/webapps/joyofreading/web2py/gluon/dal.py", line 1910, > in log_execute > ret = self.cursor.execute(command, *a[1:], **b) > File "/usr/local/lib/python2.7/sqlite3/dbapi2.py", line 66, in > convert_timestamp > datepart, timepart = val.split(" ") > ValueError: need more than 1 value to unpack > > > > On Tuesday, January 7, 2014 2:11:35 AM UTC+5:30, Dave S wrote: >> >> On Monday, January 6, 2014 12:32:01 PM UTC-8, Akash Agrawall wrote: >>> >>> I am getting this error: >>> "Need more than one value to unpack" >>> >>> >> Can you tell us which line the error message is referencing? Is there a >> traceback in the ticket? >> >> /dps >> >> >> >> >>> *db.py:* >>> class IS_CATEGORYIT(object): >>> def __init__(self, error_message="Zip code not allowed"): >>> self.error_message = error >>> def __call__(self, value): >>> error = None >>> print len(value) >>> if len(value)==0: >>> error = self.error_message >>> return (value, error) >>> db.define_table('book', >>> db.Field('Name','string'), >>> db.Field('Category','string',requires=IS_CATEGORYIT), >>> db.Field('Quantity','integer'), >>> db.Field('ISBN','string',unique=True), >>> db.Field('Age_group','list:string', >>> requires=IS_IN_SET(['1-4','5-8','9-12','13-17'])), >>> >>> db.Field('entry_date','date',default=datetime.date.today(),requires=IS_DATE(format=('%d-%m-%Y'))), >>> db.Field('Description','text'), >>> db.Field('Image','upload',uploadfield='picture_file'), >>> db.Field('picture_file','blob'), >>> db.Field('Available','integer'), >>> db.Field('Author','string'), >>> db.Field('Link','string',requires=IS_EMPTY_OR(IS_URL()))) >>> >>> db.book.Description.widget= lambda field,value: >>> SQLFORM.widgets.text.widget(field,value,_style='width:400px',_rows=5) >>> db.book.Category.requires=IS_IN_SET(['ficton','non-fiction','action and >>> adventure','travel','biography','story'],multiple=True,zero=None),IS_NOT_EMPTY(error_message="cannot >>> >>> be empty") >>> db.book.Category.widget= lambda field,value: >>> SQLFORM.widgets.checkboxes.widget(field,value) >>> >>> *controller: default.py* >>> def add_book(): >>> form1=SQLFORM(db.book) >>> form1.add_button('Cancel', URL('add_book')) >>> if form1.accepts(request.vars,session): >>> response.flash="Book Inserted" >>> elif form1.errors: >>> response.flash="Errors in form" >>> return dict(form1=form1) >>> >>> *view:add_book.html* >>> {{=form1.custom.begin}} >>> <table> >>> <tr><td style="width:51%">Name <span >>> style="color:red;">*</span>:</td><td> {{=form1.custom.widget.Name >>> }}</td></tr> >>> <tr><td> Quantity <span style="color:red;">*</span>:</td><td> >>> {{=form1.custom.widget.Quantity}}</td></tr> >>> <tr><td style="width:51%">Available <span >>> style="color:red;">*</span>:</td><td> >>> {{=form1.custom.widget.Available}}</td></tr> >>> <tr><td style="width:51%">ISBN <span style="color:red;">*</span>: >>> </td><td>{{=form1.custom.widget.ISBN}}</td></tr> >>> <tr><td style="width:51%">Entry Date <span >>> style="color:red;">*</span>: >>> </td><td>{{=form1.custom.widget.entry_date}}</td></tr> >>> </table> >>> >>> <span style="color:#666666;" >Category</span><span >>> style="color:red;">*</span>: >>> <br/> >>> <span style="position:relative;left:43%;color:rgb(102, 102, >>> 102);"><label class="checkbox >>> inline">{{=form1.custom.widget.Category[0]}}</label></span> >>> <span style="position:relative;left:50%;color:rgb(102, 102, >>> 102);"><label class="checkbox >>> inline">{{=form1.custom.widget.Category[1]}}</label></span><br/> >>> <span style="position:relative;left:43%;color:rgb(102, 102, >>> 102);"><label class="checkbox >>> inline">{{=form1.custom.widget.Category[3]}}</label></span> >>> <span style="position:relative;left:50.5%;color:rgb(102, 102, >>> 102);"><label class="checkbox >>> inline">{{=form1.custom.widget.Category[4]}}</label></span><br/> >>> <span style="position:relative;left:43%;color:rgb(102, 102, >>> 102);"><label class="checkbox >>> inline">{{=form1.custom.widget.Category[5]}}</label></span> >>> <span style="position:relative;left:51%;color:rgb(102, 102, >>> 102);"><label class="checkbox >>> inline">{{=form1.custom.widget.Category[2]}}</label></span> >>> </tr> >>> </tr> >>> <table> >>> <tr><td style="width:45%">Age Group <span >>> style="color:red;">*</span>:</td> >>> <td>{{=form1.custom.widget.Age_group}}</td></tr> >>> <tr><td style="width:45%">Author:</td><td> >>> {{=form1.custom.widget.Author}}</td></tr> >>> <tr><td style="width:45%">Amazon Link:</td> >>> <td>{{=form1.custom.widget.Link}}</td></tr> >>> <tr><td style="width:45%">Description:</td><td> >>> {{=form1.custom.widget.Description}}</td></tr> >>> <tr><td style="width:45%">Image:</td><td> >>> {{=form1.custom.widget.Image}}</td></tr> >>> <tr><td >>> style="width:45%"></td><td>{{=form1.custom.submit}} {{=form1[0][11][1][1]}}</td></tr> >>> </table> >>> {{=form1.custom.end}} >>> >>> Please hava look at this..... need reply to this..... ASAP..... thanx in >>> advance >>> >>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.