yes it's on sqlite but the data are from the csv import from appadmin. funny thing is it works under 1.56.4. it seens ti only happens when the db with over certain amount of row like over 1000 let me try again and see if i can sort it out
vince On Mar 6, 9:35 pm, mdipierro <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
