phpBB converter working with smf v1.1?

[davo88]

I'd like to convert a forum from phpBB v2.0.16 to smf v1.1 beta 3.

Does the phpBB converter on the download page support smf v1.1 ?

[Grudge]

Please use the attached converter. Put both files in your SMF directory and run convert.php - that should work.

[davo88]

Thank you. I'll try it out.

[gmflie]

Hi,

i fixed some minor things (some missing "then"s) and the script says "conversion successful", but nothing ist converted.

Anything new on conversion from phpbb to smf1.1 beta?

greetings

[TriGrrrl]

Thought I'd share my experience:

I started out with the wrong (old) converter that I had pulled from the download section, but found this thread and the right converter.

On my first attempt with the new converter, I got
--- Converting poll questions...  success
--- Converting polls options...    success
--- Converting polls options...

and then a mysql error complaining of a duplicate key  (sorry, I am reporting this from memory and don't have the exact text available)

I ran some select statements on the phpbb database to see if I could find the offending record, to no avail.  Then I thought I'd modify the sql script to make it throw out duplicates.  My basic SQL knowledge is not bad, but it wasn't good enough to figure out where in the script to do this.

Then, I found the debug switch for the converter script.  I was just hoping to get a better clue of where I had data issues, but the debug mode successfully brought all my data over!   I'm guessing  debug mode just keeps going even if there are errors.

It must have worked because all of my post counts, member counts, and a precursory glance at some of the polls seem to be correct.  None of my users have complained of anything after it's been running for three days.

The users really love the new forum!


TG


Edit:
Whoops, I forgot to mention that my "watched forums" data (phpbb_forums_watch table) did not come over from phpBB either.  But I was expecting that, since watching forums is done via mod on phpBB, it is not built in.  It was very simple to dump the data, change some field names, and import it into smf_log_notify.

[[Unknown]]

I'm glad it worked for you.. but, just as a warning, debug mode does... nothing.  It runs the SELECT queries but doesn't run any INSERT or etc. queries.

Still, if it got that far you were basically done anyway.

-[Unknown]

[Disaster123]

I also try to move from phpBB2 to smf. So i downloaded the atached Files - but I get an error:
This query:
SELECT
forum_id AS ID_BOARD, forum_order AS boardOrder, forum_posts AS numPosts,
forum_last_post_id AS ID_LAST_MSG, forum_name AS name, cat_id AS ID_CAT,
forum_desc AS description, forum_topics AS numTopics,
CASE auth_read
WHEN 0 THEN '-1,0,2'
WHEN 1 THEN '0,2'
WHEN 3 THEN '2'
WHEN 5 ELSE ''
END AS memberGroups
FROM `usrdb_proficb62`.phpbb_forums
LIMIT 0, 500;
Caused the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ELSE ''
END AS memberGroups
FROM `usrdb_proficb62`.phpbb_forums

[[Unknown]]

Are you certain you're using the latest version?

http://www.simplemachines.org/community/index.php?action=dlattach;topic=38966.0;attach=8585

-[Unknown]

[jsdoyle]

I'm having the same problem as Disaster123.  I'm trying to convert a phpBB install (v 2.017) to smf 1.1 b3.

I get:

Unsuccessful!
This query:

    SELECT
    forum_id AS ID_BOARD, forum_order AS boardOrder, forum_posts AS numPosts,
    forum_last_post_id AS ID_LAST_MSG, forum_name AS name, cat_id AS ID_CAT,
    forum_desc AS description, forum_topics AS numTopics,
    CASE auth_read
    WHEN 0 THEN '-1,0,2'
    WHEN 1 THEN '0,2'
    WHEN 3 THEN '2'
    WHEN 5 ELSE ' '
    END AS memberGroups
    FROM `phpBB`.phpbb_forums
    LIMIT 0, 500;

Caused the error:

    You have an error in your SQL syntax near 'ELSE ' '
    END AS memberGroups
    FROM `phpBB`.phpbb_forums
    LIMIT 0, 500' at line 9

Anyone have a clue?  I'm using what I beleive to be the latest convert files and installing to a fresh install of SMF 1.1b3.

Thanks,

Scott

[[Unknown]]

Try downloading the file from this topic again:

http://www.simplemachines.org/community/index.php?topic=38966.0

-[Unknown]

[jsdoyle]

Thanks, I did just that last night and started getting another error in the second section that converted the poll options.  I was getting a duplicate value error.

I couldn't get around that so just to see what would happen I removed that section from the conversion script.  My phpbb forum converted then with no errors received.  I knew it wouldn't be right but I did it just to see what would happen.

My SMF 1.1B3 board now looks great but the converted polls can't be voted in.  No surprise there.

My other issues are that non of my members avatars are attached to their profiles.  They converted and are listed but they just aren't associated with the members.

Also, none of my attachments  converted over.  They simply aren't listed in the attachment manager nor in the attachments database table.

Those are the biggies.  All categories, forums, topics, replies, membergroups, and members converted fine!

I sure would like to get the attachments and avatars working properly!  Any ideas?

Scott

[[Unknown]]

Were you using the standard (most common) file attachment mod for phpBB?

Please try the attached (to make sure you're using the latest.)

-[Unknown]

[jsdoyle]

Downloaded the two files, ran convert.php and got the following error:

Converting...
Converting ranks...Successful.
Converting groups...Successful.
Converting members...Successful.
Converting additional member groups...Successful.
Converting categories...Successful.
Converting boards...Successful.
Converting topics...Successful.
Converting posts (this may take some time)...Successful.
Converting polls...Successful.
Converting poll options...Successful.
Converting poll votes... Unsuccessful!
This query:
SELECT vote_id AS ID_POLL, vote_user_id AS ID_MEMBER
FROM `phpBB`.phpbb_vote_voters
WHERE vote_user_id > 0
GROUP BY vote_id, vote_option_id
LIMIT 0, 500;
Caused the error:

Unknown column 'vote_option_id' in 'group statement'

Alot left to do.

Any ideas?

About the attachment manager I have installed it is a basic install.  Nothing fancy.  phpBB version 2.0.17 and Attachment Mod version 2.3.9

Thanks!

[[Unknown]]

Sorry, that was a typo I made in the most recent version trying to fix someone else's issue with a somewhat corrupt database.  I reuploaded it here....

Try the attached, please.

-[Unknown]

[jsdoyle]

Thanks for the latest file.  This one ran and completed without any errors.  But.. no attachments converted.  It said they did but when I go to my smf 1.1 install there are none.

I'm working on the other install using smf 1.05.  See my other posts related to those errors too.

Thanks,

Scott

[[Unknown]]

Remember, you have to log in to see attachments.  Do you see them in the attachments manager?  Are you using the default theme?

-[Unknown]

[jsdoyle]

yes I'm logged in and there are no attachments listed in the attachment manager and no avatars.

Scott

[[Unknown]]

Try these files.

-[Unknown]

[jsdoyle]

Here's what was returned by the conversion script

Converting...
Converting posts (this may take some time)... Successful.
Converting polls...Successful.
Converting poll options...Successful.
Converting poll votes...Successful.
Converting personal messages (step 1)...Successful.
Converting personal messages (step 2)...Successful.
Converting topic notifications...Successful.
Converting board access...Successful.
Converting group access...Successful.
Converting moderators...Successful.
Converting avatar gallery images...Successful.
Converting censored words...Successful.
Converting reserved names...Successful.
Converting banned users...Successful.
Converting settings... Error in convert script phpbb2_to_smf.sql on line 832!
Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Successful.

No attachments or avatars.

Thanks though!

Scott

[[Unknown]]

Strange... does this one say anything illuminating?

-[Unknown]

[jsdoyle]

Here's this one...

Converting...
Converting ranks...Successful.
Converting groups...Successful.
Converting members...Successful.
Converting additional member groups...Successful.
Converting categories...Successful.
Converting boards...Successful.
Converting topics...Successful.
Converting posts (this may take some time)...Successful.
Converting polls...Successful.
Converting poll options...Successful.
Converting poll votes...Successful.
Converting personal messages (step 1)...Successful.
Converting personal messages (step 2)...Successful.
Converting topic notifications...Successful.
Converting board access...Successful.
Converting group access...Successful.
Converting moderators...Successful.
Converting avatar gallery images...Successful.
Converting censored words...Successful.
Converting reserved names...Successful.
Converting banned users...Successful.
Converting settings...Successful.
Converting attachment mod (if installed)...
Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.

Skipping file, could not stat.
Successful.
Recalculating forum statistics... Successful.

Conversion Complete
Congratulations, the conversion has completed sucessfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.

No attachments.  There are about 30 avatars this time.  Mine's not one of them!

[[Unknown]]

Okay, try this one.

-[Unknown]

[jsdoyle]

Okay, that looks like it did it!  Attachments are there and most of the avatars are there.  I still don't see my avatar but that's no problem.

Good job on the converter!

Now I wish I had a fix for the 0 KB attachments in the smf 1.05 conversion.

Thanks!

Scott

[[Unknown]]

Was your avatar a remote avatar?  Uploaded avatar?

If uploaded, what is 'avatar_path' in the config table (in phpBB)?

-[Unknown]

[jsdoyle]

That's it I guess.  The uploaded avatars are in a different folder from the gallery avatars. 

avatar_path= images/avatars
avatar_gallery_path= images/avatars/gallery

Scott

[[Unknown]]

Try this one.

-[Unknown]

[jsdoyle]

That's got it!  All avatars now converted.

Good job!

Scott

[killa4u]

hi all

still new here and having a problem... i will change my board from phpbb2plus 1.52 a premodded php into mambo and using your simpleboard wich is real great for this ...
but now i have troubles to convert the database from the php to simpleboard
what must i do? i find only *.php scripts under downloads and here u pick up *.sql converters?
im real not good in such things and dont want to hang up my board threads and users
so is it possible that u can tell me how to do that converting in a save mode???
like backing up my *database in *.sql and convert then or so?
im not native speaker so pleaze take it easy :-)
greats and thx
killa4u

[tentronik]

Here attached at the first post you can download the converter.php http://www.simplemachines.org/community/index.php?topic=38966.135

so is it possible that u can tell me how to do that converting in a save mode???

I dunno this, please wait for more advice if you dont know what you doing.
So make a backup and read the converter information and the 1st posts.

[killa4u]

hi

im glad to say that i get it to convert the plus into a normal phpbb 2.017 
my questions now:
i have installed the php in my database db3_xxx
i have to install the blank SMF in the same database db3_xxx and put those 2 files init and execute convert.php?
is this right? something to do else
plz help me :-)
my forum i like to convert: http://forum.privatgolfclubhausegg.com
greets and thx
killa4u

