yes i traced back to some incorrect datatime field. funny things is it works under 1.56.4. i actually only import from the cvs via appadmin.
thanks On Mar 6, 9:35 pm, mdipierro <[email protected]> wrote: > You have corrupted data in database. My guess you are usingsqliteand > 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 on1.57but 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 -~----------~----~----~----~------~----~------~--~---
