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 -~----------~----~----~----~------~----~------~--~---
