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/CAEM0BxPBkmjk9vhoLLEyaPoqR%3DN7BfrmT9bTi5VwAL4VCfB6ng%40mail.gmail.com.
