[@milliways2650 Participant 8 years, 3 months ago]

Ignore the previous post!

Despite my despair above I decided to give it another shot.

I tidied up my phpbb board, deleting a lot of old Admin logs and did a fresh export.
I recreated the SQL database.

This time it seemed to work.

[@milliways2650 Participant 8 years, 3 months ago]

Thank you for your help. Unfortunately I think I have reached a dead end.

I decided to give another try. I created a new phpbb database, and a new WordPress installation, just in case I had caused some damage.

Attempting the import produced the following error. Presumably it is objecting to something in my phpbb database. I can not find ‘forum_topics_approved’ anywhere (but have little experience with MySQL).

WordPress database error: [Unknown column ‘forums.forum_topics_approved’ 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_approved USING “utf8mb4”) AS forum_topics_approved,convert(forums.forum_posts_approved USING “utf8mb4”) AS forum_posts_approved,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

No forums to convert

Starting Conversion

My comment about lack of stats was that there was no positive feedback e.g. x forums imported, which would be helpful.

I did not understand the comment “If you also view the source of the page, right click and “inspect” will also bring this up, you should see some debug code showing the SQL queries being performed during the import:”

[@milliways2650 Participant 8 years, 3 months ago]

I installed 2.6 alpha, deleted all Forums and tried. It seemed to run, I ran “Repair Tools” but there seem to be no Forums. phpmyadmin a new table=wp_bbp_converter_translator but there is no sign of any other changes.

It is a pity the importer doesn’t seem to give any statistics about what it is reporting.

[@milliways2650 Participant 8 years, 3 months ago]

I am running phpBB 3.1.9 and bbPress 2.5.10

As I am still a relatively new WordPress user, and have never used bbPress, I installed the latest version, but I normally avoid alpha and beta software.

As this is an offline installation for learning/experimentation I guess there is no risk so will try 2.6

[@milliways2650 Participant 8 years, 3 months ago]

Yes, I definitely selected phpBB, and am using the most recent release.

[@milliways2650 Participant 8 years, 3 months ago]

I did run “Repair Tools” (although initially on only 1 item). I just repeated for all but I still see no new Forum.

I do have one empty Forum, I created manually earlier, but no sign of the import.

As an aside, many of the questions I am asked seem ambiguous, so I had tried many options. I assume this will become obvious, after you have been using it, like most programming.

[@milliways2650 Participant 8 years, 3 months ago]

I imported a sql backup of my database to my local system and phpMyAdmin shows this with 6 forums with prefix “phpbb_”

Database Server localhost
Database Name iabi1038_phpb1
Database User <myuser>
Table Prefix phpbb_

This chugs along, with no obvious errors, (but no real report of what it did) – although the “No forums to convert” error no longer appears.

Unfortunately I cannot seem to find the Forum in my WordPress installation.