[tentronik]

I dont know if its works with version 2.017 but if you make a backup of the phpBB database why not try to run the converter - the converter has a menu where you can enter the db infos.

[[Unknown]]

They do not have to be in the same database, but for some it is easier if they are.

But, yes, that's all you have to do .

-[Unknown]

[davo88]

Yes, that's correct. If you are installing SMF v1.1 beta 3, make sure you have the latest versions of convert.php and phpbb2_to_smf.sql from the first post in this thread - http://www.simplemachines.org/community/index.php?topic=38966.0

[killa4u]

hi i tried now and get some errors, must be all over avatar... does it matter??

Code Select Expand

Converting...
Converting ranks...Successful.
Converting groups...Successful.
Converting members...
Warning: copy(/usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/images/avatars/11675486883e7198b77bba9.gif): failed to open stream: No such file or directory in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(764) : eval()'d code on line 33

Warning: copy(/usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/images/avatars/13.gif): failed to open stream: No such file or directory in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(764) : eval()'d code on line 33
Successful.
Converting additional member groups...Successful.
Converting categories...Successful.
Converting boards...Successful.
Converting topics...Successful.
Converting posts (this may take some time)...Successful.
Converting polls...Successful.
Converting poll options...Successful.
Converting poll votes...Successful.
Converting personal messages (step 1)...Successful.
Converting personal messages (step 2)...Successful.
Converting topic notifications...Successful.
Converting board access...Successful.
Converting group access...Successful.
Converting moderators...Successful.
Converting avatar gallery images...Successful.
Converting censored words...Successful.
Converting reserved names...Successful.
Converting banned users...Successful.
Converting settings...Successful.
Converting attachment mod (if installed)...
Warning: filesize(): Stat failed for /usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/files/bin_dagegen.gif (errno=2 - No such file or directory) in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(627) : eval()'d code on line 57

