Advertisement:

Author Topic: [SMF Converter] phpBB3  (Read 399633 times)

Offline Austin01

  • Semi-Newbie
  • *
  • Posts: 18
Re: [SMF Converter] phpBB3
« Reply #800 on: February 19, 2012, 08:20:56 PM »
When I convert it, for some reason it shows it converts all the posts however it does not.

Offline Roston

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] phpBB3
« Reply #801 on: February 29, 2012, 02:55:50 AM »
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?
« Last Edit: February 29, 2012, 03:00:35 AM by Roston »

Offline Indyana

  • Semi-Newbie
  • *
  • Posts: 14
Re: [SMF Converter] phpBB3
« Reply #802 on: March 19, 2012, 07:35:47 PM »
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.
« Last Edit: March 19, 2012, 07:45:36 PM by Indyana »

Offline HunterP

  • Sr. Member
  • ****
  • Posts: 947
  • Gender: Male
  • SMF 2.0.4
    • Hulpverleningsforum Nederland
Re: [SMF Converter] phpBB3
« Reply #803 on: March 20, 2012, 03:57:13 AM »
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.

Offline Indyana

  • Semi-Newbie
  • *
  • Posts: 14
Re: [SMF Converter] phpBB3
« Reply #804 on: March 20, 2012, 07:20:34 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_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

Offline HunterP

  • Sr. Member
  • ****
  • Posts: 947
  • Gender: Male
  • SMF 2.0.4
    • Hulpverleningsforum Nederland
Re: [SMF Converter] phpBB3
« Reply #805 on: March 20, 2012, 03:27:53 PM »
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?

Offline duude88

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] phpBB3
« Reply #806 on: June 04, 2012, 04:33:17 PM »
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!

Offline Blackburn

  • Jr. Member
  • **
  • Posts: 117
  • Gender: Male
    • Slax Tr - Slax Türkiye Topluluğu
Re: [SMF Converter] phpBB3
« Reply #807 on: August 19, 2012, 07:20:18 PM »
thanks ;)
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.

Offline XIN

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] phpBB3
« Reply #808 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

ThorstenE

  • Guest
Re: [SMF Converter] phpBB3
« Reply #809 on: September 25, 2012, 10:56:45 AM »
yep, you're right  :)

Offline XIN

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] phpBB3
« Reply #810 on: October 02, 2012, 06:02:52 PM »
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...

ThorstenE

  • Guest
Re: [SMF Converter] phpBB3
« Reply #811 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.

Offline XIN

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] phpBB3
« Reply #812 on: October 03, 2012, 06:46:17 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).
« Last Edit: October 03, 2012, 10:54:47 AM by XIN »

Offline XIN

  • Semi-Newbie
  • *
  • Posts: 11
Re: [SMF Converter] phpBB3
« Reply #813 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.
« Last Edit: October 03, 2012, 07:52:35 AM by XIN »

Offline gideonsw

  • Semi-Newbie
  • *
  • Posts: 12
Re: [SMF Converter] phpBB3
« Reply #814 on: November 17, 2012, 01:18:43 PM »
Does it also convert themes?

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,103
  • Gender: Male
  • I don't speak German.
    • IchBin.us
Re: [SMF Converter] phpBB3
« Reply #815 on: November 17, 2012, 04:44:18 PM »
Converters only convert data. They do not convert any code or files from other forums.
Brad "IchBin™" Grow        TinyPortal        Themes
Coding Guidelines       

Offline Arthouris

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] phpBB3
« Reply #816 on: December 01, 2012, 06:00:47 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?

Offline IchBin™

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,103
  • Gender: Male
  • I don't speak German.
    • IchBin.us
Re: [SMF Converter] phpBB3
« Reply #817 on: December 03, 2012, 12:32:02 PM »
Edit your member id_group in the smf_members table for your account. Set it to 1.
Brad "IchBin™" Grow        TinyPortal        Themes
Coding Guidelines       

Offline meigallodixital

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] phpBB3
« Reply #818 on: December 12, 2012, 02:53:52 AM »
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.

Offline roomeat

  • Jr. Member
  • **
  • Posts: 217
  • Gender: Male
    • Ozsportsbikes
Re: [SMF Converter] phpBB3
« Reply #819 on: December 14, 2012, 05:35:39 PM »
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'