×
Kunena 5.2 Beta 1 Released (24 Sep 2020)

The Kunena team is thrilled to announce the first public beta release of Kunena 5.2, a native Joomla extension for Joomla 3.9. This is a development release and should be only be used for testing; this version is not recommended for live websites at this stage.

The purpose of this release is to encourage testing by downloading, installing and identifying any problems or shortcomings that people may discover. K 5.2.0 B1 is stable and we are aware that people will discover defects. We encourage you to use the forum to report defects, as soon as they are discovered, so that the development team can work through the problems before the release of K 5.1 as a stable product. Reporting defects does not mean that the problems can or will be fixed. The Kunena team is looking forward to hearing your feedback on how well we have achieved our design goals.

Question Change date of forum posts

More
4 years 1 month ago - 4 years 1 month ago #1 by pintobuck
Using Joomla 3.6 and Kunena 5.

Some of my forum content, which I had created, migrated from an old website. The content was interesting and as current as ever, except that it carried very old posting dates from the old website. Hence, I wanted to change the posting dates in Kunena forum.

I found the solution in an archived thread , which would not allow me to post new info, say thank you, or help other people with this issue. So, I renewed the issue in this thread.

Method that worked for me:
1) Forum posts are date and time stamped in mysql tbl_Kunena_messages.
2) The timestamp is a long number, which you can convert to human dates via on-line tools, such as Epoch Converter
3) Back to your mysql tbl_kunena_message, look for the time column.
4) You can change the date or year by changing that number, using the Epoch Converter as your guide.
5) You can do mass changes using a Joomla Extension called DB Replacer by RegularLabs.com.
6) For example, I updated a lot of old years to a more current year, and left the rest of the timestamp unchanged.
7) In Joomla backend, Kunena Tools, recalculate the Statistics, and the new posting date will show on the front end.
Last edit: 4 years 1 month ago by pintobuck.

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

More
4 years 1 month ago #2 by 810
Replied by 810 on topic Change date of forum posts
Looks like you topic has been closed or locked.

What is the error message when you say thank you

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.086 seconds