- Posts: 22
- Thank you received: 0
Kunena 6.2.2 Released with module Latest 6.0.5, module Kunena Stats 6.0.5, Kunena Discuss 6.0.5 and Kunena Search module 6.0.5
The Kunena team has announce the arrival of Kunena 6.2.2 [K 6.2.2] which is now available for download as a native Joomla extension for J! 4.3.x/4.4.x/5.0.x. This version addresses most of the issues that were discovered in K 6.1 / K 6.2 and issues discovered during the last development stages of K 6.2
Solved Move posts from one user to another
just interested if exists a possibility to move posts to another user? We have an 8 years old forum and often people register with new accounts because forget old logins later they want to keep there old posts to there new accounts.
I suppose it is a strange not common needed function but perhaps it exist already?
I did it already for an older Kunena version 1.7
Now the database structure is much more complex and I would be safe with it ... maybe you have time for a quick response without giving guarantee
I would just check and change:
- userid and email in #__kunena_messages
- count user posts in #__kunena_users
- check and handle if needed first_post_userid, first_post_guest_name, last_post_userid, last_post_guest_name in #__kunena_topics
- maybe changing user_id #__kunena_user_topics is also required? did I forgot something?
Thanks a lot for advice and hints ... if needed as payed extra service let me know.
I'm sorry, but I couldn't give you a guarantee. But I think, it should be enough, if you to change the 2 colums "name" and "userid" in the table #__kunena_messages. Only if a message has been edited, then also the column "modified_by". Example:
if needed as payed extra service let me know
UPDATE `#__kunena_messages` SET name='Smoker', userid='218' WHERE userid='212';
Afterwards you must go in the backend to Kunena -> Tools. Synchronize your users and Recount Statistics.
the sync button could be an easy solution
... means that the "synchronize users" will check and change #__kunena_topics and subscriptions in #__kunena_user_topics, #__kunena_user_categories too?
No, this option will only changes the author names in posts. But subscriptions should be the slightest problem. You can remove in backend (Kunena -> Users) user subscriptions, or user can subscribe topics again.
means that the "synchronize users" will check and change #__kunena_topics and subscriptions in #__kunena_user_topics, #__kunena_user_categories too?
Thanks also for your great job you do with Kunena!