I have my system runing on sqlite at my dev environment, but when I push
to production which uses postres I get this:
Ticket ID
80.75.108.196.2012-05-28.05-45-56.74d0c90a-1a1b-4b60-8ba6-c13af5955bbb
<class 'psycopg2.InternalError'> current transaction is aborted,
commands ignored until end of transaction block
Version
web2py^(TM) (1, 99, 7, datetime.datetime(2012, 3, 4, 22, 12, 8), 'stable')
Python Python 2.7.2+: /usr/bin/python
Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
Traceback(most recent call last):
File"/home/www-data/web2py/gluon/restricted.py",line205,inrestricted
execccodeinenvironment
File"/home/www-data/web2py/applications/welcome/controllers/event_admin.py"
<https://interestid.com/admin/default/edit/welcome/controllers/event_admin.py>,line321,in<module>
File"/home/www-data/web2py/gluon/globals.py",line173,in<lambda>
self._caller=lambdaf:f()
File"/home/www-data/web2py/gluon/tools.py",line2575,inf
returnaction(*a, **b)
File"/home/www-data/web2py/applications/welcome/controllers/event_admin.py"
<https://interestid.com/admin/default/edit/welcome/controllers/event_admin.py>,line127,ininvitations
need_nickname=db(db.auth_user.nickname== (nickname+str(counter))).select()
File"/home/www-data/web2py/gluon/dal.py",line7578,inselect
returnadapter.select(self.query,fields,attributes)
File"/home/www-data/web2py/gluon/dal.py",line1315,inselect
rows=response(sql)
File"/home/www-data/web2py/gluon/dal.py",line1305,inresponse
self.execute(sql)
File"/home/www-data/web2py/gluon/dal.py",line1392,inexecute
return self.log_execute(*a, **b)
File"/home/www-data/web2py/gluon/dal.py",line1386,inlog_execute
ret=self.cursor.execute(*a, **b)
InternalError:current transactionisaborted,commands ignored until end of
transaction block
Error snapshot help
|<class 'psycopg2.InternalError'>(current transaction is aborted,
commands ignored until end of transaction block )|
inspect attributes
How can I solve this? I think it has something to do with the new table
I needed to create, but I though most migrations where handle seamlessly.
---
BR,
Jason Brower