Kunena 7.0.2 Released

The Kunena team has announce the arrival of Kunena 7.0.2 [K 7.0.2] in stable which is now available for download as a native Joomla extension for J! 5.3.x/5.4.x/6.0.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 7.0

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.

Idea phpBB 3 to Kunena 3 Migration Script

More
11 years 1 month ago #162182 by Marvin McDuck
Replied by Marvin McDuck on topic phpBB 3 to Kunena 3 Migration Script
Thanks! Hm...

1. OK... You mean turn on debugging mode and see what happens, and look at the code of Kunena directly? Or something else/ some other tool?
2. I've been working on my desktop with MAMP; I can try it directly on my webserver (hidden); but it didn't work there when I exported a non-working version to it, so I have little hope. Also, the forum must be slotted into a fully-functioning website -- take snapshot of old forum, convert and slot in fast-fast minimizing downtime, then all up&running. So if I need to make a naked forum and then piecemeal fit in other content that would be very very bad.

3. I've started on a freshly-downloaded Joomla 3.3.x, with only a language pack, akeeba backup and kunena in there. OK, I can eliminate the language to see if it matters.

The only think I could come up with now is creation dates: The posts (and users) are all from years before the joomla 3.x creation date... would that matter? And what should I postdate if it does --- SuperUser creation time? But the matching results that I get seem to be of the last year, over a full year (so well before my Joomla creation time) but not more. Eh?

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

More
11 years 1 month ago - 11 years 1 month ago #162198 by binod
Replied by binod on topic phpBB 3 to Kunena 3 Migration Script

1. OK... You mean turn on debugging mode and see what happens, and look at the code of Kunena directly? Or something else/ some other tool?


Right. Along with that, please find what is happening on this file:
Code:
/components/com_kunena/site/models/search.php

Here is the link to Kunena forum on GitHub

github.com/Kunena/Kunena-Forum/blob/deve...te/models/search.php

I am naturally interested in the function "buildWhere()":
Code:
protected function buildWhere() { $db = JFactory::getDBO (); $querystrings = array(); foreach ( $this->getSearchWords() as $searchword ) { $searchword = $db->escape ( JString::trim ( $searchword ) ); if (empty ( $searchword )) continue; $not = ''; $operator = ' OR '; if ( substr($searchword, 0, 1) == '-' && strlen($searchword) > 1 ) { $not = 'NOT'; $operator = 'AND'; $searchword = JString::substr ( $searchword, 1 ); } if (!$this->getState('query.titleonly')) { $querystrings [] = "(t.message {$not} LIKE '%{$searchword}%' {$operator} m.subject {$not} LIKE '%{$searchword}%')"; } else { $querystrings [] = "(m.subject {$not} LIKE '%{$searchword}%')"; } } //User searching $username = $this->getState('query.searchuser'); if ($username) { if ($this->getState('query.exactname') == '1') { $querystrings [] = "m.name LIKE '" . $db->escape ( $username ) . "'"; } else { $querystrings [] = "m.name LIKE '%" . $db->escape ( $username ) . "%'"; } } $time = 0; switch ($this->getState('query.searchdate')) { case 'lastvisit' : $time = KunenaFactory::GetSession()->lasttime; break; case 'all' : break; case '1' : case '7' : case '14' : case '30' : case '90' : case '180' : case '365' : $time = time () - 86400 * intval ( $this->getState('query.searchdate') ); //24*3600 break; default : $time = time () - 86400 * 365; } if ($time) { if ($this->getState('query.beforeafter') == 'after') { $querystrings [] = "m.time > '{$time}'"; } else { $querystrings [] = "m.time <= '{$time}'"; } } $topic_id = $this->getState('query.topic_id'); if ( $topic_id ) { $querystrings [] = "m.id = '{$topic_id}'"; } return implode ( ' AND ', $querystrings ); }

This makes me even more interested to see what $querystrings returns. I think that you are in the right direction.
Please follow my open source projects MixERP Project and phpBB to Kunena Migration Script on Github.
Last edit: 11 years 1 month ago by binod.

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

More
11 years 1 month ago #162201 by Marvin McDuck
Replied by Marvin McDuck on topic phpBB 3 to Kunena 3 Migration Script
I will see if I can figure anything out. I've re-tried without even language packs or backup, and search fails.

I'm now giving it another shot now via mysql:

I had been using spreadsheets (ODS) to do everything, because I'm working from a forum that's not working with `topics', but has a `comments' table with 63 columns; and it contains many glitches [responses with datetime before their parent; responses with another forum than their parent; responses (as seen from RE:Title that occurs elsewhere) that claim to have no parent; responses with ID before their parent, a few hundred users numbered from 2 to 50K...]. Did I mention it's been re-encoded between UTF8 and Latin1 at least twice, and many different accented letters have been added on top of each other? And the message-markup is very different from bbCode...

So to check the sanity of it all, it's been easiest in a spreadsheet (e.g., on what columns to sort to have least number of inconsistencies to manually sort). It's 4spreadsheets where the largest is only 4000x10 (or less) fields and less than a MB, yet taking 2min to open and 6--8min to save and occasionally crashing (and always crashing Excel when converted to .xlsx). When making the 'topics' (by sorting the 'messages' table) it's necessary not to have the message-contents or the whole thing crashes etc...

So now I'm cobbling together mysql statements that do what your script could do straightforwardly (as phpbb and kunena have more or less same structure to store topics and posts).

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

More
11 years 1 month ago #162204 by bulldogbear
Replied by bulldogbear on topic phpBB 3 to Kunena 3 Migration Script
Thank you very much for your script.

Even though I wasn't able to import the tables to my live web server, I was able to simply do table by table insert statements and was able to get all my phpbb3 info into kunena.

Thank you again for your help and the script!

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

More
11 years 1 month ago #162210 by binod
Replied by binod on topic phpBB 3 to Kunena 3 Migration Script
I am glad that you have finally been able to solve your problem.
Please follow my open source projects MixERP Project and phpBB to Kunena Migration Script on Github.

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

More
11 years 1 month ago #162213 by Marvin McDuck
Replied by Marvin McDuck on topic phpBB 3 to Kunena 3 Migration Script
Wait... Let me verify that I'm not being obtuse:

I. I'm populating 4 tables via phpmyadmin,
[1] jos_users (avoiding the SuperUser's ID),
[2] jos_kunena_messages,
[3] jos_kunena_messages_text, and
[4] jos_kunena_topics;
while [5] jos_kunena_categories I had already prepared from the Kunena backend.
II. Then just the Kunena Forumtools (a) synchronize jos_users to jos_kunena_users and (b) recount statistics populates the rest like jos_kunena_user_topics.

Don't tell me I'm overlooking something that the `recount statistics' doesn't do for me?
[I end up with all users in the 'registered' category, and have thrown away many recoverable things like avatars, images in posts, and private messages between users; but that's OK to the purpose.]

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

Time to create page: 0.299 seconds