×
Blue Eagle (1.5.0) for K5.1 is released (20 Jul 2018)

Please update the Kunena Blue Eagle to 1.5.0 if you use Kunena 5.1.
We made several bug fixes and improvements. Also Blue Eagle has now all the features from Crypsis.
Download: www.kunena.org/download/templates/category/blue-eagle-5

Question Change date of forum posts

More
1 year 10 months ago - 1 year 10 months 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: 1 year 10 months ago by pintobuck.

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

More
1 year 10 months 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 add attachements.
  • Not Allowed: to edit your message.
Time to create page: 0.076 seconds