Thank you Jim. I've setted migrate to False and fake-migrate to True. Deleted the scheduler tables in the database folder Setted migrate to True and fake-migrate to False And the tables are not rebuild in the DB. The error still the same.
I'll try to delete the scheduler.py file, export the db, import it in a new db and add again the scheduler... Il giorno martedì 10 novembre 2020 alle 15:20:36 UTC+1 Jim S ha scritto: > 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/1731a012-c710-4c1a-b133-ff2c1e8d04ban%40googlegroups.com.
