Fixed issue introduced in MySQL upgrade.

icculus · Apr 15, 2009 · f4572e7 · f4572e7
1 parent 2e14a17
commit f4572e7
Show file tree

Hide file tree

Showing 2 changed files with 4 additions and 3 deletions.
diff --git a/makedb.sql b/makedb.sql
@@ -76,7 +76,7 @@ CREATE TABLE alextreg_entrypoints (
 CREATE TABLE alextreg_papertrail (
     id int not null auto_increment,
     action text not null,
-    sql mediumtext not null,
+    sqltext mediumtext not null,
     author varchar(128) not null,
     entrydate datetime not null,
     primary key (id)

diff --git a/vendor/index.php b/vendor/index.php
@@ -36,8 +36,9 @@ function update_papertrail($action, $donesql, $extid)
 
     // Fill in the papertrail.
     $sql = 'insert into alextreg_papertrail' .
-           ' (action, sql, author, entrydate)' .
+           ' (action, sqltext, author, entrydate)' .
            " values ('$sqlaction', '$sqlsql', '$sqlauthor', NOW())";
+
     do_dbinsert($sql);
 } // update_papertrail
 
@@ -62,7 +63,7 @@ function op_renderpapertrail()
         $htmlentrydate = htmlentities($row['entrydate'], ENT_QUOTES);
         $htmlsql = '';
         if ($showsql)
-            $htmlsql = "<br>\n<code>'" . htmlentities($row['sql'], ENT_QUOTES) . "'</code>";
+            $htmlsql = "<br>\n<code>'" . htmlentities($row['sqltext'], ENT_QUOTES) . "'</code>";
         echo "  <li><b>$htmlaction</b>: <i>by $htmlauthor, on ${htmlentrydate}</i>${htmlsql}\n";
     } // while
     db_free_result($query);