Please HELP me retore a deleted user

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • geovadim
    Senior Member
    • May 2003
    • 362
    • 3.7.x

    Please HELP me retore a deleted user

    I made a search on this forum, but I did't find the appropriate instructions in order to restore a deleted user.

    Specificly, what happend: I deleted a user, now he-s only guest on the forum. I did't delete his posts, all his posts are in the database. How can I restore his name in order that all the posts to be assigned again to his name, as before.

    I really appreciate your PROFESSIONAL help in this matter with a clear query or command that can help me. I am a newbie in vbulletin. I have vb 3.03 version.

    Or should be better to make a support ticket for this?
    Last edited by geovadim; Thu 22 Jul '04, 1:48pm.
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    Create a new user account for him, then run these queries:

    UPDATE post SET userid = X WHERE username = 'OLD USERNAME'

    UPDATE thread SET postuserid = X WHERE postusername = 'OLD USERNAME'

    Where X is the userid of the new user and OLD USERNAME is the old username of the deleted user. If you use table prefixes then you need to change post and thread to include the prefix.

    Then rebuild your various counters:

    Admin CP -> Import & Maintenance -> Update Counters

    That should work. Backup first.

    Comment

    • geovadim
      Senior Member
      • May 2003
      • 362
      • 3.7.x

      #3
      I ca't run a query, I get the following message: You are not authorized to execute SQL queries.

      I added my user ID in the config.php, but I can't still run a query: $canrunqueries = '4'. I am user number 4... Am I doing something wrong?
      Last edited by geovadim; Thu 22 Jul '04, 2:44pm.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        That should work. Copy-n-paste the exact line from your config.php.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • geovadim
          Senior Member
          • May 2003
          • 362
          • 3.7.x

          #5
          Here is my config.php lie regarding running the queries:

          // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
          // The users specified here will be allowed to run queries from the control panel.
          // See the above entries for more information on the format.
          // Please note that the ability to run queries is quite powerful. You may wish
          // to remove all user IDs from this list for security reasons.
          $canrunqueries = '4';

          Comment

          • geovadim
            Senior Member
            • May 2003
            • 362
            • 3.7.x

            #6
            Any solution yet? I really was expecting to a faster help... I know that you guys have a lot of work, but I would really want to solve this problem...

            Comment

            • Jake Bunce
              Senior Member
              • Dec 2000
              • 46598
              • 3.6.x

              #7
              That should be working. Is your userid 4? You can check this in your:

              Admin CP -> Users -> Search for Users

              Find your user and edit your profile. At the top of the page will be something like this:

              User: Your Name (id: 5)

              Comment

              • geovadim
                Senior Member
                • May 2003
                • 362
                • 3.7.x

                #8
                User: Vadim (id: 4)

                Comment

                • Jake Bunce
                  Senior Member
                  • Dec 2000
                  • 46598
                  • 3.6.x

                  #9
                  I don't know why it's not working. We will have to take a look. Submit a support ticket with a FTP login for your server and a URL and admin login for your forums.

                  Comment

                  • geovadim
                    Senior Member
                    • May 2003
                    • 362
                    • 3.7.x

                    #10
                    I submited a query.

                    Comment

                    • Sven
                      Senior Member
                      • Dec 2000
                      • 240

                      #11
                      How would the SQL for PMs read?

                      Comment

                      • Dennis Olson
                        Senior Member
                        • Oct 2002
                        • 2789

                        #12
                        Nevermind. Wrong answer. I dunno if you can recover PMs.

                        Comment

                        • Sven
                          Senior Member
                          • Dec 2000
                          • 240

                          #13
                          I hope so...
                          Should be quite the same as the SQLs posted above - but for the affected tables - and I don't know their names and if it's going to work....

                          Comment

                          • Aros
                            Senior Member
                            • Jun 2002
                            • 323
                            • 3.7.x

                            #14
                            You probably could, but you would have to know the Member's old userid. The table 'pm' doesn't work with a username field.

                            Comment

                            • Tripkebab
                              New Member
                              • Oct 2003
                              • 25

                              #15
                              I Have the same problem, i accidently deleted my vb3_user (i only had 30 members) so i created a new one in another install and copied it accross so i could access admin. Everything works fine now.

                              So i have a member signing up again and i want to rebind his new account to his old posts...

                              I ran the suggested query and am getting the following error.

                              An error occurred while attempting to execute your query. The following information was returned.
                              error number: 1146
                              error desc: Table 'focusu_db1.post' doesn't exist

                              Any suggestions?

                              Thanks
                              John

                              Comment

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