How to fix internal server error when loading my database page (Flask/Heroku)? How to fix internal server error when loading my database page (Flask/Heroku)? flask flask

How to fix internal server error when loading my database page (Flask/Heroku)?


The way you are using os.environ.get() is wrong.

os.environ.get() is used to obtain environment variables that are exported by your OS, so DATABASE_URL returns None, you cannot connect to None URL, so internal server error.

**Correct Way : **First, export the environment variable, if using Linux :

export DATABASE_URL=postgres://fikwczdiymxhwf:73bf42c2c8a15fa59b77e93654b6383e1cf4f85bdf0156818d1cf39a77815f13@ec2-54-243-47-196.compute-1.amazonaws.com:5432/d3uburco4fea1b

Then, in your code, replace that line as :

DATABASE_URL = os.environ.get('DATABASE_URL', '')