[Python] how to solve the error of 'Table' object has no attribute 'userId'

please how doi solve this error "sqlalchemy.exc.InvalidRequestError: One or more mappers failed to initialize - can't proceed with initialization of other mappers. Triggering mapper: 'Mapper[Users(users)]'. Original exception was: 'Table' object has no attribute 'userId'"

in My FLASK/BLUEPRINT admin.py this is my query

found_admin = db.session.scalars(db.select(Users).where(Users.role == "Admin")).first()

Models.py
class Users(db.Model):
id = db.Column(db.Integer, primary_key=True)
fullname = db.Column(db.String(100))
username = db.Column(db.String(100), unique=True)
email = db.Column(db.String(100), unique=True)
gender = db.Column(db.String(100))
phonenumber = db.Column(db.Integer)
role = db.Column(db.String(100))
Password = db.Column(db.String(100))
datecreated = db.Column(db.DateTime, default=datetime.now)

assessmentSubmit = db.relationship('AssessmentSubmit', backref='users')
ProjectResult = db.relationship('ProjectResult', backref='users')

def __init__(self, fullname, username, email, gender, phonenumber, role, Password):
self.fullname = fullname
self.username = username
self.email = email
self.gender = gender
self.phonenumber = phonenumber
self.role = role
self.Password=Password


i have read different post saying whether i miss called a column name or I should use User.c.role="admin" which none of them work. please guide me on what to do

Continue reading...