Skip to:

Error while attempting to migrate from phpbb

  • estefa37


    Hello everyone.
    I am looking for some help here.
    I am trying to migrate a rather large forum from phpbb to bbpress using the bbpress importer.
    I filled the details with the right database information and started the import.
    However, it keeps showing me an error and does not let me import anything.
    When I click on “start” the import, it inmediately shows this text:

    Repair any missing information: Continue
    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 phpbbli_topics AS topics INNER JOIN phpbbli_posts AS posts USING (topic_id) WHERE posts.post_id = topics.topic_first_post_id LIMIT 0, 100
    No topics to convertNo forum parents to convert

    It only shows that text and does not import anything. All user accounts are existing inside my phpbb database.

    Does anyone know why this is happening or how can I solve this in order to make the import?

    Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)

  • heroyouwi


    its all about your phpBB version, i have like your issue before edited the script converter 🙂

    mine is phpbb 3.2.9, i mapped the corrent column in the script convert : phpBB.php
    i have a heavy phpbb forum : 16 forums, 3000 topics, 95000 posts, 3000 users, all successfully imported in bbpress 2.5
    here my fix :

    phpbb 3.2.9 fix bbpress import

    enjoy it



    you can use this code :
    class phpBB extends BBP_Converter_Base {

    * Main Constructor
    public function __construct() {

    * Sets up the field mappings
    public function setup_globals() {

    // Setup smiley URL & path
    $this->bbcode_parser_properties = array(
    ‘smiley_url’ => false,
    ‘smiley_dir’ => false

    /** Forum Section *****************************************************/

    // Old forum id (Stored in postmeta)
    $this->field_map[] = array(
    ‘from_tablename’ => ‘forums’,
    ‘from_fieldname’ => ‘forum_id’,
    ‘to_type’ => ‘forum’,
    ‘to_fieldname’ => ‘_bbp_old_forum_id’

    // Forum parent id (If no parent, then 0, Stored in postmeta)
    $this->field_map[] = array(
    ‘from_tablename’ => ‘forums’,
    ‘from_fieldname’ => ‘parent_id’,
    ‘to_type’ => ‘forum’,
    ‘to_fieldname’ => ‘_bbp_old_forum_parent_id’

    // Forum topic count (Stored in postmeta)
    $this->field_map[] = array(
    ‘from_tablename’ => ‘forums’,
    ‘from_fieldname’ => ‘forum_topics’,
    ‘to_type’ => ‘forum’,
    ‘to_fieldname’ => ‘_bbp_topic_count’

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.
Skip to toolbar