It was tested on heroku and it worked. please opena ticket. perhaps
something has changed.
On Wednesday, 6 August 2014 03:22:03 UTC-5, Louis Amon wrote:
>
> Got the same issue as well.
>
> Apparently the problem has to do with the "UseDatabaseStoredFile" class
> inherited by the "HerokuPostgresAdapter".
>
> It is designed to store the filesystem ("databases" folder and files) in a
> table instead, and was created for GAE but doesn't seem to work on Heroku.
>
> That's about as far as I can go, being a novice and all...
>
> Should I issue a ticket ?
>
> On Thursday, March 13, 2014 4:11:54 PM UTC+1, Chris DeGroot wrote:
>>
>> 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 <[email protected]> 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
>>> [email protected].
>>> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
