Advertisement:

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

Offline Oldiesmann

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 24,868
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • https://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: [SMF Converter] phpBB3
« Reply #820 on: December 31, 2012, 02:40:56 PM »
Converters for SMF 2.x are available on the downloads page: http://download.simplemachines.org/?converters;software=phpbb
Michael Eshom
Cincy Space - now open!

Offline Warwick Chapman

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] phpBB3
« Reply #821 on: January 02, 2013, 06:49:26 AM »
Howdy All

Tried converting from phpBB 3 to SMF and get the following error:

Converting topics...
Successful.
Converting posts...The database value you're trying to insert does not exist: modified_name


I have a DF installation which I have have tried to migrate to SMF but failed so am now trying to use phpBB as an intermediary.  I tried the DF 9.2.x -> SMF 2.0.x converter and that was a dead starter with forum posts here suggesting to rather convert to 1.x and then upgrade. I then tried the DF 9.2.x -> SMF 1.1.x converter but unfortunately that also crashed complaining about various duplicated items in the DF topics DB that phpBB conversion seemed to have no issue with - I have posted details in the converter forum but no replies yet.

Will appreciate any help anyone can offer.




Offline dem666

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] phpBB3
« Reply #822 on: January 20, 2013, 01:22:43 PM »
Converters for SMF 2.x are available on the downloads page: http://download.simplemachines.org/?converters;software=phpbb

This info its out of date, the link is to the phpbb 2 and 3 however after downloading both versions the contents of convert.php are the same, i get

"Caused the error:
Unknown column 'group_single_user' in 'where clause'"

 

Offline thuul

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] phpBB3
« Reply #823 on: January 30, 2013, 08:38:58 AM »
Failed me on the very first step

Converting...
Converting ranks... Unsuccessful!
This query:

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

Caused the error:

    Unknown column 'groupName' in 'where clause'

Offline Chelien Orlenard

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] phpBB3
« Reply #824 on: February 20, 2013, 05:37:13 PM »
Please help me.

Failed me on the very first step

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Preparing for categories conversion... Successful.
Converting categories... Successful.
Converting boards... Successful.
Fixing categories... Successful.
Converting topics... Successful.
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

Anyone good idias?

Offline Chelien Orlenard

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] phpBB3
« Reply #825 on: February 22, 2013, 04:02:19 PM »
I solved the problem myself.
I modified the following parts of the source.

Sources/Sub-Db-mysql.php

find:
Code: [Select]
$db_string = substr($db_string, 0, $pos) . "\t\t\tORDER BY null\n" . substr($db_string, $pos, strlen($db_string));
replace with:
Code: [Select]
$db_string = substr($db_string, 0, $pos) . "\n" . substr($db_string, $pos, strlen($db_string));
find:
Code: [Select]
$db_string .= "\n\t\t\tORDER BY null";replace with:
Code: [Select]
$db_string .= "";
This fix is only temporary, I undo the conversion is finished.
Thank you.

Offline Theopt

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] phpBB3
« Reply #826 on: March 11, 2014, 12:40:00 PM »
I've converted everything and everything went allright.

But is there a way to migrate all phpbb groups to the new ones?

All admins to admins, modes to modes etc.

without doing it by hand.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] phpBB3
« Reply #827 on: March 11, 2014, 12:52:47 PM »
Please use the converter from our downloads page:
http://download.simplemachines.org/?converters;software=phpbb

Looking at the code, that should be handled by the converter (not so sure about local board moderators, though...)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Theopt

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] phpBB3
« Reply #828 on: March 11, 2014, 01:59:36 PM »
Please use the converter from our downloads page:
http://download.simplemachines.org/?converters;software=phpbb

Looking at the code, that should be handled by the converter (not so sure about local board moderators, though...)

the groups work, I have admin rights and so on. but the other groups are still there as well.

Offline Asama

  • Newbie
  • *
  • Posts: 4
    • Asama1 on GitHub
Re: [SMF Converter] phpBB3
« Reply #829 on: June 19, 2014, 08:58:25 AM »
Hello guys,
I'm going to convert my phpbb 3.0.12 forum to SMF  ;) because i LOVE smf.
But before doing some ...... , i want to explain what i'm doing.
I downloaded converter (convert.php) and put it in the root of my forum.
Is this a right place? Tell me after.
Then i downloaded SMF 2.*.** version for phpbb3 and made a new folder in the root with name /forum and uploaded all the stuff i found in smf-install-**.zip.
So tell me if all is OK or i have did something wrong?
And please write down the procedure to convert because i go on http.//mydomain.******.***/convert.php and it say me :

This converter assumes you have already installed SMF and that your installation is working properly. It copies posts and data from your "source" installation of phpBB3 into SMF, so it won't work without an installation of SMF. All or some of the data in your installation of SMF will be overwritten.

