[richard.wil]

Ive finally had some progress!!!! Finally getting something in the status box other than the ‘starting conversion’ lol

I ended up installing another instance of wordpress in an old version: 3.9 and then installed bbpress plugin old version: 2.5.4

Then when I did the import from the phpbb3 forums I had the import actually start! I think it must have been some compatibility issues on newer versions.

However I did run into a fair few errors. I got a few errors where I had to click start conversion again and then it would get another error and have to click start again.

It finally finishes but seems to have only imported replies and there are no forums or topics and the user accounts don’t import either.

Wondering if anyone might know why and if anyone can decipher the output I get below?
Any help would be greatly appreciated

———————————————————————-

Repair any missing information: Continue

Conversion Complete

No reply_to parents to convert

Converting replies (1200 – 1299)
Converting replies (1100 – 1199)
Converting replies (1000 – 1099)
Converting replies (900 – 999)
Converting replies (800 – 899)
Converting replies (700 – 799)
Converting replies (600 – 699)
Converting replies (500 – 599)
Converting replies (400 – 499)
Converting replies (300 – 399)
Converting replies (200 – 299)
Converting replies (100 – 199)
Converting replies (0 – 99)

No tags to convert

No super stickies to stick

No stickies to stick

Starting Conversion

Repair any missing information: Continue
WordPress database error: [Unknown column ‘topics.topic_replies’ in ‘field list’]
SELECT convert(topics.topic_id USING “utf8”) AS topic_id,convert(topics.topic_replies USING “utf8”) AS topic_replies,convert(topics.topic_replies_real USING “utf8”) AS topic_replies_real,convert(topics.forum_id USING “utf8”) AS forum_id,convert(topics.topic_poster USING “utf8”) AS topic_poster,convert(posts.poster_ip USING “utf8”) AS poster_ip,convert(posts.post_text USING “utf8”) AS post_text,convert(topics.topic_title USING “utf8”) AS topic_title,convert(topics.topic_status USING “utf8”) AS topic_status,convert(topics.topic_type USING “utf8”) AS topic_type,convert(topics.topic_time USING “utf8”) AS topic_time,convert(topics.topic_last_post_time USING “utf8”) 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

Starting Conversion

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

No forums to convert

No passwords to clear

Starting Conversion

Repair any missing information: Continue
WordPress database error: [Unknown column ‘users.user_website’ in ‘field list’]
SELECT convert(users.user_id USING “utf8”) AS user_id,convert(users.user_password USING “utf8”) AS user_password,convert(users.user_form_salt USING “utf8”) AS user_form_salt,convert(users.username USING “utf8”) AS username,convert(users.user_email USING “utf8”) AS user_email,convert(users.user_website USING “utf8”) AS user_website,convert(users.user_regdate USING “utf8”) AS user_regdate,convert(users.user_aim USING “utf8”) AS user_aim,convert(users.user_yim USING “utf8”) AS user_yim,convert(users.user_icq USING “utf8”) AS user_icq,convert(users.user_msnm USING “utf8”) AS user_msnm,convert(users.user_jabber USING “utf8”) AS user_jabber,convert(users.user_occ USING “utf8”) AS user_occ,convert(users.user_interests USING “utf8”) AS user_interests,convert(users.user_sig USING “utf8”) AS user_sig,convert(users.user_from USING “utf8”) AS user_from,convert(users.user_avatar USING “utf8”) AS user_avatar FROM phpbb_users AS users LIMIT 0, 100

No users to convert

Starting Conversion

[richard.wil]

Thanks.
Just did these tests and I still get the ‘starting conversion’ but no error. It just keeps spinning.

[richard.wil]

Thanks for your reply.
Yes, definitely selecting phpBB from the drop-down at the top of the page.
Both the wordpress and phpbb3 databases are on the same web server. I enter in ‘localhost’ to connect to them both

[richard.wil]

Thanks for the advice
I have tried following the above troubleshooting steps but it seems to be running into an issue right at the very start, it seems to not even start importing at all. So if I click stop it just stops and doesn’t show me any info on what it had imported, where it got up to. Should it display the detail in the import status window on the page? I also can’t see any topics, posts in the database or in the bbpress forum. Makes me think that it doesn’t even start the import process. Maybe it is getting stuck at the connecting to the database part of the process?
I can’t seem to see any other details or messages other than ‘starting conversion’ and the little circle status symbol spinning.
Where should I be looking to see more detail on what rows it is working on etc?

[richard.wil]

Ive recently tried installing version 2.5.7 bbpress and phpbb 3.0.14 but am still stuck.
Ive also tried moving the data to another database on the same server
Anyone know anything else I can try?
How can I see where this thing is getting stuck? Is there any logs i can be checking?
All I can see is just “Starting Conversion” every single time 🙁
Its so frustrating….please help me im going crazy lol
TIA

[richard.wil]

I don’t think the current version of bbpress supports importing from phpbb 3.1
https://bbpress.trac.wordpress.org/ticket/2716

Thats more information that I am getting, where are you seeing that output?
Mine just sits on ‘starting conversion’ and never progress any further than that no matter how long I leave it.

[richard.wil]

Ive tried the steps on this page, however i get stuck right at the first one, as when I click stop it doesn’t tell me any information about what row it was up to. It just stops and says something like: conversion stopped.
Its as if it never starts the process at all. It seems like it is not getting any connection to the database/old forum

[richard.wil]

Thanks very much for your reply and for the info, do you know approximately when that release would likely be?

I have tried with various versions on phpbb and was getting the same error, so I thought it may have been that bbpress didn’t support 3.0.x so that’s why I actually updated. I can revert back my version.

However I have tried with the 3.0.14 and with earlier versions and was getting this same problem. The status just sits on “Starting Conversion” and never moves or gives me anymore information.

Would you know what this could be causing this or where I should be looking to find out what is stopping the process from starting?
(I left it run for 5 hours the other day)
I can convert back to the old version of phpbb if needed.

Thanks in advance.