commit() can only be called on the DAL instance, not on the table.... i.e. db.commit() instead of db.tablename.commit()
On Sunday, December 8, 2013 1:57:13 PM UTC+1, Ivo wrote: > > I'm trying to get the scheduler up and running but it keeps giving me > failed and then stops. > -D0 gives me: > > DEBUG:web2py.scheduler.mac.linuxmce#16946: task starting > DEBUG:web2py.scheduler.mac.linuxmce#16946: task started > DEBUG:web2py.scheduler.mac.linuxmce#16946:........recording heartbeat > (RUNNING) > DEBUG:web2py.scheduler.mac.linuxmce#16973: new task report: FAILED > DEBUG:web2py.scheduler.mac.linuxmce#16973: traceback: Traceback (most > recent call last): > File "/Applications/web2py > 2/web2py-2.8.2/web2py.app/Contents/Resources/gluon/scheduler.py", line 238, > in executor > result = dumps(_function(*args, **vars)) > File "applications/test_app/models/tasks.py", line 108, in update > db.people.commit() > File "/Applications/web2py > 2/web2py-2.8.2/web2py.app/Contents/Resources/gluon/dal.py", line 8817, in > __getitem__ > return ogetattr(self, str(key)) > AttributeError: 'Table' object has no attribute 'commit' > > Traceback (most recent call last): > File > "/Library/Frameworks/Python.framework/Versions/2.7/lib/python2.7/multiprocessing/queues.py", > > line 266, in _feed > send(obj) > PicklingError: Can't pickle <class '__restricted__.TaskReport'>: import of > module __restricted__ failed > DEBUG:web2py.scheduler.mac.linuxmce#16946: task stopped > DEBUG:web2py.scheduler.mac.linuxmce#16946: new task report: STOPPED > DEBUG:web2py.scheduler.mac.linuxmce#16946: result: None > DEBUG:web2py.scheduler.mac.linuxmce#16946: recording task report in db > (STOPPED) > INFO:web2py.scheduler.mac.linuxmce#16946:task completed (STOPPED) > > > > -used db is SQLite > -tasks.py: > > def update(): > rows=db(db.people.id == 1).select() > row=rows[0] > row.update_record(name = John) > db.people.commit() > return locals() > > anyone? > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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.
