You have an older version of the scheduler (and web2py). Your scheduler tables have a field called "output" This field was renamed "run_output". This is because some database engines consider "output" a reserved keyword.
Massimo On Friday, 1 February 2013 22:10:48 UTC-6, Morgan Hein wrote: > > Howdy! > > I have been following the video tutorial to create a schedule task. > > Inside the bottom of the task to be run I have: > > def main(): > o = MarketReader() > o.run() > > from gluon.scheduler import Scheduler > Scheduler(db,dict(update_market=main)) > > > When I browse back to the database management, I receive the following > error: > > TICKET ID > > 127.0.0.1.2013-02-01.19-58-07.6e66c0a0-a0fa-49e0-b6b6-70ddb741fbeb > <type 'exceptions.SyntaxError'> invalid table/column name "output" is a > "ALL" reserved SQL keywordVERSIONweb2py™(2, 3, 2, datetime.datetime(2012, > 12, 17, 15, 3, 30), 'stable')PythonPython 2.7.3: /usr/bin/python > > Traceback (most recent call last): > File "/home/johnnyfive/Downloads/web2py/gluon/restricted.py", line 212, in > restricted > exec ccode in environment > File > "/home/johnnyfive/Downloads/web2py/applications/EveMarket/models/tasks.py" > <http://127.0.0.1:8000/admin/default/edit/EveMarket/models/tasks.py>, line > 101, in <module> > Scheduler(db,dict(update_market=main)) > File "/home/johnnyfive/Downloads/web2py/gluon/scheduler.py", line 449, in > __init__ > self.define_tables(db, migrate=migrate) > File "/home/johnnyfive/Downloads/web2py/gluon/scheduler.py", line 513, in > define_tables > migrate=migrate) > File "/home/johnnyfive/Downloads/web2py/gluon/dal.py", line 7186, in > define_table > table = self.lazy_define_table(tablename,*fields,**args) > File "/home/johnnyfive/Downloads/web2py/gluon/dal.py", line 7203, in > lazy_define_table > table = table_class(self, tablename, *fields, **args) > File "/home/johnnyfive/Downloads/web2py/gluon/dal.py", line 7609, in > __init__ > db.check_reserved_keyword(field_name) > File "/home/johnnyfive/Downloads/web2py/gluon/dal.py", line 6930, in > check_reserved_keyword > 'invalid table/column name "%s" is a "%s" reserved SQL keyword' % (name, > backend.upper())) > SyntaxError: invalid table/column name "output" is a "ALL" reserved SQL > keyword > > > Variablesbackend'all'name'output'backend.upper<built-in method upper of > str object> > > Any ideas? I'm feeling like the task scheduler is trying to create a > database column with the name of "output"? > > Thanks! > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
