musicdb/videodb: cleanup usage of CommitTransaction() and RollbackTransaction()

Just some missing or wrong calls to RollbackTransaction() and/or CommitTransaction() in the music and video database.