I'm having the same problem, but I'm struggling with saving the database. 
The corrupted field is a 'date' type.

On Wednesday, May 27, 2009 1:15:36 AM UTC-5, ニコノコ wrote:
>
> I found the source of my problem. I have records with null values. And 
> since sqlite don't enforce data typing, I assume that it simply 
> "guess" the data type, based on whatever is found in the first(???) 
> record. 
>
> On this assumption, I assigned datetime values in the empty datetime 
> fields and tested again. It's now working. 
>
> On May 26, 10:19 pm, Nik <nikolai...@gmail.com> 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)

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to