I think you have row(s) with corrupted date_of_birth data. DAL fails while reading it
On Mar 30, 2013 7:59 AM, <[email protected]> wrote: This error occurs when I try to insert a table into db but the page says new record inserted. Traceback (most recent call last): File "C:\Users\manish\Documents\iiit\semester 2\itws 2\web2py_win\web2py\applications\project\controllers/appadmin.py", line 227, in select File "gluon/dal.py", line 8905, in select File "gluon/dal.py", line 2146, in select File "gluon/dal.py", line 1631, in select File "gluon/dal.py", line 1596, in _select_aux File "gluon/dal.py", line 1709, in execute File "gluon/dal.py", line 1703, in log_execute File "sqlite3\dbapi2.pyc", line 66, in convert_timestamp ValueError: need more than 1 value to unpack And this is my table db.define_table('person', db.Field('name','string',requires=IS_NOT_EMPTY()), db.Field('date_of_birth','date',requires=IS_NOT_EMPTY()), db.Field('age','integer',requires=IS_NOT_EMPTY()), db.Field('gender','string',requires=IS_IN_SET(['male','female'])), db.Field('mail_address','string',requires=IS_EMAIL()), db.Field('field_of_expertise','string'), db.Field('career_objective','text'), db.Field('webpage','string',requires=IS_NULL_OR(IS_URL())), db.Field('contact_number1', 'string',requires=IS_NOT_EMPTY()), db.Field('contact_number2', 'string'), db.Field('current_location','text'), db.Field('interests','text'), db.Field('skills','text'), db.Field('image','upload'), db.Field('resume','upload',requires = IS_NULL_OR(IS_UPLOAD_FILENAME(extension='pdf')),comment='upload in PDF format')) -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out. -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
