Announcement

Collapse
No announcement yet.

Deleted a user but want them back

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

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


    • #3
      Thanks for your reply.

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

      Comment


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


        • #5
          Originally posted by thinkfast View Post
          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.

          http://www.vbulletin.org/forum/showthread.php?t=236861

          Comment


          • #6
            Originally posted by WurkAnimal View Post
            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


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


              • #8
                Originally posted by vijayninel View Post
                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


                • #9
                  Originally posted by borbole View Post
                  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...
                  X