Page 24 of 26

Posted: Wed Dec 27, 2006 1:25 pm
by wobo
D¡cky wrote: The convertor for SMF 1.1 RC2 is smf 1.1 RC2 convertor

Hmm, unfortunately all this is very confusing. Here's what I did:

1. Installed phpBB 2.0.22, just one user (the admin)
2. Installed SMF 1.1RC2 with a couple of dummy users and a couple of dummy test messages.

Both are in the same database (smf_ and phpbb_ as prefixes). Both are fresh installations without any MODs. I installed the UCS and the converter you mentioned in the quoting, following the README in the UCS zip.

Aside from the confusing hint that this converter is ONLY for SMF 1.0.x and NOT for 1.1x it gives me the error message:

Code: Select all

Couldn't obtain table information.

DEBUG MODE

SQL Error : 1054 Unknown column 'members.ID_GROUP' in 'on clause'

SELECT membergroups.ID_GROUP, membergroups.groupName FROM smf_membergroups membergroups LEFT JOIN smf_members AS ID_GROUP ON members.ID_GROUP = membergroups.ID_GROUP, smf_members members ORDER BY members.ID_GROUP ASC

Line : 711
File : index.php
Any idea what that means and what I can do about it?

wobo

Posted: Thu Dec 28, 2006 9:28 pm
by dennsy
Converted a board ok, now guests cannot post? Eror message 'user name disallowed'?


:?:

Posted: Sat Dec 30, 2006 4:24 pm
by D¡cky
wobo wrote: <snip> it gives me the error message:

Code: Select all

Couldn't obtain table information.

DEBUG MODE

SQL Error : 1054 Unknown column 'members.ID_GROUP' in 'on clause'

SELECT membergroups.ID_GROUP, membergroups.groupName FROM smf_membergroups membergroups LEFT JOIN smf_members AS ID_GROUP ON members.ID_GROUP = membergroups.ID_GROUP, smf_members members ORDER BY members.ID_GROUP ASC

Line : 711
File : index.php
Any idea what that means and what I can do about it?

wobo

The query doesn't work with MySQL 5. It will work on MySQL 4 if you have it available to use.
More reading on this problem, http://www.phpbb.com/phpBB/viewtopic.php?t=441420

dennsy wrote: Converted a board ok, now guests cannot post? Eror message 'user name disallowed'?

:?:

See this topic, http://www.phpbb.com/phpBB/viewtopic.php?t=378041

Re: [BETA] SMF 1.0.x Converter

Posted: Mon May 21, 2007 3:29 pm
by folkestoneforums
I cant even get this thing working lol! I followed the instructions to the letter and when i run the convertor it it navigates to a blank white screen, with the status bar at the bottom saying Done! Any ideas? Cheers Guys!!!

edit: i get this message to:

Fatal error: Call to undefined function: session_pagestart() in /home/******/public_html/forum/con/convert/index.php on line 36

Re: [BETA] SMF 1.0.x Converter

Posted: Sat May 26, 2007 2:32 am
by D¡cky
It appears that you have the convertor folder in the wrong place.

It should be /home/******/public_html/forum/convert/index.php

The convert folder should be in your phpBB root directory

Re: [BETA] SMF 1.0.x Converter

Posted: Sun May 27, 2007 5:48 am
by Merri
For those who consider it, I converted SMF into phpBB3 via phpBB2 nicely. Didn't have too much trouble with the actual conversion. Of course I missed all the attachments and avatars and other small stuff, but they're not essential for forum to work (atleast in the forum I converted).

To get SMF login to work, you only need two changes in includes/auth/auth_db.php:

Code: Select all

FIND: (after midpoint in the file)

if (md5($password_old_format) == $row['user_password'] || md5(utf8_to_cp1252($password_old_format)) == $row['user_password'])

REPLACE WITH:

if (md5($password_old_format) == $row['user_password'] || md5(utf8_to_cp1252($password_old_format)) == $row['user_password'] || md5_hmac($password, strtolower($username)) == $row['user_password'])


