Hello sudenly my web2py app returns error when creating table with a model like
db.define_table('mytable',
Field('field1'),
Field('field2')
)
the error returns when i got to web2py appadmin and try to edit the table
Error ticket for "fileit"
Ticket ID
194.65.91.147.2021-02-09.17-25-44.139628de-94ef-4775-ac11-a46915db90ef
<class 'psycopg2.errors.InFailedSqlTransaction'> current transaction is aborted, commands ignored until end of transaction block
Versão
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
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", line 85, in <module>
{{=SQLTABLE(rows,linkto,upload,orderby=True,_class='sortable')}}
File "/home/ramos/apps/fileit/web2py/applications/fileit/models/tools.py", line 24, in myFriends
).select(db.dbentities.id).as_list()
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 ???
