Because you have dates in the existing records and they does not have a time. You need to update existing records:
for row in db(db.table.id>0).select(): row.update_record(datetimefield=row.datetimefield) On Oct 13, 12:33 pm, Thadeus Burgess <[email protected]> wrote: > I just changed my database signup_date column from date to datetime, and > receive the following error when trying to view the rows in appadmin. > > Db is using > > Field("signup_date", "datetime", notnull=True, default=request.now), > > Of course, most of my records already included just the date. > > Traceback (most recent call last): > File "/home/thadeusb/Applications/web2py-devel/gluon/restricted.py", > line 178, in restricted > > exec ccode in environment > File > "/home/thadeusb/Applications/web2py-devel/applications/init/views/appadmin.html" > <http://192.168.1.117:8000/admin/default/edit/init/views/appadmin.html>, > line 115, in <module> > > File "/home/thadeusb/Applications/web2py-devel/gluon/sqlhtml.py", > line 942, in __init__ > > for (rc, record) in enumerate(sqlrows): > > File "/home/thadeusb/Applications/web2py-devel/gluon/sql.py", line > 3000, in __iter__ > > yield self[i] > File "/home/thadeusb/Applications/web2py-devel/gluon/sql.py", line > 2942, in __getitem__ > > str(value)[11:19].strip().split(':')[:3]] > ValueError: invalid literal for int() with base 10: '' > > Thanks for any help. > > -Thadeus --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
