Ahh. You are absolutely right. Looking at the source code of the other process, it was creating datetime in the following format: "%Y-%m-%d %H:%M:%S"
Thank you. On May 27, 12:26 am, mdipierro <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
