1.1 Converters

[Cow]

Hi,

please can you guys fix the attachments in the 1st post, the downloads downt work

Thanks!

[hammad]

i m Converting PHPbb to SMF rc1

and i m goting this error


Converting members... Unsuccessful!
This query:
INSERT INTO `smf`.smf_members
(ID_MEMBER, memberName, realName, passwd, lastLogin, dateRegistered, location, posts, ID_GROUP, instantMessages, emailAddress, unreadMessages, MSN, AIM, ICQ, YIM, websiteTitle, websiteUrl, showOnline, timeOffset, hideEmail, avatar, signature, pm_email_notify, is_activated)
VALUES ('2', 'ali', 'ali', '0b4e7a0e5fe84ad35fb5f95b9ceeac79', '1137746536', '1137746520', '', '17', '1', '0', '[email protected]', '0', '', '', '', '', '', '', '1', '0', '0', '', '', '1', '1');
Caused the error:

Unknown column 'pm_email_notify' in 'field list'

[Alexander Schmitt]

Well, the attached files do work, but seems like the convert.php is down. Could anybody help me?

[hammad]

 Help ! , Help ! , Help ! , Help ! , Help ! , Help ! , Help ! , Help ! , Help ! , Help ! , Help ! ,

i m Giting this PLz tell me Full sloution coz i m new to SMF

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)... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `hammad_smf`.smf_boards
SET ID_LAST_MSG = 5, lastUpdated = 1137771750
WHERE ID_BOARD = 1
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'

[Harzem]

This is a perfect conversion, believe me.

You just need one more step to do. Go to admin panel. Go to "Forum Maintenance". Click on "Recalculate all stats". And then you are perfectly at SMF

[harikumar]

Wow, the steps worked! :-)  I'm new to php or sql or SMF, I just switched webhosts from Yahoo to GoDaddy and I had phpBB on Yahoo.  I first had to jump through a learning curve to understand how to transfer my phpBB forum from my Yahoo servers to the GoDaddy servers, and then another learning curve to understand how to convert the phpBB database to SMF.

It was *much* easier to find help for the SMF installation/conversion part :-)  The steps worked cleanly, and even that last post about the statistics recalculation "error" message was useful - I ran into the same error message and followed the steps listed to manually recalculate, and my new SMF board is up and running with the same posts from my old phpBB boards!

I'm definitely a newbie, so I was very glad to see other newbies asking the same questions I had, and other more knowledgeable people patiently answering those questions!  Thanks so much!
Hari :-)

[madmat]

HELP!!

Can anyone tell me why this happens...

The installation of SMF in the path you specified is not a version this converter can deal with. If it is older than SMF 1.0, you need to upgrade first. If it is newer, you need to use a different converter. This is the error messge I get when I run phpbb2_to_smf.php

[Harzem]

This is the error messge I get when I run phpbb2_to_smf.php

Which versions of phpBB and SMF are you using?

[madmat]

OK

phpBB 2.0.18 needs to convert to smf 1.1 rc2

[harikumar]

OK

phpBB 2.0.18 needs to convert to smf 1.1 rc2

I ran into the same error under the same conditions - I just upgraded from phpBB 2.0.18 to SMF 1.1 rc2.  You probably got the converter from the Downloads page, right?  That converter is out of date (the date next to it says Aug 2005, which predates the release of smf1.1rc2.

Instead, try the convert.php file and the phpbb2_to_smf.sql file attached to the first post in this current thread (1.1 Converters).  That worked like a charm for me :-)

Hope this helps,
Hari :-)

[xinnek]

the link for the converter doesn't work.  where can I get it? please help.

[ms_ukyankee]

Spent a while reading through this thread. I just cobbled a test conversion from an old YaBB 1 Gold sp1.1 to SMF 1.1RC2.

Had a few errors, though they were mostly marked read data, which was not terribly important to me so I removed those bits from the converter as needed. And the statistics step at the end was unsuccessful so I abandoned the conversion and recalculated statitstics and it appears fine. But this was a test conversion so we could have sample data to work with in integrating with our current website where it previously relied on the yabb data.

I read somewhere in this thread that the converters are for RC1, and if that's the case, perhaps my errors were because of that and you don't need an error report to get bugs out?

[Omniverse]

I'm interested in the YaBB2.x converter. Any info on how well it works or when a final of the converters may be finished?

I'm a noob to SMF, looking forward to using it when I get my host switched, which will allow me to use Mysql. I love YaBB, but need something thats easier to merge into the rest of my site

[Bruno36]

 Hello!

I seek a converter for last Fire-Software-Board has SMF

Thank you for your assistance

[Boredflak]

I'm getting the following error when trying to convert from phpBB2:

Code Select Expand


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

The error MySQL gave was: 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 '~^`[^`]+`.\d~' at line 2


I see the syntax mentioned in the error in line 333 of convert.php:

Code Select Expand

if (preg_match('~^`[^`]+`.\d~', $from_prefix) != 0)

I'm runing MySQL 4.1.15

[Bruno36]

Nobody for me helped

[profile]

i'm trying this on phpbb2.0.19 and smf 1.1.rc2

here's the error i'm getting:

Recalculating forum statistics... Unsuccessful!
This query:

    UPDATE `testing`.smf_boards
    SET ID_LAST_MSG = 3088, lastUpdated = 1138940072
    WHERE ID_BOARD = 2
    LIMIT 1;

Caused the error:

    Unknown column 'lastUpdated' in 'field list'

[Bruno36]

 

[Harzem]

i'm trying this on phpbb2.0.19 and smf 1.1.rc2
here's the error i'm getting
...

Just ignore that. Your forum is converted successfully But, go to SMF admin panel > Forum Maintenance > Recalculate forum statistics. And you're completely done

[Bruno36]

Nobody for me helped