Warning: filesize(): Stat failed for /usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/files/med.jpg (errno=2 - No such file or directory) in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(627) : eval()'d code on line 57

Warning: filesize(): Stat failed for /usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/files/golfplatz.jpg (errno=2 - No such file or directory) in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(627) : eval()'d code on line 57

Warning: filesize(): Stat failed for /usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/files/walter2.jpg (errno=2 - No such file or directory) in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(627) : eval()'d code on line 57

Warning: filesize(): Stat failed for /usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/files/ergebnisse_ostern_2003.pdf (errno=2 - No such file or directory) in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(627) : eval()'d code on line 57

Warning: filesize(): Stat failed for /usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/files/wappen_gruen.jpg (errno=2 - No such file or directory) in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(627) : eval()'d code on line 57

Warning: filesize(): Stat failed for /usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/files/wappen_schwarz.jpg (errno=2 - No such file or directory) in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(627) : eval()'d code on line 57

Warning: filesize(): Stat failed for /usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/files/hcp_august_2003_1.jpg (errno=2 - No such file or directory) in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(627) : eval()'d code on line 57

Warning: filesize(): Stat failed for /usr/local/httpd/htdocs/1060/1001/Golfclub/phpBB2/files/hcp_oktober_2003.jpg (errno=2 - No such file or directory) in /usr/local/httpd/htdocs/1060/1001/Golfclub/Mambo/smf/convert.php(627) : eval()'d code on line 57
Successful.
Recalculating forum statistics... Successful.


