From ffd74ed9508d88b2759392a4403ac94d5ea9899e 2017-07-01 19:30:34
From: DarkMorford <DarkMorford@Gmail.com>
Date: 2017-07-01 19:30:34
Subject: [PATCH] Fix empty SQL error when editing transcripts.

---

diff --git a/include/transcript.php b/include/transcript.php
index 48f8028..977f4f0 100644
--- a/include/transcript.php
+++ b/include/transcript.php
@@ -65,7 +65,7 @@ function savetranscript( &$strip ) {
 	$dbConnection->executeUpdate('DELETE FROM transcript WHERE transcript.strip = ?', array($strip->id));
 
 	if( $strip->transcript_posted ) {
-		$inserter = 'INSERT INTO transcript (strip, panel, line, speaker, speech, search) VALUES (?, ?, ?, ?, ?, ?)';
+		$insert_sql = 'INSERT INTO transcript (strip, panel, line, speaker, speech, search) VALUES (?, ?, ?, ?, ?, ?)';
 		$inserter_types = array(PDO::PARAM_INT, PDO::PARAM_INT, PDO::PARAM_INT, PDO::PARAM_STR, PDO::PARAM_STR, PDO::PARAM_STR);
 
 		if(strpos($strip->transcript_posted, 'Panel <$n>') !== FALSE) {