I am trying to move my Joomla install over to WP, and am having some troubles with the Kunena importer to BBPress.

When I attempt to do the import, it successfully moves over some of the information, but stops every time when it tries to import the topics. It gives me the error:

WordPress database error: [Table ‘******.jos_kunena_topics’ doesn’t exist]

The problem is that I don’t use the jos_ prefix anywhere in my tables, and it seems to be automatically inserting that prefix into the table when trying to import. I imagine the table it’s looking for is not actually jos_kunena_topics, but rather just kunena_topics.

I am using Joomla 2.0.19 with Kunena 3.0.5, attempting to move over to the latest versions of both bbpress and WP.

Any help will be appreciated.

[@xxmesoxx Participant 9 years, 9 months ago]

Just an update on this…

In an attempt to solve the situation, I took my site offline and changed the prefix of kunena_topics to jos_ and figured that might be a work around. As it happened, instead I just got the error stating WordPress database error: [Table ‘******.j25_kunena_topics’ doesn’t exist]

So when I run it normally to use the j25_ prefix, it fails and looks for jos_, and when I change the table to jos_, it then fails and asks for j25_

[@xxmesoxx Participant 9 years, 9 months ago]

Wanted to avoid triple posting, but can’t seem to edit.

I have found the problem and managed to get the migration to work. Within the Kunena3.php file, there is a single line with a hardcoded jos_ prefix in it. I changed that to my dbs table prefix and the issue was solved.

[@robin-w Moderator 9 years, 9 months ago]

Great – glad you’re fixed, and thanks for posting how you did this