Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Sam Horne 11 posts 61 karma points
    Apr 15, 2013 @ 05:53
    Sam Horne
    0

    SQL Syntax bug in Comment.Save()

    Not sure if this has previously been picked up or corrected - but I found an SQL syntax bug in the Comment.cs class.

    In Comment.Save(), in ExecuteNonQuery during an update, the update script string (around ln 88):

    "UPDATE forumComments SET topicId = @topicId, memberId = @memberId, body = @body, WHERE id = @id"

    The comma before the 'WHERE' keyword should not be there, and causes an sql syntax exception upon execution.

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies