• Welcome to Simple Machines Community Forum. Please login or sign up.
September 28, 2021, 01:40:09 PM

News:

Follow SMF on Twitter.


[SMF Converter] phpBB3

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

Previous topic - Next topic

Oldiesmann

Michael Eshom
Cincy Space - now open!

Warwick Chapman

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.




dem666

Quote from: Oldiesmann 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

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'"


thuul

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'

Chelien Orlenard

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?

Chelien Orlenard

I solved the problem myself.
I modified the following parts of the source.

Sources/Sub-Db-mysql.php

find:
$db_string = substr($db_string, 0, $pos) . "\t\t\tORDER BY null\n" . substr($db_string, $pos, strlen($db_string));

replace with:
$db_string = substr($db_string, 0, $pos) . "\n" . substr($db_string, $pos, strlen($db_string));

find:
$db_string .= "\n\t\t\tORDER BY null";
replace with:
$db_string .= "";

This fix is only temporary, I undo the conversion is finished.
Thank you.

Theopt

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.

margarett

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

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

Theopt

Quote from: margarett 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...)

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

Asama

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.

margarett

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

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

Asama

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?

margarett

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 ;)
QuoteHowever, 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

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

Asama

Quote from: margarett 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 ;)
QuoteHowever, 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.
www.testforum12.altervista.org
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?

margarett

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

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

khigh

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.



amitjain94675


pacho_bg2

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.

margarett

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

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

GrCOTE7

Hi, Margarett, or other guy...


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

Advertisement: