[SMF Converter] phpBB3

[ThorstenE]

the file LogInOut.php is located in SMF "Sources" directory.

[FishHeadThe3rd]

Thanks!  It works now!

[pingpongrob]

Hi All,
I'm new to this forum, have had an installation of phpBB 3.0.RC1 for quite some time but have had problems with spam - So I though about giving this forum a go, it look good and seem to work well.

I've been asked by my forum members if it is possible to convert the old data over, so I tried the new converter, but got this error message.

Converting ranks... Unsuccessful!
This query:

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

Caused the error:

    Unknown column 'groupName' in 'where clause'

Can anybody please help me.

[ThorstenE]

mhh, I'll bet you used SMF 2.0 RC1? Our converters are SMF 1.1.x only at this time. Install SMF 1.1.8, convert your phpBB and then upgrade your SMF 1.1.8 to 2.0 RC1
Upgrade SMF

[pingpongrob]

mhh, I'll bet you used SMF 2.0 RC1? Our converters are SMF 1.1.x only at this time. Install SMF 1.1.8, convert your phpBB and then upgrade your SMF 1.1.8 to 2.0 RC1
Upgrade SMF

Thanks, Tried to install version SMF 1.1.8, but to no avail.  here it is http://affordablett.com.au/forum2/install.php

also tried the webinstall, but that failed (I used the webinstall.php on the new version, and it worked a treat the first time, but this time it screwed everything up).

Not sure what to do next. 

[Jason kiDD]

I am getting the following error after doing a phpbb3 convert to Smf 1.1.8... Any help would be appreciated..

Converting poll votes... Unsuccessful!
This query:

INSERT INTO `phatjamz_smf19`.smf_log_polls
(ID_POLL, ID_MEMBER, ID_CHOICE)
VALUES ('8723', '294', '2'),

BLAH BLAH BLAH, YADDA YADDA YADDA * ENTRIES

Caused the error:

    Duplicate entry '8723-294-2' for key 1

[ThorstenE]

you must edit the phpbb3_to_smf.sql, find:

Code Select Expand

---* {$to_prefix}log_polls
replace it with:

Code Select Expand


---* {$to_prefix}log_polls
---{
$ignore = true;
---}

then restart the conversion.

[Jason kiDD]

That seems to have done the trick. Thanks..

[pingpongrob]

Where can I find the Update from 1.1.8 to the New 2.0 RC1.
And if I upgrade, will I be stuck on that version, or will their eventually be an update to the final release.

Thanks in advance

[ThorstenE]

http://download.simplemachines.org/ <<--- the large upgrade package from SMF 2.0 RC1.
upgrading to the final release will also be possible.

[blindarkman]

Would like to say thanks for your hard work on this. All went extremely well for me, only problem was had to modify my hxxp:session.save [nonactive]_path while converting.

[t3v4]

I again have problem...

When i convert, phpbb3 to smf... I cant administrate forum

What should i do?

[ThorstenE]

I accidentally deleted my admin account, what do I do?

[neonProto]

I have converted phpbb3 to smf118 successfuly today.
Only the smileys are not converted.
Is it possible to convert them to smiley icons too?

Thank you

[essexgunner2003]

hmm looks like something i want to use, will give it a go later

[edjon2000]

Hi again,

I am back, I have now decided to definitely replace PHPBB3 with SMF, I did it before and then upgraded SMF to 2.x rc but since then posts have been added to my old PHPBB3 forum so I need to do the conversion again I already have the convert.php and the phpbb3_to_smf.sql files but have lost the login fix file that needs to be installed via the SMF package manager please could you provide me with the link again, as an aside I am now running/testing Windows 7 RC so when I figure out how to set up a local install I will let you know how it works

Any advice and help will be always welcome

Jon

[ThorstenE]

The Login_Fix is atached to the first post from this Topic.

I am back, I have now decided to definitely replace PHPBB3 with SMF..

You're Welcome

[edjon2000]

Brilliant! thank you TE I knew it was in here somewhere

[axishift]

I got this error..

Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `mtp_community2`.smf_topics
    SET ID_FIRST_MSG = '',
    ID_MEMBER_STARTED = '0', ID_LAST_MSG = '',
    ID_MEMBER_UPDATED = '0', numReplies = '-1'
    WHERE ID_TOPIC = 23661
    LIMIT 1;

Caused the error:

    Duplicate entry '0-9' for key 2

The first error was related to polls, but I was able to fix that from the the query/post above.

Help.

[baDibere]

I got this error..

Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `mtp_community2`.smf_topics
    SET ID_FIRST_MSG = '',
    ID_MEMBER_STARTED = '0', ID_LAST_MSG = '',
    ID_MEMBER_UPDATED = '0', numReplies = '-1'
    WHERE ID_TOPIC = 23661
    LIMIT 1;

Caused the error:

    Duplicate entry '0-9' for key 2

The first error was related to polls, but I was able to fix that from the the query/post above.

Help.

I've same error too