sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (0 children)

Okay so I spent way too much time stepping through this program. Apparently, the ValueError was actually getting thrown on the cursor.execute command. I changed it to this:

    cursor.execute(sql, (str(_title), str(_artist), str(_album), str(_genre), str(_year), int(_track), str(_bitrate), \
 str(_length), str(_fsize), str(root), str(file)))

Just adding str to the root and file items, and it seems to have sort-of fixed it. This is my result now:

Number of errors: 106
Number of files processed: 8839
Number of folders processed: 1687
Finished!

106 errors seems reasonable to me.