error trying to import PHPBB

This discussion is related to the Vanilla Porter addon.

when I use the tool i get the following error message

The topics table is missing the following column(s): topic_replies

any help to fix this please

Comments

  • hgtonighthgtonight ∞ · New Moderator

    @Linc is maintaining this now.

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

  • LincLinc Director of Development Detroit Vanilla Staff

    I've actually handed it off to @initvector as of February. :)

    hgtonight
  • Im getting the same thing, any ideas?

  • LincLinc Director of Development Detroit Vanilla Staff

    What version of phpBB are you two using?

  • initvectorinitvector Vanilla Staff

    It looks like topic_replies is a required field in the phpbb2 and phpbb3 packages, but I only see references to it in the phpbb3 package.

    I'm assuming you guys are using phpBB 2.*. Can you confirm?

    In the meantime, I've nuked topic_replies as a requirement from the phpBB2 package.

    Cruel_Coppinger
  • Hi

    Thanks for posting:

    I have latest phpBB3 ( 3.1.4)

    Ive done a full reset of my forum so its back to a vanilla install (no pun intended), no mods etc

    The database is MySQL 5.5.42-cll

    my site : www.pc-forums.co.uk

  • LincLinc Director of Development Detroit Vanilla Staff

    @Cruel_Coppinger Do you recall what version you started on? Maybe 3.1?

    Cruel_Coppinger
  • Hi Linc

    It was probably before that, I think I set the site up on or around 2008/9 which according to wikipeadia is on the cusp of moving from v2.X to v3.X

  • Hi, any suggestions to help me get the conversion tool working. Im really keen to move our community over Vanilla but this is a major roadblock.

  • hgtonighthgtonight ∞ · New Moderator

    @Cruel_Coppinger did you try the latest version @initvector updated here: https://github.com/vanilla/porter ?

    Search first

    Check out the Documentation! We are always looking for new content and pull requests.

    Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.

    Cruel_Coppinger
  • thanks, I'll try it out now and report back

  • me again

    I download the latest release from github

    uploaded it to a writeable folder

    Navigated to /porter-master and ran make.php

    This generated the valline2export.php file

    I then loaded this up in my browser http://pc-forums.co.uk/porter-master/vanilla2export.php?

    but unfortunately Im still getting the same error

    "The topics table is missing the following column(s): topic_replies"

  • initvectorinitvector Vanilla Staff

    After digging into this a little more, it does appear phpBB 3.1 dropped the topic_replies column from the topics table.

    I'll see what I can do about updating the phpBB 3 package to remove dependency on that column.

  • initvectorinitvector Vanilla Staff

    I've created a branch in the Porter repo for addressing this (and potentially other) phpBB 3.1 compatibility issues. You can find it here: https://github.com/vanilla/porter/tree/hotfix/phpbb31

    When you can, please use the latest version there to attempt your migration and let me know if you still have issues.

    Note: Removing topic_replies means CountComments in the discussion table will be regenerated towards the end of the import process. Please make sure this number is accurate.

    hgtonight
  • Ive managed to sort it. The updated porter work

    Thanks for all your help

    hgtonight
  • LincLinc Director of Development Detroit Vanilla Staff

    2.2 is now released with this fix.

Sign In or Register to comment.