Kunena 6.4.13 Released

The Kunena team has announce the arrival of Kunena 6.4.13 [6.4.13] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x./6.1.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 6.0
Hint: This version is primarily intended to facilitate an upgrade if Joomla was first updated to version 6.1 before Kunena was up to dated.

Solved K 3.0.5 : How to change the name of the writer of a topic

More
10 years 9 months ago #169117 by phiphi22
K 3.0.5 : How to change the name of the writer of a topic was created by phiphi22
Hi all,

Everything is in the title, I would like to know if it's possible to change the name of the writer of a topic and how to. Even if I need to go into the database (which table, column, etc.)?

Thanks in advance.

Philippe

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #169118 by sozzled
Replied by sozzled on topic K 3.0.5 : How to change the name of the writer of a topic
The information is stored in the database (in the table _kunena_messages)

To change the name of the "writer of a topic", locate the record that corresponds to the first post in the topic and change the userid field (and, optionally, the name field) to what you need.
Blue Eagle vs. Crypsis reference guide
Read my blog and
[img

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #169120 by WolfgangOWL
Replied by WolfgangOWL on topic K 3.0.5 : How to change the name of the writer of a topic
update xxx_kunena_messages set name = 'newname' where name = 'oldname'

update xxx_kunena_topics set first_post_guest_name = 'newname' where first_post_guest_name = 'oldname'

update xxx_kunena_topics set last_post_guest_name = 'newname' where last_post_guest_name = 'oldname'
www.scrollsawprojects.net

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #169122 by sozzled
Replied by sozzled on topic K 3.0.5 : How to change the name of the writer of a topic

WolfgangOWL wrote:

Code:
update xxx_kunena_messages set name = 'newname' where name = 'oldname' update xxx_kunena_topics set first_post_guest_name = 'newname' where first_post_guest_name = 'oldname' update xxx_kunena_topics set last_post_guest_name = 'newname' where last_post_guest_name = 'oldname'

I would be very careful about using this technique. This will change all topics created by someone with a new name. The last thing we want is to destroy the data .
Blue Eagle vs. Crypsis reference guide
Read my blog and
[img

Please Log in or Create an account to join the conversation.

More
10 years 9 months ago #169149 by phiphi22
Replied by phiphi22 on topic K 3.0.5 : How to change the name of the writer of a topic
Thank you very much sozzled and WolfgangOWL for your answer.

It works very well : changing one post with sozzled method.
I keep the method of WolfgangOWL for massive change.

Philippe

Please Log in or Create an account to join the conversation.

Time to create page: 0.275 seconds