Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
308 views
in Q2A Core by
I'd like to bulk assign all activity(questions/answers/comments) of a particular user to a different user ID, through PHPMyadmin?  I know its easy, but im not good with SQL.

Thanks for any help, in advance.

1 Answer

0 votes
by
selected by
 
Best answer
just try the following

update qa_posts set userid="to a different user ID"  where userid="particular user ID";

you need to update name and other information if necessary.
by
Thanks, that worked just fine. :)
by
You'll also want to go to the Admin > Stats page and click the "Recount posts" button to update the user stats.
by
Oh, i just used "recalculate points" instead. Will it work?

Also, please reply to the PM i sent if you have time. Thanks.
by
Can you please check the PM when you have time. @Scott Thanks.
...