That is what I mean by corrupted. The datetime is not stored in the proper ISO format by the other process.
Massimo On May 26, 9:49 am, NikG <[email protected]> wrote: > I'm pretty sure they're not corrupted since I can still access the > database just fine. The database, by the way, is updated by another > process not by my w2p application. > > I tried to reload the data as you suggested but I still get the same > error. > > On May 26, 10:36 pm, mdipierro <[email protected]> wrote: > > > There is corrupted data in the db. This can happen if you changed the > > type of a 'date/datetime' field in sqlite. It can be reparied but I > > need to know what you did. It may be easier to dump the db to csv, > > erase it and reload it. > > > Massimo > > > On May 26, 9:19 am, Nik <[email protected]> wrote: > > > > Traceback (most recent call last): > > > File "/home/ern/web2py/gluon/restricted.py", line 107, in restricted > > > exec ccode in environment > > > File "/home/ern/web2py/applications/smb/views/appadmin.html", line > > > 122, in <module> > > > File "/home/ern/web2py/gluon/sqlhtml.py", line 623, in __init__ > > > for (rc, record) in enumerate(sqlrows): > > > File "/home/ern/web2py/gluon/sql.py", line 2196, in __iter__ > > > yield self[i] > > > File "/home/ern/web2py/gluon/sql.py", line 2151, in __getitem__ > > > str(value)[:10].strip().split('-')] > > > ValueError: invalid literal for int() with base 10: '' > > > > I was trying to go to database administration of db2 when I got this > > > error. The table is defined as follows: > > > > db2.define_table('msg_log', > > > SQLField('type', 'string'), > > > SQLField('smsc', 'string'), > > > SQLField('sent', 'datetime'), > > > SQLField('received', 'datetime'), > > > SQLField('sender', 'string'), > > > SQLField('receiver', 'string'), > > > SQLField('msgid', 'string'), migrate=False) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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 -~----------~----~----~----~------~----~------~--~---
