It says, "SQLITE_ERROR: no such table: lists"

[Kanika637]

I started both the servers and the backend server gave this error "SQLITE_ERROR: no such table: lists" and then on the browser it shows this:

I am using this application for deployment purposes for my assignment, can you please tell me how to solve this error?

[mxagg]

To fix that error:

1. Pull repository for latest changes
2. Go to to todom-backend directory then:

# should open SQLite prompt and connects to your database file
sqlite3 todo.db

3. Then type the following command:

CREATE TABLE lists (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL
);

4. Exit the SQLite prompt by typing .exit and pressing Enter.

Let me know if this fixes your error.