Solved! apparently tables were not recreated. All is fine now!! Regards
Em sex., 29 de abr. de 2022 às 17:40, António Ramos <ramstei...@gmail.com> escreveu: > My scheduler was not running my tasks. > So i deleted scheduler tables from postgres and deletes files from > databases/ > > I restarted my app and refreshed appadmin. All files and tables were > recreated. > However going in appadmin to > db.scheduler_task > i get this error > Error ticket for "fileit"Ticket ID > > 194.65.91.147.2022-04-29.16-40-06.d2cd4be0-a64e-4396-af80-c3c76f6bdbed > <class 'psycopg2.errors.InFailedSqlTransaction'> current transaction is > aborted, commands ignored until end of transaction blockVersion > web2py™ Version 2.20.4-stable+timestamp.2020.05.03.05.18.50 > Python Python 3.6.8: /home/ramos/apps/fileit/env/bin/uwsgi (prefix: > /home/ramos/apps/fileit/env)Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > 16. > 17. > 18. > 19. > 20. > 21. > 22. > 23. > 24. > 25. > 26. > 27. > 28. > 29. > 30. > 31. > > Traceback (most recent call last): > File "/home/ramos/apps/fileit/web2py/gluon/authapi.py", line 590, in > has_membership > group_id = int(group_id) > ValueError: invalid literal for int() with base 10: 'Admin' > > During handling of the above exception, another exception occurred: > > Traceback (most recent call last): > File "/home/ramos/apps/fileit/web2py/gluon/restricted.py", line 219, in > restricted > exec(ccode, environment) > File > "/home/ramos/apps/fileit/web2py/applications/fileit/views/appadmin.html" > <https://portal.cires.pt/admin/edit/fileit/views/appadmin.html>, line 154, in > <module> > {{else:}} > File "/home/ramos/apps/fileit/web2py/gluon/authapi.py", line 592, in > has_membership > group_id = self.id_group(group_id) # interpret group_id as a role > File "/home/ramos/apps/fileit/web2py/gluon/authapi.py", line 454, in > id_group > rows = self.db(self.table_group().role == role).select() > File "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/objects.py", > line 2634, in select > return adapter.select(self.query, fields, attributes) > File > "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 878, in select > return self._select_aux(sql, fields, attributes, colnames) > File > "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 835, in _select_aux > rows = self._select_aux_execute(sql) > File > "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 829, in _select_aux_execute > self.execute(sql) > File > "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/__init__.py", > line 69, in wrap > return f(*args, **kwargs) > File > "/home/ramos/apps/fileit/web2py/gluon/packages/dal/pydal/adapters/base.py", > line 461, in execute > rv = self.cursor.execute(command, *args[1:], **kwargs) > psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, > commands ignored until end of transaction block > > Any help please ? > > Regards > António > > -- 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/CAEM0BxO_WUo5ej6z7E9GYL15sV-AVms6ossei8ktCcwe0cX9fw%40mail.gmail.com.