Can you go to the databases directory in your app and delete the scheduler tables from there? Then make sure your db connection has migrate=True specified along with fake-migrate=False.
I'm thinking that should force a rebuild of the scheduler tables in your database. -Jim On Tuesday, November 10, 2020 at 3:02:15 AM UTC-6, Gaël Princivalle wrote: > > I've deleted the scheduler.py file and deleted the scheduler tables. > Now if I add again the scheduler.py file the scheduler tables are in the > admin but not in the DB, and the error is the same for all the scheduler > tables, InFailedSqlTransaction. > > Someone can help me? > > Il giorno domenica 8 novembre 2020 alle 21:08:45 UTC+1 Gaël Princivalle ha > scritto: > >> We talk about the db.scheduler_task table. I've deleted all the records >> from this table, and also from db.scheduler_run and db.scheduler_worker. >> >> No way. >> >> Il giorno domenica 8 novembre 2020 alle 20:57:23 UTC+1 Gaël Princivalle >> ha scritto: >> >>> Hi. >>> >>> Someone knows what it means? >>> >>> After a server change I'm able in the Admin to modify the table records >>> but not the one of the scheduler. >>> >>> Any idea? >>> >>> Traceback (most recent call last): >>> File "/home/user/apps/web2py_folder/web2py/gluon/main.py", line 456, >>> in wsgibase >>> session._try_store_in_db(request, response) >>> File "/home/user/apps/web2py_folder/web2py/gluon/globals.py", line >>> 1251, in _try_store_in_db >>> if not table._db(table.id == record_id).update(**dd): >>> File >>> "/home/user/apps/web2py_folder/web2py/gluon/packages/dal/pydal/objects.py", >>> line 2686, in update >>> ret = db._adapter.update(table, self.query, row.op_values()) >>> File >>> "/home/user/apps/web2py_folder/web2py/gluon/packages/dal/pydal/adapters/base.py", >>> >>> line 579, in update >>> raise e >>> InFailedSqlTransaction: current transaction is aborted, commands ignored >>> until end of transaction block >>> >> -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/0b4e4e73-2f2d-4ae5-95f6-c06867ff0440o%40googlegroups.com.
