That's unfortunate to hear that you haven't resolved it. I am having the exact same problem. Locally everything is fine, on Heroku, nothing.
On Thursday, March 13, 2014 11:06:51 AM UTC-4, Ismael Serratos wrote: > > Nope, in fact I switched to ror :S because I needed to run on heroku ASAP. > > But I still getting the error on every web2py application I try to deploy > on heroku. If I use postgres locally everything works just fine. > > On 12/03/2014, at 18:31, Chris DeGroot <cdeg...@gmail.com <javascript:>> > wrote: > > Did you solve this problem? I have the same issue and the links at then > end don't help. > > On Friday, December 27, 2013 11:45:24 PM UTC-5, Ismael Serratos wrote: >> >> Hello everybody, today I tried to push my application to Heroku by using >> the setup-web2py-heroku.sh script. It works fine, but when opening my app I >> get a ticket with this content: >> >> web2py™Version 2.8.2-stable+timestamp.2013.11.28.13.54.07PythonPython >> 2.7.4: /app/.heroku/python/bin/python (prefix: /app/.heroku/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. >> 24. >> 25. >> 26. >> 27. >> 28. >> 29. >> 30. >> >> Traceback (most recent call last): >> File "/app/gluon/restricted.py", line 217, in restricted >> exec ccode in environment >> File "/app/applications/init/models/db.py" >> <https://frozen-sea-3926.herokuapp.com/admin/default/edit/init/models/db.py>, >> line 16, in <module> >> db = get_db(name="HEROKU_POSTGRESQL_RED_URL", pool_size=10) >> File "/app/gluon/contrib/heroku.py", line 26, in get_db >> current.session.connect(current.request, current.response, db=db) >> File "/app/gluon/globals.py", line 833, in connect >> migrate=table_migrate, >> File "/app/gluon/dal.py", line 8139, in define_table >> table = self.lazy_define_table(tablename,*fields,**args) >> File "/app/gluon/dal.py", line 8176, in lazy_define_table >> polymodel=polymodel) >> File "/app/gluon/dal.py", line 1056, in create_table >> query), table) >> File "/app/gluon/dal.py", line 815, in log >> logfile = self.file_open(table._loggername, 'a') >> File "/app/gluon/dal.py", line 4488, in file_open >> return DatabaseStoredFile(self.db,filename,mode) >> File "/app/gluon/dal.py", line 4416, in __init__ >> self.db.executesql(sql) >> File "/app/gluon/dal.py", line 8349, in executesql >> adapter.execute(query) >> File "/app/gluon/dal.py", line 1916, in execute >> return self.log_execute(*a, **b) >> File "/app/gluon/dal.py", line 1910, in log_execute >> ret = self.cursor.execute(command, *a[1:], **b) >> InternalError: current transaction is aborted, commands ignored until end of >> transaction block >> >> I'm getting this ticket with my app and even with a blank copy of web2py and >> the default apps. The admin interface works just fine. What can be the cause >> of this issue? >> >> *Note: In the traceback I pasted here I did replace the get_db connection >> name to the generated one, but the traceback is basically the same if I use >> the default (none). >> >> Best regards, >> >> Ismael Serratos. >> >> >> >> -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/w2RJBqKIwRE/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+un...@googlegroups.com <javascript:>. > For more options, visit https://groups.google.com/d/optout. > > -- 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.
