Cool, glad your taking a look at it.
“It seems to have appended an extre Re: in front of each (so they read Re:Re:Topic)”
The Re: should only be added to the title of a reply, this should not be adding them to the topics and this shows that the SQL in the importer isn’t quite matching up with your database.
The SQL queries below are based on the Kunena1.php importer and use the prefix jos_ as the table prefix for the bbPress importer.
When the importer fails you should see an error message like the following:
WordPress database error: [Unknown column 'kunena_categories.locked1' in 'field list']
In this particular case the importer was looking for jos_kunena_categories.locked1 where jos_kunena_categories is the table name and locked1 is the field name. I used ‘locked1’ as a way to force an error to show the example, so if I knew my version of the database should be looking at the field locked instead of locked1 you can find the 'from_fieldname' => 'locked1' in Kunena1.php and update that with the correct field mapping 'from_fieldname' => 'locked',.
Another way you can go about this is to jump directly into phpMyAdmin and test each of the following SQL queries, there are primarily four queries are as follows:
Again I used prefix jos_ for my database and you will need to change this to match your own database table prefix.
Forums
SELECT
kunena_categories.id AS id,
kunena_categories.parent AS parent,
kunena_categories.numTopics AS numTopics,
kunena_categories.numPosts AS numPosts,
kunena_categories.name AS name,
kunena_categories.description AS description,
kunena_categories.ordering AS ordering,
kunena_categories.locked AS locked
FROM jos_kunena_categories AS kunena_categories
Topics
SELECT
kunena_messages.thread AS thread,
kunena_messages.catid AS catid,
kunena_messages.userid AS userid,
kunena_messages.ip AS ip,
kunena_messages_text.message AS message,
kunena_messages.subject AS subject,
kunena_messages.time AS time,
kunena_messages.locked AS locked
FROM jos_kunena_messages AS kunena_messages
INNER JOIN jos_kunena_messages_text AS kunena_messages_text
ON kunena_messages_text.mesid = kunena_messages.id
WHERE kunena_messages.parent = 0
Replies
SELECT
kunena_messages.id AS id,
kunena_messages.catid AS catid,
kunena_messages.thread AS thread,
kunena_messages.ip AS ip,
kunena_messages.userid AS userid,
kunena_messages.subject AS subject,
kunena_messages_text.message AS message,
kunena_messages.time AS time
FROM jos_kunena_messages AS kunena_messages
INNER JOIN jos_kunena_messages_text AS kunena_messages_text
ON kunena_messages.id = kunena_messages_text.mesid
WHERE kunena_messages.parent != 0
Users
SELECT
users.id AS id,
users.password AS password,
users.username AS username,
users.email AS email,
users.registerDate AS registerDate
FROM jos_users AS users
That’s a bit to digest so I’ll leave it at that for now and it is probably as clear as mud unless you are a seasoned SQL junkie.
If anything I wrote above doesn’t make sense just ask away and remember 🙂
https://en.wikipedia.org/wiki/No_such_thing_as_a_stupid_question
