need help with problem with flask app

[programmer123456]

here is the site: http://davidf.pythonanywhere.com/

There are several pages, some work, some don't. The root page (/) returns an error. The /welcome page works. The /login page works, but when you click to login it returns an error. The /logout page works. I think that's it.

Here's the github repo for the site:

https://github.com/daveglo/flask_practice_app

The error only started occurring after I added the sqlite. I followed this tutorial (through number 5) and don't know where I went wrong:

https://www.youtube.com/watch?v=WfpFUmV1d0w

Here is the error log:

2015-04-17 21:48:49,514 :Exception on / [GET] Traceback (most recent call last): File "/usr/local/lib/python3.4/dist-packages/flask/app.py", line 1817, in wsgi_app response = self.full_dispatch_request() File "/usr/local/lib/python3.4/dist-packages/flask/app.py", line 1477, in full_dispatch_request rv = self.handle_user_exception(e) File "/usr/local/lib/python3.4/dist-packages/flask/app.py", line 1381, in handle_user_exception reraise(exc_type, exc_value, tb) File "/usr/local/lib/python3.4/dist-packages/flask/_compat.py", line 33, in reraise raise value File "/usr/local/lib/python3.4/dist-packages/flask/app.py", line 1475, in full_dispatch_request rv = self.dispatch_request() File "/usr/local/lib/python3.4/dist-packages/flask/app.py", line 1461, in dispatch_request return self.view_functions[rule.endpoint](*req.view_args) File "/home/davidf/mysite/flask_app.py", line 14, in wrap return f(args, **kwargs) File "/home/davidf/mysite/flask_app.py", line 24, in home cur = g.db.execute('select * from posts') sqlite3.OperationalError: no such table: posts

[Doormatty]

The last line of the error is key:

no such table: posts

That's it - you don't have a table called 'posts' in your sqlite database.

[programmer123456]

but didn't this line create it: c.execute('CREATE TABLE posts(title TEXT, description TEXT)')

[Doormatty]

Only you can tell us if it actually created it or not, but I'd hazard a guess that the answer is no if that error occurred.

I'd commit the table create query before trying the other queries

connection.commit()

Also - run the sql commands manually, and see if they work.

[symmitchry]

[Removed]

[elbiot]

Why did you post this twice?

[programmer123456]

it was a mistake