I have just found if I have a secondary database with no tables and I try
to use the database I get the following very unclear and very hard to debug
error:
<class 'psycopg2.InternalError'> current transaction is aborted, commands
ignored until end of transaction block
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.
Traceback (most recent call last):
File "/home/developer/projects/yaw/gluon/restricted.py", line 205,
in restricted
exec ccode in environment
File
"/home/developer/projects/yaw/applications/advertisement/controllers/manage_customers.py"
<https://ad.youadworld.com/admin/edit/advertisement/controllers/manage_customers.py>,
line 600, in <module>
File "/home/developer/projects/yaw/gluon/globals.py", line 173, in <lambda>
self._caller = lambda f: f()
File "/home/developer/projects/yaw/gluon/tools.py", line 2575, in f
return action(*a, **b)
File
"/home/developer/projects/yaw/applications/advertisement/controllers/manage_customers.py"
<https://ad.youadworld.com/admin/edit/advertisement/controllers/manage_customers.py>,
line 147, in index
formname='myform'
File "/home/developer/projects/yaw/gluon/sqlhtml.py", line 1769, in grid
rows = dbset.select(left=left,orderby=orderby,limitby=limitby,*table_fields)
File "/home/developer/projects/yaw/gluon/dal.py", line 7578, in select
return adapter.select(self.query,fields,attributes)
File "/home/developer/projects/yaw/gluon/dal.py", line 1315, in select
rows = response(sql)
File "/home/developer/projects/yaw/gluon/dal.py", line 1305, in response
self.execute(sql)
File "/home/developer/projects/yaw/gluon/dal.py", line 1392, in execute
return self.log_execute(*a, **b)
File "/home/developer/projects/yaw/gluon/dal.py", line 1386, in log_execute
ret = self.cursor.execute(*a, **b)
InternalError: current transaction is aborted, commands ignored until
end of transaction block
--
--
Regards,
Bruce Wade
http://ca.linkedin.com/in/brucelwade
http://www.wadecybertech.com
http://www.fittraineronline.com - Fitness Personal Trainers Online
http://www.warplydesigned.com
