Can't delete user

superlovesuperlove Member
edited April 2012 in Questions
Trying to delete a user with Blank User Content gives the following error :
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

Comments

  • Sorry about that, I'll have a look and get it patched as soon as possible.
  • excuse me, but this is still not working...
  • MarkMark Staff
    @superlove - I just picked up this bug and am trying to resolve. Do you have a specific user on your forum you're trying to delete? I can't duplicate the bug in my local system.
  • @Mark Try the user "^^^^^^^^^^^^^^^^^^^". I only get the error when trying to delete a user with the deletion option "Blank User Content".
  • MarkMark Staff
    Just an update: We've finally gotten to the bottom of this bug, and it has to do with a change that our database provider made to their command structure. We are working on a fix, but it will take some time before we get it tested and into the hosting platform.
  • Fantastic - looking forward to the fix.
This discussion has been closed.