News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

[SMF Converter] phpBB3

Started by JayBachatero, January 23, 2008, 04:49:39 AM

Previous topic - Next topic

Austin01

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

Roston

#801
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

#802
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

Quote from: Indyana on March 19, 2012, 07:35:47 PM
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

Quote from: HunterP on March 20, 2012, 03:57:13 AM
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 [nofollow]_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

Quote from: Indyana on March 20, 2012, 07:20:34 AM
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!

Blackburn

Gerçek mutluluk mal ve mülke sahip olmak ile değil,akıl ve erdeme sahip olmak ile mümkündür.
Slax Tr - Slax Türkiye Topluluğu adresinden usb ile bile çalışan işletim sisteminin Türkiye sitesine ulaşabilirsin.
Özgür yaşam,özgür insan.

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

ThorstenE


XIN

Quote from: XIN on September 25, 2012, 08:05:22 AM
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

Quote from: Thorsten Eurich on September 25, 2012, 10:56:45 AM
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...

ThorstenE

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

#812
Quote from: Thorsten Eurich on October 03, 2012, 02:36:32 AM
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.  8)

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

Thanks for your time.  ;D

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

#813
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


IchBin™

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

Arthouris

Quote from: XIN on October 03, 2012, 07:37:14 AM
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.
IchBin™        TinyPortal

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.

roomeat

Where do I find the convert.php file for SMF2?
I downloaded the one in the link on the first post but get the following error:

Converting ranks... Unsuccessful!
This query:
DELETE FROM `ozstuntSMF`.smf_membergroups
WHERE groupName LIKE 'phpBB %';
Caused the error:
Unknown column 'groupName' in 'where clause'
We were not given dreams, without also being given the power to achieve them.

Advertisement: