Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

SQL syntax error

I have been asked to delete a user's posts, but when I click on the "Blank user content" option, I get this message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'c from GDN_Comment c join GDN_Discussion d on c.DiscussionID = d.DiscussionID wh' at line 1|Gdn_Database|Query|delete GDN_Comment c from GDN_Comment c join GDN_Discussion d on c.DiscussionID = d.DiscussionID where d.InsertUserID = :dInsertUserID

I'm not a programmer and don't know how to fix or work around this. Any suggestions?

Comments

  • Options
    peregrineperegrine MVP
    edited March 2013

    version of vanilla???

    work around this. - go to the individual discussion for the user in question and delete the comments for that user.

    I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

Sign In or Register to comment.