FIND: (at end of file)

?>

BEFORE, ADD:

// encrypts password for smf users
function md5_hmac($data, $key)
{
	$key = str_pad(strlen($key) <= 64 ? $key : pack('H*', md5($key)), 64, chr(0x00));
	return md5(($key ^ str_repeat(chr(0x5c), 64)) . pack('H*', md5(($key ^ str_repeat(chr(0x36), 64)). $data)));
}
And that's all that is into it, users can login and their passwords get converted into phpBB3 format.

Re: [BETA] SMF 1.0.x Converter

Posted: Wed Aug 22, 2007 11:28 am
by dreamer2007
Merri wrote:For those who consider it, I converted SMF into phpBB3 via phpBB2 nicely. Didn't have too much trouble with the actual conversion. Of course I missed all the attachments and avatars and other small stuff, but they're not essential for forum to work (atleast in the forum I converted).

To get SMF login to work, you only need two changes in includes/auth/auth_db.php:

Code: Select all

FIND: (after midpoint in the file)

if (md5($password_old_format) == $row['user_password'] || md5(utf8_to_cp1252($password_old_format)) == $row['user_password'])

REPLACE WITH:

if (md5($password_old_format) == $row['user_password'] || md5(utf8_to_cp1252($password_old_format)) == $row['user_password'] || md5_hmac($password, strtolower($username)) == $row['user_password'])


FIND: (at end of file)

?>

BEFORE, ADD:

// encrypts password for smf users
function md5_hmac($data, $key)
{
	$key = str_pad(strlen($key) <= 64 ? $key : pack('H*', md5($key)), 64, chr(0x00));
	return md5(($key ^ str_repeat(chr(0x5c), 64)) . pack('H*', md5(($key ^ str_repeat(chr(0x36), 64)). $data)));
}
And that's all that is into it, users can login and their passwords get converted into phpBB3 format.
Hi,

thank's, but can the new registred membres login in with'nt problem ?

Re: [BETA] SMF 1.0.x Converter

Posted: Thu Aug 23, 2007 10:47 am
by Merri
Yes. It only adds more checks for converting passwords to phpBB3 format.

Re: [BETA] SMF 1.0.x Converter

Posted: Fri Aug 24, 2007 3:43 am
by allchemic
is there any workaround for situation when smf base using utf8, and u get ??????? instead ążćźśńółę (etc) when u converting forum? all other works fine, posts, topics, pw. all goes perfect.

Re: [BETA] SMF 1.0.x Converter

Posted: Fri Aug 24, 2007 3:55 am
by Merri
Look for portions in the convert code that do utf8decode or use iconv to convert to other character sets. Removing all these references should make your board remain UTF-8. My original board happened to be ISO-8859-15 so I didn't have this problem.

Re: [BETA] SMF 1.0.x Converter

Posted: Fri Aug 24, 2007 10:43 pm
by D¡cky
The convertor does nothing to change characters. All characters are transferred over untouched. If you are having a problem with character encoding, then it is a problem with exporting/importing the database or the character collation is not set correctly for the table or fields.

Re: [BETA] SMF 1.0.x Converter

Posted: Wed Sep 19, 2007 3:10 am
by xScopex
I uploaded the convert_smf.php. Then when I go to that link nothing shows up. what am I do wrong???? please help!

Re: [BETA] SMF 1.0.x Converter

Posted: Wed Sep 19, 2007 3:47 am
by D¡cky
Did you get the Common UCS files?

Re: [BETA] SMF 1.0.x Converter

Posted: Wed Sep 19, 2007 7:15 pm
by xScopex
This is what I get now when I try.

Code: Select all

Could not find these tables: smf_banned, smf_instant_messages, smf_im_recipients.

Please check your table prefix and try again.

The default table prefix for SMF 1.0.x is smf_

Re: [BETA] SMF 1.0.x Converter

Posted: Wed Sep 19, 2007 10:48 pm
by D¡cky
What version of SMF are you converting from? If SMF 1.1.x, then you need to use the 1.1.x convertor.