Error binding parameter 0 - probably unsupported type. SQL/Python

Question

genre1, genre2, genre3 has data being retrieved from select fields on my web page. When I select two genres (two fields) it adds the movie perfectly fine. But when I select all three genres (all fields) it gives me an error.

It just doesnt work when theres (genre1,genre2,genre3) It does work when its (genre1,genre3)..but I need all three ofcourse

"Error binding parameter 0 - probably unsupported type."

for name in (genre1, genre2, genre3):
  if name != "":

    genreInfo = db.execute(
        """
        SELECT Genre_ID
        FROM Genres
        WHERE Genre = ?; 
        """,
        (name,)
        )
    selectedGenre = genreInfo.fetchone()[0]

    db.execute(
        """
        INSERT INTO Movie_Genre (Movie_ID, Genre_ID)
        VALUES (?,?)
        """,
        (MovieID, int(selectedGenre),)
        )
    db.commit()
  else:
    pass
    flash("Movie Added!")
    return render_template('admin.html', user_name=user_name, genre=genre)

Please edit the question to include the full traceback and the value causing the error. You have two queries with parameters; we have no way of knowing which one fails. — dirn
– dirn, Commented Jun 7, 2016 at 15:14
Thats all I have, i did not know what was causing the error either. Moving 'db.commit()' outside the for loop fixed the issue.. — 0248881
– 0248881, Commented Jun 8, 2016 at 1:51
Python gives you a traceback. The title of this question is the last line. We need everything before it, too. — dirn
– dirn, Commented Jun 8, 2016 at 1:52

0248881 · Accepted Answer · 2016-06-07 14:23:43Z

2

Okay.. So I moved "db.commit()" so that its outside the for loop and it worked.. I do not know why so if anyone would like to explain.. please feel free to!

answered Jun 7, 2016 at 14:23

0248881

7711 gold badge5 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Error binding parameter 0 - probably unsupported type. SQL/Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related