[web2py] Re: InFailedSqlTransaction

2020-11-10 Thread Jim S
I was guessing that you were missing a field in your scheduled_task table. I don't know when it happened, but at some point an additional field was added to the table. I'm confused as to why your migrate didn't work though to rebuild everything. Well, glad you have it all working now. -Jim

[web2py] Re: InFailedSqlTransaction

2020-11-10 Thread Gaël Princivalle
> Did you go in to the application so that db.py would be executed, thereby triggering the migration to happen? Yes, after each modification of the DB connection string I reload a website page. I've resolved this problem moving the scheduler tables in another DB. Thanks for your help. Il giorn

[web2py] Re: InFailedSqlTransaction

2020-11-10 Thread Jim S
Did you go in to the application so that db.py would be executed, thereby triggering the migration to happen? -Jim On Tuesday, November 10, 2020 at 8:33:41 AM UTC-6, Gaël Princivalle wrote: > > Thank you Jim. > > I've setted migrate to False and fake-migrate to True. > Deleted the scheduler tabl

[web2py] Re: InFailedSqlTransaction

2020-11-10 Thread Gaël Princivalle
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, i

[web2py] Re: InFailedSqlTransaction

2020-11-10 Thread Jim S
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, Novemb

[web2py] Re: InFailedSqlTransaction

2020-11-10 Thread Gaël Princivalle
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 novemb

[web2py] Re: InFailedSqlTransaction

2020-11-08 Thread Gaël Princivalle
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