Python: 'NoneType' object is not subscriptable' error [duplicate]

Question

I'm new to databases in Python, so to practice some key skills I'm building a login screen that writes usernames and hashed passwords to the database, and then checks the user's inputs against what's in the database. However, when trying to pull the usernames and passwords from the database and storing them in variables, I keep getting the "'NoneType' object is not subscriptable" error.

How can I fix this?

This is the function from my program that contains the error

def login():
usernameAttempt = input("Enter your username: ")
passwordAttempt = input("Enter your password: ")

usernameSql = """SELECT Username FROM Details WHERE Password = '%s'""" % (passwordAttempt) # Selecting username in database
cur.execute(usernameSql)
usernameSql = cur.fetchone()
userFetched = usernameSql[0] # Pulling the item from the database

passwordSql = """SELECT Password FROM Details WHERE Username = '%s'""" % (usernameAttempt)
cur.execute(passwordSql)
passwordSql = cur.fetchone()
passFetched = passwordSql[0]

dbPassword, dbSalt = passFetched.split(":")

return dbPassword, dbSalt, passwordAttempt, usernameAttempt, userFetched, passFetched

I expected the variables userFetched and passFetched to be assigned the values held at indexes 0 in the username and password columns, but the error messages are as follows:

Traceback (most recent call last):

File "C:\Users\laure\Documents\Login screen.py", line 57, in dbPassword, dbSalt, passwordAttempt, usernameAttempt, userFetched, passFetched = login()

File "C:\Users\laure\Documents\Login screen.py", line 34, in login userFetched = usernameSql[0] # Pulling the item from the database TypeError: 'NoneType' object is not subscriptable

BTW, please don't format SQL yourself. Use the second paramter of the execute method instead. — Matthias
– Matthias, Commented Oct 26, 2019 at 11:34
@back2thelotus Your code is vulnerable to SQL injection. Please read up on it and follow Matthias's suggestion so that your database doesn't get hacked. — Jack Taylor
– Jack Taylor, Commented Oct 26, 2019 at 11:40

BoarGules · Accepted Answer · 2019-10-26 11:32:29Z

1

Your select Username query is returning no rows. So the result set is empty and there is nothing to fetch. So your fetchone call returns None instead of the row tuple you expect.

answered Oct 26, 2019 at 11:32

BoarGules

17.1k3 gold badges29 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Charif DZ · Accepted Answer · 2020-01-29 11:49:20Z

1

When tyour query return 0 rows fetchone will return None:

usernameSql = """SELECT Username FROM Details WHERE Password = '%s'""" % (passwordAttempt) # Selecting username in database
cur.execute(usernameSql)
usernameSql = cur.fetchone()
# check if the query return at least one record
if usernameSql:
    userFetched = usernameSql[0] 
else:
   # show a error or somthing

edited Jan 29, 2020 at 11:49

answered Oct 26, 2019 at 11:33

Charif DZ

14.8k3 gold badges25 silver badges42 bronze badges

Collectives™ on Stack Overflow

Python: 'NoneType' object is not subscriptable' error [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related