Error from converting from phpbb3 to smf 2.0

[anwoke8204]

Hi I am trying to convert, and when I run convert.php I get the following error?


Converting groups...
Unsuccessful!
This query:

    SELECT
    SUBSTRING(CONCAT('phpBB ', group_name), 1, 255) AS group_name,
    -1 AS min_posts, '' AS stars, '' AS online_color
    FROM `anwokesblog`.phpbb_groups
    WHERE group_single_user = 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'group_single_user' in 'where clause'

I have clicked the try again, and I keep getting the same error.  How can I resolve this?

many thanks

[ThorstenE]

I believe you used the wrong converter (phpbb2 converter instead of phpBB3).. this one should work:
http://www.simplemachines.org/community/index.php?topic=218449.0

[anwoke8204]

I tried both for phpbb2 and phpbb3, I believe I am using phpbb3 as the template I am using is a phpbb3 template?

[ThorstenE]

You should delete the phpbb2_to_smf.sql from your server and try it again... If this doesn't help there is something wrong with your phpBB database (missing column ->  table is phpbb_groups).