This is my code for that page
def index():
schedule =
db(db.schedule.date==request.now.strftime("%Y-%m-%d")).select(orderby=~db.schedule.date)
episodes = db(db.episodes.id>0).select(orderby=~db.episodes.created_on)
categories = db(db.episode_categories.id>0).select()
trailers = db(db.trailer.id>0).select(orderby=~db.trailer.air_date)
return
dict(schedule=schedule,episodes=episodes,categories=categories,trailers=trailers)
*cheers ty :D
On Sun, Jan 15, 2012 at 6: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?
>
>
>
>
