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.
