You have corrupted data in database. My guess you are using sqlite and
you converted a non 'datetime' field in a 'datetime' field but the
column contained previous data. 'sqlite' is stupid and does the
migration without checking for the actual data type.
You need to reset the values in that column with db(...).update(...)

Massimo

On Mar 6, 2:28 am, vince <[email protected]> wrote:
> i got this error on 1.57 but not 1.56.4
>
> it's just a simple select to cresult before the for row in cresult
>
> Traceback (most recent call last):
>   File "/private/var/www/web2py/gluon/restricted.py", line 98, in
> restricted
>     exec ccode in environment
>   File "/private/var/www/web2py/applications/cychurch/controllers/
> donations.py", line 934, in <module>
>   File "/private/var/www/web2py/gluon/globals.py", line 75, in
> <lambda>
>     self._caller = lambda f: f()
>   File "/private/var/www/web2py/applications/cychurch/controllers/
> donations.py", line 219, in coderesult
>     for row in cresult:
>   File "/private/var/www/web2py/gluon/sql.py", line 2115, in __iter__
>     yield self[i]
>   File "/private/var/www/web2py/gluon/sql.py", line 2086, in
> __getitem__
>     str(value)[:10].strip().split('-')]
> ValueError: invalid literal for int() with base 10: ''
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to