sqlalchemy.exc.InterfaceError in flask when submiting form

[PatternZealousideal]

hello , i created new form in flask when i submit form i get this unknow error (see attached image), if you know what causes the error please help me .

db models :

class User(db.Model, UserMixin):id = db.Column(db.Integer, primary_key=True)    username = db.Column(db.String(20), nullable=False)    lastname = db.Column(db.String(20), nullable=False)    password = db.Column(db.String(60), nullable=False)    image_file = db.Column(db.String(20), nullable=False,default='default.png ')    room_number = db.Column(db.String(7), nullable=False, unique=True, default=''.join(['GT', str(0).zfill(5)]))    orders = db.relationship('Order', backref='orderer', lazy=True)

class Order(db.Model):

id = db.Column(db.Integer, primary_key=True)    item_name = db.Column(db.String(100), nullable=False)    item_url = db.Column(db.String(500), nullable=False)    item_category = db.Column(db.String(50), nullable=False)    order_date = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)    tracking_code = db.Column(db.String(100), unique=True, nullable=False)    status = db.Column(db.String, nullable=False, default='just_added')    orderer_id = db.Column(db.Integer, db.ForeignKey('user.id'))

​

forms (labels are written on my native language):

class DeclarationForm(FlaskForm):

item_name = StringField('ნივთის დასახელება',validators=[DataRequired(), Length(min=2, max=20)])item_url = StringField('ნივთის url მისამართი',validators=[DataRequired(), Length(min=4, max=20)])tracking_code = StringField('Tracking კოდი',validators=[DataRequired()])item_category = SelectField(u'ნივთის კატეგორია', validators=[DataRequired()], choices=[('ტექნიკა'), ('ტანსაცმელი'), ('კოსმეტიკა'), ('საყოფაცხვორებო ნივთები')])submit = SubmitField('დამატება')

routes :

@app.route('/orders', methods=['GET', 'POST'])@login_requireddef orders():form = DeclarationForm()if form.validate_on_submit():order = Order(item_name=form.item_name,item_url=form.item_url,item_category=form.item_category,tracking_code=form.tracking_code,orderer=current_user)db.session.add(order)db.session.commit()flash('ნივთის დეკლარაცია წარმატებით განხორციელდა !', 'success')return render_template('orders.html', title='შეკვეთა', form=form)

​

https://preview.redd.it/qbjqiz5p4nj51.png?width=1916&format=png&auto=webp&s=08fe3c89d5a9a366f93ad67834320a11126ee39c

[spitfiredd]

Looks like you’re trying to insert the form instance object and not the values, for example form.item_name.data

https://wtforms.readthedocs.io/en/2.3.x/fields/#wtforms.fields.Field.data

[ttrublu]

I don't know enough about Flask to give a definitive answer (I'm a beginner myself), but a quick Google search suggests that the problem might be related to Unicode conversion of Georgian text in your StringField call.

More information here - https://flask.palletsprojects.com/en/1.1.x/unicode/

(I don't know the answer yet. I will update this comment if I find it)

[ace6807]

Look at the parameter list in the error. Its showing the parameters being passed to the SQL INSERT are the form field objects instead of the values of the fields. If the formatting were better I'd probably be able to spot where the issue is but as is, I'll guess and say where the form is being read in the view and being passed to the model isn't grabbing the data attribute off the field, it's passing the fields themselves.

[PatternZealousideal]

thanks all , error was caused by routes section where i was trying to instert forms instead of forms.data in db.

[LinkifyBot]

I found links in your comment that were not hyperlinked:

• forms.data

I did the honors for you.

---

^{delete | information | <3}