How do I solve the following error?

Question

1.00/5 (2 votes)

See more:

ERROR in app: Exception on / [GET]
Traceback (most recent call last):
File "/home/aalam/Flask_Blog/venv/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1900, in _execute_context
self.dialect.do_execute(
File "/home/aalam/Flask_Blog/venv/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 736, in do_execute
cursor.execute(statement, parameters)
sqlite3.OperationalError: no such table: post

What I have tried:

Well I haven't tried anything yet as I do not know in what direction to proceed to solve this error.

Posted 8-Feb-23 2:50am

Aalam Pratap Bedi

Updated 8-Feb-23 3:01am

Add a Solution

Comments

Richard MacCutchan 8-Feb-23 8:55am

Look at the final error message.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2023-02-08T03:01:00

Solution 1

Look at the code around line 736. You seem to be setting up a SQL query and your statement is not correct because there is "no such table: post" in your database.

Posted 8-Feb-23 3:01am

Dave Kreskowiak

Comments

Aalam Pratap Bedi 22-Feb-23 8:26am

@Dave Kreskowiak then how do I solve this error?

Dave Kreskowiak 22-Feb-23 8:36am

Read my post again.

How can any tell you how to fix your code when you never showed your code? On top of that what is the correct table name you're trying to run an SQL statement against, because it's not "post".

Aalam Pratap Bedi 22-Feb-23 8:48am

@ Dave Kreskowiak what part of code should I share, so that you can help me out?

Dave Kreskowiak 22-Feb-23 8:49am

Sigh. Did you read my post AT ALL? Look at the error messages you posted. What are the line numbers in those error messages? You post the code around those line numbers!

Aalam Pratap Bedi 22-Feb-23 8:56am

YES! Why?

Dave Kreskowiak 22-Feb-23 8:57am

Because I already told you what code to look at and that statement appearently flew right over your head and you didn't notice it.

Aalam Pratap Bedi 22-Feb-23 9:02am

Yes, I understand the point that the table named post is missing from my database. I want to know how to create it.

Dave Kreskowiak 22-Feb-23 9:06am

THAT'S NOT WHAT YOU ASKED! You posted an error message and asked "how do I fix it"? Creating a table in a database is not the question you asked.

You're going to have to consult the documentation on whatever database engine you're using. Nobody can tell you how to create the table because you left out the little detail of which database engine you are using.

Have a nice life.

Aalam Pratap Bedi 22-Feb-23 9:14am

I guess I frustrated you a little bit, sorry if I did so. I am still not an experienced coder. Thanks for helping, though.

Aalam Pratap Bedi 22-Feb-23 9:17am

And I am using Flask-SQLAlchemy database.

Dave Kreskowiak 22-Feb-23 9:42am

Flask-SQLAlchemy — Flask-SQLAlchemy Documentation (3.0.x)[^]

Dave Kreskowiak 22-Feb-23 10:00am

Seriously. Read this: Asking questions is a skill[^]