Is this is a problem that worked before and then stopped working? Have you changed anything on the database side? Do you have data that you need to recovered.
If at all an option, try delete the database and make a new one. Somehow there is a problem with the web2py_filesystem table where web2py stores metadata on platforms that lack a persistent filesystem. This an be recovered but it is complicated to explain without direct access to the system. It really depends on how it got there and what is in there. Massimo On Wednesday, 12 March 2014 17:53:08 UTC-5, Chris DeGroot wrote: > > Hello; > > I have tried everything I could think of to solve this problem, but I just > can't find a solution. I am trying to deploy my application to Heroku, > following the instructions in the web2py manual. The welcome app works > fine, so I think generally I have deployed the app properly. The > application works on my local machine. The error I am getting looks like > this: > > Traceback (most recent call last): > File "/app/web2py/gluon/restricted.py", line 217, in restricted > exec ccode in environment > File "/app/web2py/applications/CaeSuite/models/db.py" > <https://warm-basin-8163.herokuapp.com/admin/default/edit/CaeSuite/models/db.py>, > line 16, in <module> > db = get_db(name=None, pool_size=10) > File "/app/web2py/gluon/contrib/heroku.py", line 26, in get_db > current.session.connect(current.request, current.response, db=db) > File "/app/web2py/gluon/globals.py", line 869, in connect > migrate=table_migrate, > File "/app/web2py/gluon/dal.py", line 8223, in define_table > table = self.lazy_define_table(tablename,*fields,**args) > File "/app/web2py/gluon/dal.py", line 8260, in lazy_define_table > polymodel=polymodel) > File "/app/web2py/gluon/dal.py", line 1102, in create_table > query), table) > File "/app/web2py/gluon/dal.py", line 850, in log > logfile = self.file_open(table._loggername, 'a') > File "/app/web2py/gluon/dal.py", line 4578, in file_open > return DatabaseStoredFile(self.db,filename,mode) > File "/app/web2py/gluon/dal.py", line 4506, in __init__ > self.db.executesql(sql) > File "/app/web2py/gluon/dal.py", line 8433, in executesql > adapter.execute(query) > File "/app/web2py/gluon/dal.py", line 1969, in execute > return self.log_execute(*a, **b) > File "/app/web2py/gluon/dal.py", line 1963, in log_execute > ret = self.cursor.execute(command, *a[1:], **b) > InternalError: current transaction is aborted, commands ignored until end of > transaction block > > Variablesself.cursor.execute<built-in method execute of > psycopg2._psycopg.cursor > object>self<gluon.contrib.heroku.HerokuPostgresAdapter > object>self.cursor<cursor object at 0x287a338; closed: 0>b{}a('CREATE TABLE > IF NOT EXISTS web2py_filesystem (path VARCHAR(255), content TEXT, PRIMARY > KEY(path));',)retundefinedcommand'CREATE TABLE IF NOT EXISTS > web2py_filesystem (path VARCHAR(255), content TEXT, PRIMARY KEY(path));' > > > I would really appreciate any help!! Thanks, > > > Chris > > -- 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. For more options, visit https://groups.google.com/d/optout.
