I think your problem is that you somehow have corrupted data in database, i.e. you stored a date in a field which you later changed to int and web2py cannot take it out any more.
On Jan 15, 8:02 pm, Andrew Evans <cheer10s.rusty...@gmail.com> wrote: > Hello I just updated web2py and after restarting uwsgi I get an error on my > site > > ValueError: invalid literal for int() with base 10: '05 04:36:30' > > Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > > Traceback (most recent call last): > File "/opt/web2py/gluon/restricted.py", line 204, in restricted > exec ccode in environment > File "/opt/web2py/applications/pstv/controllers/default.py" > <https://85.25.149.220/admin/edit/pstv/controllers/default.py>, line > 105, in <module> > File "/opt/web2py/gluon/globals.py", line 172, in <lambda> > self._caller = lambda f: f() > File "/opt/web2py/applications/pstv/controllers/default.py" > <https://85.25.149.220/admin/edit/pstv/controllers/default.py>, line > 23, in index > trailers = db(db.trailer.id>0).select(orderby=~db.trailer.air_date) > File "/opt/web2py/gluon/dal.py", line 6333, in select > return self.db._adapter.select(self.query,fields,attributes) > File "/opt/web2py/gluon/dal.py", line 1282, in select > rows = response(sql) > File "/opt/web2py/gluon/dal.py", line 1272, in response > self.execute(sql) > File "/opt/web2py/gluon/dal.py", line 1359, in execute > return self.log_execute(*a, **b) > File "/opt/web2py/gluon/dal.py", line 1353, in log_execute > ret = self.cursor.execute(*a, **b) > File "/usr/lib/python2.6/sqlite3/dbapi2.py", line 63, in convert_date > return datetime.date(*map(int, val.split("-"))) > ValueError: invalid literal for int() with base 10: '05 04:36:30' > > Any ideas?