Blog Documentation Book a Demo
Vanilla open source was terminated 1 January 2025 by Higher Logic. See this announcement for more information.

SQL syntax error

merainemeraine New
in Vanilla 2.0 - 2.8

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

  • 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.