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.

Please Sign in or register to post replies

Write your reply to:

Draft