TypeError: tuple indices must be integers, not str

[xMohammedx]

hello,
i think there is an error in login function,
every things works but when i try to login with my username i got this error:
TypeError
TypeError: tuple indices must be integers, not str
File "/home/***/Desktop/myflaskapp/app.py", line 139, in login
result = cur.execute("SELECT * FROM users WHERE username = %s", [username])
if result > 0:
# Get stored hash
data = cur.fetchone()
password = data['password']
# Compare Passwords
if sha256_crypt.verify(password_candidate, password):
# Passed
session['logged_in'] = True

TypeError: tuple indices must be integers, not str

[xMohammedx]

i solved it using this code:

# User login
@app.route('/login', methods=['GET', 'POST'])
def login():
    if request.method == 'POST':
        # Get Form Fields
        username = request.form['username']
        password_candidate = request.form['password']

        # Create cursor
         cur = mysql.connection.cursor()
        
        
        cur.execute("SELECT COUNT(1) FROM users WHERE name = %s;", [username]) # CHECKS IF USERNAME EXSIST
        if cur.fetchone()[0]:
            cur.execute("SELECT password FROM users WHERE name = %s;", [username]) # FETCH THE HASHED PASSWORD
            for row in cur.fetchall():
                if sha256_crypt.verify(password_candidate, row[0]):
                    session['logged_in'] = True
                    session['username'] = username
                    flash('You are now logged in', 'success')
                    return redirect(url_for('dashboard'))

                else:
                    error = 'Invalid login'
                    return render_template('login.html', error=error)
            # Close connection
            cur.close()
        else:
            error = 'Username not found'
            return render_template('login.html', error=error)

    return render_template('login.html')