problem with converting

[hetrp]

I ran into problem while I was trying to convert my old forum to smf the error say

Converting ranks... Unsuccessful!
This query:

    DELETE FROM `wc3tgar0_smf`.smf_membergroups
    WHERE groupName LIKE 'phpBB %';

Caused the error:

    Unknown column 'groupName' in 'where clause'

Please help I have 800+ user I need to get them back!


and I also deleted smf_membergroups or some thing so now I cant get the forums to log me in.

Please help any help will be appreciated.

[ThorstenE]

I believe you used the wrong converter files (SMF 1.1.x instead of SMF 2.0)..  please check our downloads page for SMF 2.0 RC1.2 files:
http://www.simplemachines.org/download/?converters

[hetrp]

I still get same error I guess

Converting ranks... Unsuccessful!
This query:

    DELETE FROM `wc3tgar0_smf`.smf_membergroups
    WHERE groupName LIKE 'phpBB %';

Caused the error:

    Unknown column 'groupName' in 'where clause'

[hetrp]

Now that I reinstalled the smf again its giving me new error please help me i'm about to pull my hairs off.

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyPHP Forum 3.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: Table 'wc3tgar0_wc3forums.member' doesn't exist

[ThorstenE]

are you sure the name of your database is right?
wc3tgar0_wc3forums.member
Which version of phpBB are you trying to convert?

[hetrp]

Well not really sure which version of phpBB I had (I know I should have checked it before I went to smf but I was so dumb ) Well any was I went into my phpMyadmin and as I see it I see table name phpbb_users under directory name wc3tgar0_wc3forums do you think you can still help tho?

[ThorstenE]

can you post a screenshot from phpMyAdmin (structure from your database)?

[hetrp]

Sure I guess this is what you are looking for ? If not please let me know.

[ThorstenE]

I belive this is a phpBB2, but I'm not 100% sure..

For SMF 1.1.x use this converter please:
http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-10_phpbb2_converter.zip
For SMF 2.0 RC:
http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc1-2_phpbb2_converter.zip

[hetrp]

I think I have same error do you think its permission problem ? if so how can I change the permission ? can you tell me step by step ?

[ThorstenE]

are you sure you have uploaded the new converter files?

your previous error is related to a table named "wc3tgar0_wc3forums.member".. our phpBB converter doesn't check for a table named "member".. the expected table is named"users" (same as from your screenshot).

[hetrp]

Yes i'm 100 % sure I did use new files that you give me I have the latest SMF and still wont do me right any way here is the error message again

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyPHP Forum 3.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: Table 'wc3tgar0_wc3forums.member' doesn't exist

[ThorstenE]

mhh, can you please check via FTP:
is there a file named myphp_to_smf.sql? if the answer is "YES" please remove this file and re-run convert.php

[hetrp]

I had that file on my server and after I delete here is what it told me


Which software are you using?
The converter did not find any conversion data files. Please check to see if the one you want is available for download at www.simplemachines.org. If it isn't, we may be able to write one for you - just ask us!
After you download it, simply upload it into the same folder as this convert.php file. If you're having any other problems with this converter, don't hesitate to look for help on our forum.

Try again

[ThorstenE]

please use the attached file
phpbb2_to_smf.sql for SMF 1.1.x
smf2phpbb2_to_smf.sql for SMF 2.0 RC

[hetrp]

hmmm some new error

Converting ranks... Unsuccessful!
This query:

    DELETE FROM `wc3tgar0_smf`.smf_membergroups
    WHERE groupName LIKE 'phpBB %';

Caused the error:

    Unknown column 'groupName' in 'where clause'

[hetrp]

Hey it worked I think the smf to phpbb file did do all the work but now it removed my admin and even my new user name from smf any way I can go back and add me as admin ?

[ThorstenE]

no problem, this should help:
I accidentally deleted my admin account, what do I do?

[hetrp]

Thank you so much for your help...