[BETA] SMF 1.1 to phpBB3 Convertor

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Ideas Centre
Locked
oojacoboo
Registered User
Posts: 12
Joined: Wed Nov 07, 2007 11:19 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by oojacoboo »

it actually doesn't appear that the attachments are even imported into the posts/threads. I looked at the code for the thread and there isn't anything about an attachment in there. Is that set in another field in the db and imported? If so, is that part stripped during the conversion, or...? Thanks.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by D¡cky »

The attachments don't actually get imported into the posts. A marker is set that there is an attachment, then phpBB3 goes and looks for that attachment and displays it.

Looking at the convertor again, it looks like that attachments should be converted. I will look some more later on tonight.
Have you hugged someone today?
Mukke
Registered User
Posts: 26
Joined: Fri Mar 04, 2005 4:36 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by Mukke »

lockelymarkets wrote:
7earitup wrote:lockely, You are using the new Beta 2 of the converter script, correct?
Yup im using the Beta 2, well its the one linked on the first post :D
A_Jelly_Doughnut wrote:
lockelymarkets wrote:Hello, I am converting my SMF board to phpBB3, and im having issues :?
I get the following error: :o
[snip]
I have SMF 1.1.4 and am wishing to convert it to phpBB3 RC7. :|

Thanks :)
It appears that you are running an older version of MySQL (than 5.0.x). I'm looking into a fix for you :)
Okie dokie thsnks ;)
I'm looking for the exact same thing, altho my server should be running php 5 soon it's still not up to date atm but i need the convering quite fast, if you can't manage to do it i'll do it by hand (convert it to phpBB2 and then to phpBB3 with the build in coverter)
lockelymarkets
Registered User
Posts: 14
Joined: Sun May 13, 2007 7:56 am

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by lockelymarkets »

My hosting atm is on php5 and mysql4 if that helps

EDIT: Had the wrong MYSql, sorry
Last edited by lockelymarkets on Sat Nov 10, 2007 11:36 am, edited 1 time in total.
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by D¡cky »

oojacoboo,

I would like you to empty your phpBB3 files directory except for .htaccess and index.html.
Download this, functions_smf11.zip
Unzip and replace your present convertors/functions_smf11.php file with this file. Make a backup of your present file if you like.
Run the convertor again.
There is no need to copy the files. The attachments should now show.
Have you hugged someone today?
cogitat
Registered User
Posts: 9
Joined: Wed Jul 14, 2004 2:59 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by cogitat »

My conversion actually went pretty smooth with no real hitches once i figured out what need to be in the install folder with it.

The only minor issue i have is with my admin account. It continously says i have 4 messages, when i click on it to go to pm's they are empty. I did bring all my pm's over and then cleaned them all out beforehand. Any idea what would cause this?
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by A_Jelly_Doughnut »

cogitat: That is probably a known bug in phpBB 3 RC7 with keeping the PM Counter.

To use this convertor with MySQL4, open functions_smf.php, and find

Code: Select all

			// since the post text is the most important text on the board, we check it.
			// We assume all columns have the same charset & collation
			$sql = "SHOW FULL COLUMNS FROM {$convert->src_table_prefix}messages WHERE field = 'body'";
			$result = $src_db->sql_query($sql);

			$db_collation = $src_db->sql_fetchfield('Collation');
Replace With

Code: Select all

			// since the post text is the most important text on the board, we check it.
			// We assume all columns have the same charset & collation
			$sql = "SHOW FULL COLUMNS FROM {$convert->src_table_prefix}messages";
			$result = $src_db->sql_query($sql);

			while ($row = $src_db->sql_fetchrow($result))
			{
				if ($row['field'] == 'text')
				{
					$db_collation = $row['Collation'];
				}
			}
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
lockelymarkets
Registered User
Posts: 14
Joined: Sun May 13, 2007 7:56 am

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by lockelymarkets »

Thanks for that :D it worked!!!
dkarlovi
Registered User
Posts: 23
Joined: Mon Sep 24, 2007 11:28 am

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by dkarlovi »

