- Changed '%s' into '%d' such that an empty $user->uid is converted to 0. Required for Drupal to work on new versions of PostgreSQL. Patch by James.

1 files changed, 2 insertions, 2 deletions

diff --git a/modules/comment.module b/modules/comment.module
index 88c2ee7c9..a1057ad17 100644
--- a/modules/comment.module
+++ b/modules/comment.module
@@ -270,7 +270,7 @@ function comment_post($edit) {
 
         $edit["cid"] = db_next_id("comments");
 
-        db_query("INSERT INTO comments (cid, nid, pid, uid, subject, comment, hostname, timestamp, status, score, users) VALUES ('%d', '%d', '%d', '$user->uid', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", $edit["cid"], $edit["nid"], $edit["pid"], $edit["subject"], $edit["comment"], getenv("REMOTE_ADDR"), time(), $status, $score, $users);
+        db_query("INSERT INTO comments (cid, nid, pid, uid, subject, comment, hostname, timestamp, status, score, users) VALUES ('%d', '%d', '%d', '%d', '%s', '%s', '%s', '%s', '%s', '%s', '%s')", $edit["cid"], $edit["nid"], $edit["pid"], $user->uid, $edit["subject"], $edit["comment"], getenv("REMOTE_ADDR"), time(), $status, $score, $users);
 
         /*
         ** Tell the other modules a new comment has been submitted:
@@ -1385,7 +1385,7 @@ function comment_tag_new($nid) {
       db_query("UPDATE history SET timestamp = '%d' WHERE uid = '$user->uid' AND nid = '%d'", time(), $nid);
     }
     else {
-      db_query("INSERT INTO history (uid, nid, timestamp) VALUES ('$user->uid', '%d', '%d')", $nid, time());
+      db_query("INSERT INTO history (uid, nid, timestamp) VALUES ('%d', '%d', '%d')", $user->uid, $nid, time());
     }
   }
 }