Announcement

Collapse
No announcement yet.

Assing user ID

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

  • Assing user ID

    Hi!

    When I go to:
    member.php?u=2
    I get:
    Invalid User specified. If you followed a valid link, please notify the administrator

    And that's correct. I made the user, didn't do anything with it and then deleted it.
    But I want to have a user, using that ID.
    So can I just make a new user, and then go into the dbase and change his ID to 2?
    Last edited by Eagle Creek; Mon 12th Jun '06, 9:54am.
    http://www.nucia.nl/forum/
    The best way to kill malware; is to kill it together.

  • #2
    Nope, you have to run a bunch of queries because posts, privmsgs, threads, etc are all linked to the userid. Changing it might change a lot of things. We don't give support for this as it falls outside of the defaultl vBulletin functionality. The userid field is auto increment.

    Comment


    • #3
      Originally posted by Floris View Post
      Nope, you have to run a bunch of queries because posts, privmsgs, threads, etc are all linked to the userid. Changing it might change a lot of things. We don't give support for this as it falls outside of the defaultl vBulletin functionality. The userid field is auto increment.
      I understand it's auto and linked to many things.
      But, the user 2 didn't had PB's, or posts or whatsoever.. It was just a user, who doesn't excist anymore.
      http://www.nucia.nl/forum/
      The best way to kill malware; is to kill it together.

      Comment


      • #4
        I just changed, only the ID field, to 2 and it seems to be working..

        Is there any change for big problems? Because I don't see problems atm. (going go try something out)
        http://www.nucia.nl/forum/
        The best way to kill malware; is to kill it together.

        Comment


        • #5
          You'll have to update the userfield and usertextfield rows as well, possibly also others.
          Best Regards
          Colin Frei

          Please don't contact me per PM.

          Comment


          • #6
            Owh ok..

            And could I just run a query where user ID = xxx, change it to 2?

            I understand you don't advice it. But when the account is empty, no settings or whatsoever are made.
            http://www.nucia.nl/forum/
            The best way to kill malware; is to kill it together.

            Comment


            • #7
              Try running the 'Repair broken user profiles' function in your
              AdminCP -> Maintenance -> Update Counters

              That should add a row to either table.
              Best Regards
              Colin Frei

              Please don't contact me per PM.

              Comment


              • #8
                So just change the ID and run that script.

                Thank you mister Colin sir!
                http://www.nucia.nl/forum/
                The best way to kill malware; is to kill it together.

                Comment


                • #9
                  I don't know if that will fix everything, but it'll help for sure.
                  Best Regards
                  Colin Frei

                  Please don't contact me per PM.

                  Comment

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