[SMF Converter] phpBB3

[Joe N]

Hi. Has anyone done this?

Could I have a url of a site that has?

[S.Nieves]

Ok, Im halfway there.. I got the sql file in with the smf files, but where the heck is the convert.php file? every time i click on it it takes me to the same post. There is no download?

[ThorstenE]

direct link: http://www.simplemachines.org/community/index.php?action=dlattach;topic=140741.0;attach=79452

[S.Nieves]

Converting ranks... Successful.
Converting groups... Unsuccessful!
This query:

    SELECT
    SUBSTRING(CONCAT('phpBB ', group_name), 1, 255) AS groupName,
    -1 AS minPosts, '' AS stars, '' AS onlineColor
    FROM `dogge2_phpBB`.phpbb_groups
    WHERE group_single_user = 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'group_single_user' in 'where clause'





What does it mean? Keep trying?? This is as far as I got...

[S.Nieves]

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Preparing for categories conversion... Successful.
Converting categories... Successful.
Converting boards... Successful.
Fixing categories... Successful.
Converting topics... Successful.
Converting posts... 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 attachments... Successful.
Recalculating forum statistics... Successful.



CHACHINGG!!!

YEA!!

[S.Nieves]

Ok, I had to reset my password after trying to log in to many times. I installed the package login and activated it and i have some test members I use that I cannot log in with. Also tried editing manually the custom password hash.. I get a fatal error when I log out.

Can anyone direct me to the package im suppose to use.

ALSO!! It shows I have 160 members?!! I only had 58 prior to the switch.

Thanks a ton!

[ThorstenE]

ALSO!! It shows I have 160 members?!! I only had 58 prior to the switch.

phpBB3 stores the Search engine bot inside the users table, you can easily remove the bots from the members table -> Admin -> members

the login fix is attached to the first post from this topic. you should be able to install the fix via Package Manager

[S.Nieves]

Ok! Done. Its all good.

Now on to play with some portals!

[GravuTrad]

Noted. I hope to solve all this permissions problems.

It's clear that the converter not manage entirely the permissions of phpbb3 vs smf.

we'll have to check all permissions, but too recheck all forum accesses. (visibles or not, particularly for guests which can see all of base)

[Phil Serna]

i am so confused right now on all of this after reading previous posts.

on my desktop i have the covert.php file and i also have the phpbb3_to_smf.sql

do these go in my root? (the root is where I am going to have my forum)

thanks!

[ThorstenE]

do these go in my root? (the root is where I am going to have my forum)

yes, copy both files via FTP to your root folder, then start convert.php with your browser:

Converting to SMF

[Kyzer]

How do i use this?

[ThorstenE]

Kyper, have you checked our docs? conversion isn't very complicated.
Converting to SMF
first step: Install SMF, then upload the converter files and specify some information..

[er1c]

So I used to use SMF, got too frustrated with the lack of "good" themes compared to phpbb3. I converted and within 2 months, I want to come back home

1st question; from what I read, the converter only works with 1.1.8 but I can only download 1.1.10. Will the converter work with 1.1.10?

[ThorstenE]

All converters from our downloads page should work with SMF 1.1.10 as well.

http://download.simplemachines.org/?converters

The converter topics are also up to date now

PS: Welcome Back

[er1c]

Thanks

Unfortunately, I stumbled on the conversion

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Preparing for categories conversion... Successful.
Converting categories... Successful.
Converting boards... Successful.
Fixing categories... Successful.
Converting topics... Successful.
Converting posts... 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 attachments... Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1248108347),
    ("conversion_from", "phpbb3_to_smf.sql");

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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1248108347)' at line 1

what to do now???

[ThorstenE]

This is a small bug in convert.php , everything should be fine the last important step was successful:

Recalculating forum statistics... Successful.

[er1c]

In that case, everything was a success!  I just had to reset permissions and membergroups.

Thanks for the help!

[noon3]

Hi guys  same as er1c, i'm getting the same error message. Would appreciate help here. Thank you.

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Preparing for categories conversion... Successful.
Converting categories... Successful.
Converting boards... Successful.
Fixing categories... Successful.
Converting topics... Successful.
Converting posts... 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 attachments... Successful.
Recalculating forum statistics... Successful.
Unsuccessful!
This query:
REPLACE INTO {$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1249270645),
("conversion_from", "phpbb3_to_smf.sql");
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 '{$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1249270645)' at line 1

[ThorstenE]

noon3, this is a minor bug in convert.php, don't care about this error. the last important step has finished without errors:

Code Select Expand

Recalculating forum statistics... Successful.