[thelaw]

Apologies on the late reply everyone. I’m using 3.1, latest version (for if you’re not, it’s like WordPress and you will get hacker bots scanning for old versions.) Unfortunately that seems to be the issue. Thanks @Brandon and @Stephen for your assistance. Table prefixes were properly used. I’ll have another go at it again but I’m pretty sure I was using latest version of WP and BBpress in order to do the conversion.

[thelaw]

I’ve noticed that this topic is a year and change old but it concerns the phpbb importer. My brief review of the fields would seem to indicate that field names have changed and it’s why I have generated the errors below. There is no forum_topics field and the topics in phpbb3 have their own table and are assigned to a forum using topics.forum_id. I don’t know what the phpbb 2 database schema but apparently it is different.

Nick – were you ever able to get it to work or did you have to outsource the work? It would probably be a good idea for WordPress to let users know as to the compatibility of the converter with the version of phpBB currently able to be converted. Thanks for any insights.

Imported phpBB, where are the forums?

[thelaw]

Clicked: Purge all information from a previously attempted import
Use this if an import failed and you want to remove that incomplete data.

Tried to start again. That deleted all the replies. This seems to be the issue:

WordPress database error: [Unknown column ‘forums.forum_topics’ in ‘field list’]
SELECT convert(forums.forum_id USING “utf8mb4”) AS forum_id,convert(forums.parent_id USING “utf8mb4”) AS parent_id,convert(forums.forum_topics USING “utf8mb4”) AS forum_topics,convert(forums.forum_posts USING “utf8mb4”) AS forum_posts,convert(forums.forum_topics_real USING “utf8mb4”) AS forum_topics_real,convert(forums.forum_name USING “utf8mb4”) AS forum_name,convert(forums.forum_desc USING “utf8mb4”) AS forum_desc,convert(forums.left_id USING “utf8mb4”) AS left_id,convert(forums.forum_type USING “utf8mb4”) AS forum_type,convert(forums.forum_status USING “utf8mb4”) AS forum_status FROM phpbb_forums AS forums LIMIT 0, 100

If we’re talking about the phpbb database, this is because forum_topics doesn’t exist in the phpbb datatabase. Perhaps it did in version 2 but I don’t see that being the case in version 3. As a result, I’m wondering if anyone has successfully converted any phpbb 3 forums.

[thelaw]

Constant errors. No users to convert. No forums to convert. Kicks me into repair but nothing to repair. Ran it again and got:

WordPress database error: [Unknown column ‘topics.topic_replies’ in ‘field list’]

SELECT convert(topics.topic_id USING “utf8mb4”) AS topic_id,convert(topics.topic_replies USING “utf8mb4”) AS topic_replies,convert(topics.topic_replies_real USING “utf8mb4”) AS topic_replies_real,convert(topics.forum_id USING “utf8mb4”) AS forum_id,convert(topics.topic_poster USING “utf8mb4”) AS topic_poster,convert(posts.poster_ip USING “utf8mb4”) AS poster_ip,convert(posts.post_text USING “utf8mb4”) AS post_text,convert(topics.topic_title USING “utf8mb4”) AS topic_title,convert(topics.topic_status USING “utf8mb4”) AS topic_status,convert(topics.topic_type USING “utf8mb4”) AS topic_type,convert(topics.topic_time USING “utf8mb4”) AS topic_time,convert(topics.topic_last_post_time USING “utf8mb4”) AS topic_last_post_time FROM phpbb_topics AS topics INNER JOIN phpbb_posts AS posts USING (topic_id) WHERE posts.post_id = topics.topic_first_post_id LIMIT 0, 100

No topics to convert

No forum parents to convert

[thelaw]

So I look at the database and the importer imported all replies, no forums and no topics, leaving us with about 7,000 replies without a forum or a topic. This is not optimal to say the least. Does the phpBB importer still work?

[thelaw]

Ken – how were you able to solve this? I’ve got the same problem with current genesis themes.