So how to install smf before converting? ???
Answer all my questions and become a super her!! ;D :laugh:
Thanks in advance.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] phpBB3
« Reply #830 on: June 19, 2014, 09:08:59 AM »
You should read this:
Converting to SMF

You need to install SMF and have it running in its base form: 1 admin and 1 "General Discussion" board. Then you put convert.php and the .sql file in SMF's folder. Then you run the converter.
Use the .sql file from this topic here: http://www.simplemachines.org/community/index.php?topic=508551.0

Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Asama

  • Newbie
  • *
  • Posts: 4
    • Asama1 on GitHub
Re: [SMF Converter] phpBB3
« Reply #831 on: June 19, 2014, 10:10:33 AM »
Thanks but i'm blocked on :

Checking Files are Writable
Some files need to be writable for SMF to work properly. This step allows you to let the installer make them writable for you. However, in some cases it won't work - in that case, please make the following files 777 (writable, 755 on some hosts).

This installer can connect via FTP to fix the files that need to be writable and are not. If this doesn't work for you, you will have to go in manually and make the files writable. Please note that this doesn't support SSL right now.

Server: localhost       Port: 21
Username: allaboutandroids@localhost
Password: **************
Install Path: /forum

When i click on Continue, It load load and load and then .......Nothing. I'm still on this page!!!
What's wrong?

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] phpBB3
« Reply #832 on: June 19, 2014, 10:39:32 AM »
It is possible that SMF cannot change permissions, either by authentication or ownership issues.

Make sure you have correct ownership of all your files (ask your host for help if unsure) and do what the installer asks you ;)
Quote
However, in some cases it won't work - in that case, please make the following files 777 (writable, 755 on some hosts).
Use 755, not 777.
How do I chmod? / what is chmod?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Asama

  • Newbie
  • *
  • Posts: 4
    • Asama1 on GitHub
Re: [SMF Converter] phpBB3
« Reply #833 on: June 19, 2014, 10:55:59 AM »
It is possible that SMF cannot change permissions, either by authentication or ownership issues.

Make sure you have correct ownership of all your files (ask your host for help if unsure) and do what the installer asks you ;)
Quote
However, in some cases it won't work - in that case, please make the following files 777 (writable, 755 on some hosts).
Use 755, not 777.
How do I chmod? / what is chmod?
Thanks,
I just created a new test forum to install SMF on phpBB 3.0.12 and it work.
hxxp:www.testforum12.altervista.org [nonactive]
I made a folder named forum and just copied all files in this.
Then i go on ....../install.php and write some details and it automatically sent me to step 3 without step 2 where it ask for permissions that 777 or 775 etc.....
Then why it isn't working on my other site?

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] phpBB3
« Reply #834 on: June 19, 2014, 11:14:25 AM »
SMF checks the permissions on the files. If they are OK, it skips steps 2 ;)
That's why it won't work in your site. You need to manually fix permissions. When you do, it will also skip step 2 ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline khigh

  • Jr. Member
  • **
  • Posts: 163
Re: [SMF Converter] phpBB3
« Reply #835 on: December 20, 2014, 03:59:13 PM »
Not to be spamming the boards - I've already asked this elsewhere, but now I realize this was probably the right place all along.

I'm getting a phpBB site. - not a working one I can convert where it lives, but something on a flash drive, ftp transfer - something along those lines - one shot at getting everything. I think most of what I've been seeing here is how to convert an operational board.

I just want to make sure I get everything I need which I'm assuming is the site/forum file structure and the MySQL DB(s?). Can those just be files or am I going to have to have the password to open them on my side, or do they have to be exported or something?

I've got a couple thousand people counting on me to rescue a much-loved orphaned board from a disinterested owner shutting it down.

Thanks for looking.



Offline amitjain94675

  • Semi-Newbie
  • *
  • Posts: 26
Re: [SMF Converter] phpBB3
« Reply #836 on: January 17, 2015, 11:29:26 AM »
I need some help you there

Offline pacho_bg2

  • Newbie
  • *
  • Posts: 9
Re: [SMF Converter] phpBB3
« Reply #837 on: June 02, 2015, 08:43:46 AM »
Anyone have an idea if the converter is going to be updated to work for phpbb 3.1, because the current one doesn't work.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] phpBB3
« Reply #838 on: June 02, 2015, 05:59:05 PM »
It's in my todo list ;)
(unfortunately, so is a dozen of other things :( )
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline GrCOTE7

  • Semi-Newbie
  • *
  • Posts: 54
  • Gender: Male
    • concrete5
Re: [SMF Converter] phpBB3
« Reply #839 on: August 14, 2015, 04:34:19 PM »
Hi, Margarett, or other guy...


Do you know if there is a github fo the converter from phpBB  :D ?