Topic: [SMF Converter] phpBB3

[Austin01]

When I convert it, for some reason it shows it converts all the posts however it does not.

[Roston]

hi mates. I have some problem with convertation from phpbb3.0.9 to smf. So I have two databases, one for phpbb, another for smf. So I've installed both forum's, tested phpbb, all works fine, I can login without problem an so on.  But when I've convert it to smf, all topics converted quite fine.
But I have two issues:
- first I have lost admin account of smf,
- second, login;password combination doesn't work at smf! but I compared it to password at phpbb DB, they are equals.

btw: LogInOur.php is the same, as TS describe

Any ideas?

[Indyana]

Hi there,

I'm trying to convert a phpbb3 forum to smf but I have some problems. The posts and the topic titles appear trimmed. Is there any way to avoid this? Is there a converter that writes a sql file so I can correct the duplicates? Is there a converter that only moves the posts and the topic titles?

Thank you very much and kind regards.

[HunterP]

I'm trying to convert a phpbb3 forum to smf but I have some problems. The posts and the topic titles appear trimmed. Is there any way to avoid this? Is there a converter that writes a sql file so I can correct the duplicates? Is there a converter that only moves the posts and the topic titles?

I don't know where the subject in phpBB is, but it should be something like this :

UPDATE smf_messages smf, phpbb3_posts phpbb SET smf.subject=phpbb.post_subject WHERE smf.id_msg=phpbb.post_id;

Make a backup first, but with variations of this query, I've solved some problems after converting myself.

[Indyana]

I don't know where the subject in phpBB is, but it should be something like this :

UPDATE smf_messages smf, phpbb3_posts phpbb SET smf.subject=phpbb.post_subject WHERE smf.id_msg=phpbb.post_id;

Make a backup first, but with variations of this query, I've solved some problems after converting myself.

Thank you very much! It "worked".

It worked because I have some problems with the quotes, the formatted text and some special characters because my forum is in Spanish. So now I need to:
1- Make it work with quotes, formatted text and special characters
2- I have another problem. Sometimes some new posts appear trimmed too. I don't know why but it happens. Any idea how can I resolve this?

Thank you very much and kind regards

[HunterP]

It worked because I have some problems with the quotes, the formatted text and some special characters because my forum is in Spanish. So now I need to:
1- Make it work with quotes, formatted text and special characters
2- I have another problem. Sometimes some new posts appear trimmed too. I don't know why but it happens. Any idea how can I resolve this?

As for #1; do you have a link to your forum so I can see what you mean?
As for #2; new postings on SMF, postings which don't exist in the old database?

[duude88]

Hi everyone!

I'm having some issues with the converter. The transfer is between phpBB 3.0.8 and SMF 2.0.2. Most of the content converts successfully, posts seem to be the problem. This is the error that gets displayed:
Converting posts...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 'ORDER BY null' at line 203

I saw in the errors thread a similar one but couldn't find the mentioned code in convert.php

Any ideas? Thanks!

[pt8]

Hi everyone!

I try to convert a phpbb 3.0.10 forum to smf. I download the latest convertor from this site (Phpbb 3 to SMF 2-0) and follow the instructions.
The path to the phpbb 3.0.10. forum is "../forum"
I install the clean new smf 2.0.2. forum in "../community"

After this I call the converting mask "../community/convert.php" and after a few steps I get this massage:

Code: [Select]

Converting posts...
Duplicate entry '4627' for key 'PRIMARY'

I take a look on this topic and I was thinking that this is the solution to my problem but the id_cat value on my db was even 4. Still get this error. I try the same on localhost with xampp and get the same error with other number.

It would be very nice if someone coult help me out. since one yeahr a convert the same forum from smf to phpbb 

[Blackburn]

thanks

[XIN]

Hey guys, I need to do a conversion from Phpbb3 to SMF2 and I just want to make sure I have understood the process correctly.
Correct me if I'm wrong please

The older Phpbb3 database I am transferring is on a seperate host to the SMF installation / databse.

1> Install a fresh phpbb3 install to the same host as the SMF database.
2> Aquire the mysql backup of the phpbb3 installation (from the older seperate host) and import it into the new phpbb3 database
3> Now both forums are on same host / database, upload the convert.php file to the root of the SMF forum
4> navigate to convert.php to begin process
5> profit?

Thanks in advance

[TE]

yep, you're right 

[XIN]

Hey guys, I need to do a conversion from Phpbb3 to SMF2 and I just want to make sure I have understood the process correctly.
Correct me if I'm wrong please

The older Phpbb3 database I am transferring is on a seperate host to the SMF installation / databse.

1> Install a fresh phpbb3 install to the same host as the SMF database.
2> Aquire the mysql backup of the phpbb3 installation (from the older seperate host) and import it into the new phpbb3 database
3> Now both forums are on same host / database, upload the convert.php file to the root of the SMF forum
4> navigate to convert.php to begin process
5> profit?

Thanks in advance

yep, you're right 

Thanks for the confirmation but I am stuck, can you guide me please.

I basically have a phpbb3 and fresh smf2 forum setup and ready after performing the steps in my previous post.
I downloaded the phpbb3 to smf2 converter (aand sql file)from the downloads section, uploaded them to the smf root.

After the page where you enter the url to the two forums, I click go and it just goes blank 'page not found'.

What am I doing wrong?

 Additional Options...

[TE]

XIN,
your SMF is 1.1.12 (followed the URL from your screenshot  ) and convert.php + phpbb3_to_smf.sql seems to be the 2.0 version. Either you install SMF 2.0.2 or you downloed the 1.1. converter files.

[XIN]

XIN,
your SMF is 1.1.12 (followed the URL from your screenshot  ) and convert.php + phpbb3_to_smf.sql seems to be the 2.0 version. Either you install SMF 2.0.2 or you downloed the 1.1. converter files.

I knew something was not quite right but was too tired to notice that hehe. 

So forum successfully converted now, still need to check for any minor quirks but conversion went smooth enough so far.

Thanks for your time. 

EDIT: Some things that got messed up;

* Forum titles (adds phpbb) - fixed via phpbb myadmin tables
* Attachments (but I don't have access to original forums root so meh)
* Avatars (same as above probably)
* youtube embeds in posts - different code I guess
* signatures - probably same as attachments

Otherwise boards and sub boards seemed the same (hidden/admin only boards were made public).

[XIN]

Is there a quick way to make myself an admin (via phpmyadmin perhaps?) so I can access the admin panel to install plugins etc ?


EDIT: Nevermind, did it, was quite simple really.

[gideonsw]

Does it also convert themes?

[IchBin™]

Converters only convert data. They do not convert any code or files from other forums.

[Arthouris]

Is there a quick way to make myself an admin (via phpmyadmin perhaps?) so I can access the admin panel to install plugins etc ?


EDIT: Nevermind, did it, was quite simple really.

Which was?

[IchBin™]

Edit your member id_group in the smf_members table for your account. Set it to 1.

[meigallodixital]

How can i convert more posts on each step? It's a big forum with +3.600.000 posts, is very slow by default.

Thanks in advance.