No fix for my issue? :(
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by A_Jelly_Doughnut »

dkarlovi wrote:OK, I think I found a bug: my topic is called "Po čemu ćete pamtiti danas" (it croatian, never mind) and the first post's title is indeed that, but when browsing the board with that topic, all I get is "Po " (yes, it gets chopped right in the "local char"). Same thing for group names (but those are much easier to fix).

Also, I don't really understand how the topic gets its title. My first post is called "Što bi sada rekli nekome?", but my topic is called "Odg: " (equivalent to "Re: ") which exhibits the bug above but also topics get wrong names. I'm guessing it's due to SMF not having seperate topic and message (with them, topic is a group of messages) and phpBB3 does.

My forum was iso-8859-2, if it helps.
Sorry I missed you :(

Well...there are lots of things that could cause the string truncation ... among them
1) ISO-8859-2 is not the correct encoding for Croatian language
2) Your board at one time used a different encoding than ISO-8859-2. The convertor has serious trouble dealing with boards that contain posts in multiple encodings
3) You're using SMF's UTF8 function (which is broken), and the convertor is having trouble rectifying it.

So, I ask you these questions so I can look into this better:
1) Are you using SMF's UTF8 function? (This can be determined in settings.php)
2) Was your board ever using an encoding aside from ISO-8859-2?

-------
SMF does store topic titles separately than post titles. That problem is particularly puzzling.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
dkarlovi
Registered User
Posts: 23
Joined: Mon Sep 24, 2007 11:28 am

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by dkarlovi »

A_Jelly_Doughnut wrote: Well...there are lots of things that could cause the string truncation ... among them
1) ISO-8859-2 is not the correct encoding for Croatian language
It's the right encoding.
2) Your board at one time used a different encoding than ISO-8859-2. The convertor has serious trouble dealing with boards that contain posts in multiple encodings
No, I don't think so. The chars are displayed correctly in that encoding on the SMF board and are converted correctly in the "title post" so I'm guessing they're encoded correctly too.
3) You're using SMF's UTF8 function (which is broken), and the convertor is having trouble rectifying it.
Nope.
SMF does store topic titles separately than post titles. That problem is particularly puzzling.
I could give you my DB dump for testing, how's that? :)
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by A_Jelly_Doughnut »

dkarlovi wrote:I could give you my DB dump for testing, how's that? :)
That would probably be easiest.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
dkarlovi
Registered User
Posts: 23
Joined: Mon Sep 24, 2007 11:28 am

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by dkarlovi »

A_Jelly_Doughnut wrote:
dkarlovi wrote:I could give you my DB dump for testing, how's that? :)
That would probably be easiest.
OK, do you mind a PM with the URL? I ask because I've read it's against the rules.
User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by A_Jelly_Doughnut »

dkarlovi wrote:
A_Jelly_Doughnut wrote:
dkarlovi wrote:I could give you my DB dump for testing, how's that? :)
That would probably be easiest.
OK, do you mind a PM with the URL? I ask because I've read it's against the rules.
PM is fine (for something like this, that should obviously remain private :) ).
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
alitogata
Registered User
Posts: 7
Joined: Mon Nov 12, 2007 6:19 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by alitogata »

I used the convertor without any problems except one, encoding problems :(

Tha language we used for writting messages at SMF was Greek (utf8_general_ci).

Below is a screenshot of how the phpbb3 Board Index looks after converting from smf
boardindex.jpg
boardindex.jpg (119.58 KiB) Viewed 1873 times
and below is hot the sub-forum looks which shows the greek titles correctly, but if you click on a message everything looks like in Board Index.
category.jpg
category.jpg (41.9 KiB) Viewed 1796 times
SMF Version: 1.1.4
Phpbb3: 3.0.RC7
Database: MySQL 4.1.22-standard

I used the fix at "functions_smf.php" provided above for MYSQL 4
The collation for phpbb3 tables was utf8-bin and changed it to utf8_general_ci but without any luck.

How can this be fixed?

Thanking you
Locked

Return to “[3.0.x] Convertors”