Announcement

Collapse
No announcement yet.

Some Users lost - How can I edit the threads and post back to original users

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

  • Some Users lost - How can I edit the threads and post back to original users

    Hi All

    i just had some problems with my site and lost some users.

    All threads and posts are there but threads belonging to lost users now shows as guest in their usergroup. but at least it shows who posted them

    my question is how can I edit these threads and post so i can change the users?

    is phpmyadmin a way and the only way? is there any alternatives?

    thanks in advance.

    Tom

  • #2
    You would run this query for each user:

    UPDATE post SET userid='xxx' WHERE username='Old Name';

    ...with 'xxx' being the userid number of the new account and 'Old Name' being the username on those posts.

    Then rebuild the thread and forum counters in that order:

    Admin CP -> Maintenance -> Update Counters
    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


    • #3
      hi steve!

      Thanks for the reply!
      That's great, i'll do that first thing in the morning!

      but does it matter if the reregistered user has made a posting of the same topic?

      thanks!
      Tom

      Comment


      • #4
        No, that will not matter.
        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


        • #5
          hi steve

          i tried the query but i was returned with:

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


          How can i fix that? or is there something that i need to tell my webhost?

          Thanks!
          Tom

          Comment


          • #6
            You are using a table prefix and need to add that prefix in from of 'post'. Check the database or config.php for this prefix.
            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


            • #7
              hey steve

              it works as well as it is simple!
              thanks so much for your replies

              it's vb3post for mine

              Comment


              • #8
                hi steve sorry to bother you again

                does that sql query applies to both posts and threads?

                Also, is there any chance in restoring PMs?

                thanks!
                tom
                Last edited by 6piston; Mon 27th Jul '09, 1:08am.

                Comment


                • #9
                  The table prefix applies to all tables.

                  Also I believe the PMs were removed when those users were deleted.
                  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


                  • #10
                    hi steve

                    damn. well, i guess i'm already very fortunate to be able to restore the post

                    Comment

                    Related Topics

                    Collapse

                    Working...
                    X