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

