nope, it doesn't, but auth.user_id defaults to None if there is no logged-in user. Not sure what happened without having the complete app code, however the scheduler tables are not meant to be altered, e.g. with common_fields, so it definitely should have been those to make the scheduler not behaving correctly.
On Saturday, January 11, 2014 1:24:09 AM UTC+1, User wrote: > > Ok that appears to have been the problem. Getting rid of > db._common_fields.append(standard_fields) fixed it. Didn't hone in on the > exact problem but maybe it's because I had not null on created_by, > modified_by fields which defaulted to auth.user_id. Does a scheduled task > even have a concept of a logged in user? > > On Friday, January 10, 2014 7:07:32 PM UTC-5, User wrote: >> >> I created a bare bones app and the scheduler seems to work without >> error. Not really sure what's happening with the problem app but if I had >> to guess I'm thinking it might be related to using >> >> db._common_fields.append(standard_fields) >> >> where standard_fields is a table with fields such as date_created, >> created_by, modified_by etc. which in turn has defaults like >> auth.user_id. Unexpected by me, these got appended to the scheduler >> tables. Maybe there is some problematic interaction with this. >> >> I'm going to try explicitly adding standard_fields to my app tables >> rather than using db._common_fields.append to see if that fixes it. >> >> >> On Friday, January 10, 2014 10:53:22 AM UTC-5, User wrote: >> >>> postgresql. Also my app which uses same database works and I can see >>> the tables and the row in scheduler_task table from appadmin >>> >>> On Friday, January 10, 2014 9:57:25 AM UTC-5, Niphlod wrote: >>>> >>>> what db are you using ? >>>> that error usually pops up when the scheduler can't access the >>>> scheduler_* tables. >>>> >>>> On Friday, January 10, 2014 2:09:26 AM UTC+1, User wrote: >>>>> >>>>> I'm just getting started with the scheduler and I'm getting an error >>>>> when I start it on windows 7: >>>>> >>>>> C:\www\web2py>python web2py.py -K my_app >>>>> web2py Web Framework >>>>> Created by Massimo Di Pierro, Copyright 2007-2014 >>>>> Version 2.8.2-stable+timestamp.2013.12.09.17.54.55 >>>>> Database drivers available: SQLite(sqlite3), MySQL(pymysql), >>>>> PostgreSQL(psycopg2 >>>>> ), PostgreSQL(pg8000), MSSQL(pyodbc), DB2(pyodbc), Teradata(pyodbc), >>>>> Ingres(pyod >>>>> bc), IMAP(imaplib) >>>>> starting single-scheduler for "my_app"... >>>>> ERROR:web2py.scheduler.mycomputer#10144:Error retrieving status >>>>> ERROR:web2py.scheduler.mycomputer#10144:Error retrieving status >>>>> >>>>> >>>>> This error just continually repeats until I ctrl-c. >>>>> Here is my scheduler.py: >>>>> >>>>> # coding: utf8 >>>>> def doit(): >>>>> print 'hello world' >>>>> >>>>> tasks = dict( >>>>> doit=doit, >>>>> ) >>>>> from gluon.scheduler import Scheduler >>>>> scheduler = Scheduler(db, tasks) >>>>> >>>>> >>>>> I created a single row in the scheduler_task table. What is causing >>>>> this error? How do I begin to debug this? (Note when browsing my site >>>>> there >>>>> are no errors). >>>>> >>>>> -- 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.
