So I did find a workaround. However, I've switched over to PythonAnywhere,
much more seamless to my workflow for Python projects.
The workaround, if I recall correctly, was that I had to use a one-off
dynamo to connect to the DB, and manually created the necessary tables
based on the Web2Py
Has anyone found a solution to this ?
I just tried deploying on Heroku today and had the exact same problem.
Heroku logs :
2014-08-04T19:12:36.276606+00:00 app[web.1]: File /app/gluon/dal.py,
line 4560, in exists
2014-08-04T19:12:36.276608+00:00 app[web.1]: if db.executesql(query):
I'm having the same issue. I only have one DB associated with my Heroku
account, and it's properly being set in get_db(), as it shows up in the
stack trace. Heroku says that the DB has no tables in it.
I was curious to see if perhaps there were leftover .table files in the
filesystem when I
I think I may have made sense of the error above. Based on the code below,
DatabaseStoredFile.web2py_filesystem is set to true even if the table
creation fails (which it does), as I don't think the error will be caught
before it gets to that line. A few lines later, it tries to access that
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
The Heroku logs might also help (password removed):
2014-03-13T01:37:17.022191+00:00 heroku[web.1]: Starting process with
command `python web2py/web2py.py -a '{PASSWORD}' -i 0.0.0.0 -p 35330`
2014-03-13T01:37:20.361879+00:00 app[web.1]: web2py Web Framework
2014-03-13T01:37:20.361879+00:00
Hi Massimo,
This application worked until I switched to the Postgresql database, so it
is definitely a database problem. Originally I was using the default
database, which I guess is file-based, so the data would be lost about once
a day when Heroku cleaned out its files. That was fine for
I am looking again at the Heroku logs, specifically the line
ERROR:web2py.dal:Could not retrieve applications/CaeSuite/databases/
9e6a7c1bb77d791a89631de258057aed_web2py_session_CaeSuite.table
Why is it looking for a file in */databases?
Chris
On Thursday, March 13, 2014 10:14:32 AM UTC-4,
web2py stores metadata about DB tables which have been created. This is
necessary for migrations. Normally this metadata is store in *.table files.
Heroku has a strange filesystem that gets wiped up at random times. For
this reason the *.table files are not in the normal filesystem. Web2py
9 matches
Mail list logo
