×
Kunena 5.2 RC3 Released (29 Nov 2020)

The Kunena team is thrilled to announce the third public release candidate 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 RC3 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.

× This is for users to help other users, to discuss topics that relate to migrating from other web-based forums and converting the data into a form that will operate with Kunena.

It is important to note that the Kunena team does not have a standard, recommended or supported protocol for these ideas and that posting questions in this category may not receive advice from team members.

Solved wrong dates on posts and topics after migrating cccboard to kunena 5

More
3 years 4 months ago - 3 years 4 months ago #1 by ziso
Dear support i have manage to migrate joomla 1.5 and ccboard 1.3 to a joomla 2.5 site after upgrading the joomla 1.5 to kunena 2 and using the joomla 2.5 importer plugin to import all my users and posts to it. After this i upgrade again to joomla 3 and kunena 5 successfully without issues.

My problem is that all my imported posts have wrong dates.

Example
In joomla 1.5 ccboard a topic with creation date 21-07-2017 07:27:48 when migrated
in joomla 2.5 kunena 2 ~ 5.0.10 i get the same topic and post with this date! 17 may 2018 08:27 almost one year later!

Notice that new created topic posts and answers take the correct dates in kunena 2~5.

Ccboard has a field for time format in configuration page and has this settings inside its field for setting the dates on post and topics %d-%m-%Y %H:%M:%S
maybe if we change this to something that fits kunena better, the importer could parse the correct dates in kunena 2? any idea to fix this?
Last edit: 3 years 4 months ago by ziso.

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

More
3 years 4 months ago #2 by rich
Setting for Message Time Format has also Kunena (Configuration -> tab Frontend).
Try in backend the option "Kunena -> Tools -> Recount Statistics". But I've no idea if it help.

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

More
3 years 4 months ago #3 by ziso
i did it an did nothing.. i believe there must be an issue on importer it uses timedelta settings on importing data! i believe there is something with unix time to do? and when it convert dates it adds more data on them is this possible? there is a code in /adminstrator/components/com_kunenaimporter/models/import.php

$message->time += $this->timedelta;
if ($message->modified_time) {
$message->modified_time += $this->timedelta;


i have 30.000 post and want to use kunena if someone has a solution please help.

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

More
3 years 4 months ago #4 by ziso
so original dates are converted in kunena to timestamp format

the difference of posts

14/05/2018 14:14 with timestamp 1526307254

2017-07-18 12:14 with timestamp 1500380040

300 days, 2 hours, 0 minutes and 14 seconds. difference -25927214

What syntax must i use as mysql query so that i can execute it in myphpadmin to alter the values of the time fields by - 25927214?

any ideas?

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

More
3 years 4 months ago #5 by ziso
UPDATE izlt_kunena_messages SET time = time -25927214 fixed it...

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

More
3 years 3 months ago - 3 years 1 month ago #6 by SABRINA113
This nice and useful info for me. Thanks a lot
Last edit: 3 years 1 month ago by SABRINA113.

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.089 seconds