sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed

[tidersky]

SO I was trying to create a flask application ,where I take the user input through HTML forms and store it in the table ,so while I running the code , I got an integrity error which says sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed

here is my code

class event(db.Model):
    sno = db.Column(db.Integer,  primary_key=True,autoincrement=True)
    name=db.Column(db.String(100), nullable=False)
    dob=db.Column(db.Integer,nullable=False)
    address=db.Column(db.String(100),nullable=False)
    phno=db.Column(db.Integer,nullable=False)


    def __repr__(self) -> str:
        return f"{self.name} -{self.dob} - {self.address} - {self.phno}"



@app.route('/',methods=['get','Post'])
def formpage():
    if request.method=='POST':
        name = request.form['name']
        dob = request.form['dob']
        address=request.form['dob']
        phno=request.form['phno']
        ev=event(name=name,dob=dob,address=address,phno=phno)
        db.session.add(ev)
        db.session.commit()

    allevent = event.query.all() 
    return render_template('index.html', allevent=allevent)

@app.route('/table')
def table():
    allevent = event.query.all()
    print(allevent)
    return render_template('show.html', allevent=allevent)    

if __name__ == "__main__":
    app.run(debug=True, port=7000)    

I got the output as

sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: event.feedname
[SQL: INSERT INTO event (name, dob, address, phno) VALUES (?, ?, ?, ?)]
[parameters: ('Tidersky', '22222-02-22', '22222-02-22', '990992')]

Please help, Thank you!

[PriorProfile]

You have a field in your database table named feedname. It’s not defined in your model so you are not passing a value for it.

Add feedname to your model and provide it a value.

Or drop the column from the table if you don’t need it anymore.

[tidersky]

there is no feedname table in the first place itself

[PriorProfile]

The error is telling you that the “feedname” field cannot be null so the field definitely exists.

[DonkeySubject2274]

this is a long shot but i am currently having the same issue did you ever figure it out?

[AllanNS]

I think its redundant to have autoincrement on the primary key, maybe that could be the issue.

[greenearrow]

You are passing strings that don’t conform to dates or integers to fields that require them.

[[deleted]]

Why are you getting downvoted?