Hey, thanks for reading. Glad you enjoyed the article. Were you able to resolve the issue? Sorry it took me so long to get back.

Judging by the error, it looks like the users table no longer exists and needs to be created.

If you're not very familiar with inspecting databases with python, i recommend checking out and trying the program db browser. That program gives you a gui to inspect and manipulate the sqlite file using raw sql.

Otherwise, from the article, the Create the Users Table section references the code you likely need to run so the database is correctly set up in the table.

conn = sqlite3.connect('data.sqlite')

#connect to the database

engine = create_engine('sqlite:///data.sqlite')

db = SQLAlchemy()

#class for the table Users

class Users(db.Model):

id = db.Column(db.Integer, primary_key=True)

username = db.Column(db.String(15), unique=True, nullable = False)

email = db.Column(db.String(50), unique=True)

password = db.Column(db.String(80))

Users_tbl = Table('users', Users.metadata)

#fuction to create table using Users class

def create_users_table():

Users.metadata.create_all(engine)

#create the table

create_users_table()

Hopefully these tips help.

Software Product Analyst in Data Science. pythondashboards.com Top writer in Business www.linkedin.com/in/erickleppen01/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store