Deleted a user but want them back

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • WurkAnimal
    Senior Member
    • Aug 2005
    • 2538
    • 3.5.x

    Deleted a user but want them back

    Hi there.

    I deleted a user from my forum due to the member being very argumentative. We have sorted this issue out now and I would like the member to come back on the forum. I have deleted his account but the posts/threads are still in the forum.

    Anyway possible I can get his account back? if not, merge his threads/posts with his new account?

    Thanks
  • BBR-APBT
    Senior Member
    • Nov 2005
    • 456

    #2
    Not unless you had a SQL backup to retrieve his account from.
    Once you deleted the account it was gone.
    My statements are based on the forums not the CMS as I do not and will not use it.
    If I wanted faulty software I would code it my self. When I pay I expect to get what is advertised. I do not feel I got what I paid for.
    In an honest opinion I feel I paid for vB 5.0 beta 7

    Comment

    • WurkAnimal
      Senior Member
      • Aug 2005
      • 2538
      • 3.5.x

      #3
      Thanks for your reply.

      Anyway I could merge these threads/post to his new account?
      Last edited by WurkAnimal; Sat 30 Jan '10, 3:07pm.

      Comment

      • thinkfast
        New Member
        • Feb 2010
        • 14
        • 4.0.0

        #4
        i have same problem too, but i use VB4

        it came out like this
        #1054 - Unknown column 'postuserid' in 'where clause'

        can you help me please

        Comment

        • borbole
          Senior Member
          • Feb 2010
          • 3074
          • 4.0.0

          #5
          Originally posted by thinkfast
          i have same problem too, but i use VB4

          it came out like this
          #1054 - Unknown column 'postuserid' in 'where clause'

          can you help me please
          Have a look at my mod. It does just that.

          Comment

          • borbole
            Senior Member
            • Feb 2010
            • 3074
            • 4.0.0

            #6
            Originally posted by WurkAnimal
            Thanks for your reply.

            Anyway I could merge these threads/post to his new account?
            Yes you can. It will take a couple of queries. Run them at the SQL tab in the phpmyadmin and change the fields to match your version as they are from the vb 4 version which I use.

            Anyway, after you have registered the user again to reassign all his/her posts back run this query:

            Code:
            UPDATE post SET userid = 'newuserid' WHERE username = 'oldusernameofdeleteduser';
            To reassingn all his/her threads back, run the following query:

            Code:
            UPDATE thread SET postuserid = 'newuserid' WHERE postusername =  'oldusernameofdeleteduser';
            If your db tables have a prefix, include it in your queries and replace the newuserid and oldusernameofdeleteduser accordingly.

            Let me know how it will go.

            Comment

            • vijayninel
              Senior Member
              • Mar 2009
              • 235
              • 3.8.x

              #7
              If the number of posts are less then you can do it with the change posts owner mod available at vb.org
              www.erodov.com :cool:

              Comment

              • borbole
                Senior Member
                • Feb 2010
                • 3074
                • 4.0.0

                #8
                Originally posted by vijayninel
                If the number of posts are less then you can do it with the change posts owner mod available at vb.org
                I don''t think that does work for the posts of deleted users. At least from what I could see at that mod''s description thread.

                Comment

                • vijayninel
                  Senior Member
                  • Mar 2009
                  • 235
                  • 3.8.x

                  #9
                  Originally posted by borbole
                  I don''t think that does work for the posts of deleted users. At least from what I could see at that mod''s description thread.
                  I am talking about this mod http://www.vbulletin.org/forum/showt...ghlight=Change
                  www.erodov.com :cool:

                  Comment

                  widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                  Working...