plz a little help :-)
greets
killa4u

[[Unknown]]

That means it wasn't able to convert the named avatars and attachments.

If you don't care about them, it doesn't matter.

-[Unknown]

[killa4u]

ok i dont matter and all is perfect thanks for the script and the real good forum!
greats
killa4u

[JoeP]

I'm new to smf (just uploaded the files).  I want to convert my phpbb2.017 board to smf 1.1 and have one simple question... do I need to go through the smf install process or do I just go right to the converter process?
Yes, I have also uploaded the two required converter files.
Thanks in advance!
joe

[davo88]

.... do I need to go through the smf install process

Yes, preferably install SMF in the same database as phpBB. Then run the conversion process. Then remove the phpBB tables using phpMyAdmin or similar.

If you are able to create new databases on your server, I can recommnd a trial run on a full copy of your forum. Although a basic conversion is quick and easy, if you want the best possible transition, there's lots of little details you may wish to handle during the real conversion. A couple of them are described here - http://www.simplemachines.org/community/index.php?topic=45530.0

Also make sure to put your forum into maintenance mode and allow plenty of time for the conversion. It's not something you want to rush.

[JoeP]

Thanks for the info!
Fortunately I'm making this switch in the board's infancy so we have just a few users and not much traffic.  All I want to move over are users, passwords, messages, and the basic catagory structure.
Thanks again for the link.  I'll take a look before I install and upgrade.
BTW, I'm going to be doing the upgrade first in my development environment (almost a duplicate of the real host).  Once I get the process down, I'll swtich the real board.
joe

[daftasabat]

Im trying to convert my small phpbb forum to smf I have uploaded the converter to the forum and ran it.  i made sure that the database user was the same user for both the smf and the php databases before i ran the converter and i changed the settings file so that the user name and password matched with my database,  the smf version i am using is 1.0.5 and my phpbb forum is version 2.0.16, I havent applied any modifications except some themes and new smiles and avatars which shouldnt really effect the conversion should it? .  I ran it and got this

Converting...
Converting ranks... successful.
Converting groups... successful.
Converting members... successful.
Converting additional member groups... successful.
Converting categories... successful.
Converting boards... successful.
Converting topics... successful.
Converting messages... (this may take some time) successful.
Converting polls... successful.
Converting poll options... successful.
Converting previous poll votes... successful.
Converting personal messages... successful.
Converting personal messages (step 2)... successful.
Converting topic notifications... successful.
Converting board access... successful.
Converting group access permissions... successful.
Copying avatar image files... successful.
Converting censored words... successful.
Converting reserved names... successful.
Converting ban list... successful.
Converting misc settings...
Warning: fopen(/home/daftasa/public_html/forum/Settings.php): failed to open stream: Permission denied in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3035

Warning: fclose(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3036

Warning: fopen(/home/daftasa/public_html/forum/Settings.php): failed to open stream: Permission denied in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3039

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3042

Warning: fwrite(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3045

Warning: fclose(): supplied argument is not a valid stream resource in /home/daftasa/public_html/forum/phpbb2_to_smf.php on line 3046
successful.
Recalculating forum statistics... successful.

Convert Smileys?

You will have to be gentle with me as i have only been doing my forum for two weeks. 

[Compuart]

Make sure the Settings.php file of SMF is writable. CHmod it to 777.