[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.
Scam Warning
oojacoboo
Registered User
Posts: 12
Joined: Wed Nov 07, 2007 11:19 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by oojacoboo »

O whoops, sorry about that...

SMF - 1.1 RC3

As for the admin users, yes, I have others, one being myself, which didn't get imported into the database. The others I don't have passwords for and changing the passwords don't appear to be helping. I converted with md5 and input directly into the db, but it doesn't accept...
7earitup
Registered User
Posts: 22
Joined: Thu Nov 08, 2007 6:36 am
Location: Somewhere.
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by 7earitup »

Hello, I am new here (obviously), and I tried this converter. I get this error:

Code: Select all

SQL ERROR [ mysql4 ]

Incorrect string value: '\xF8ath g...' for column 'config_value' at row 1 [1366]

SQL

UPDATE phpbb_config SET config_value = 'under�ath gaming community' WHERE config_name = 'sitename'

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/functions.php
LINE: 147
CALL: dbal_mysql->sql_query()

FILE: install/convertors/functions_smf11.php
LINE: 2213
CALL: set_config()

FILE: install/install_convert.php(1004) : eval()'d code
LINE: 2
CALL: smf_conv_file_settings()

FILE: install/install_convert.php
LINE: 1004
CALL: eval()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 402
CALL: install_convert->main()

FILE: install/index.php
LINE: 274
CALL: module->load()
Any help on how to fix this would be greatly appreciated. Thanks! ;)
7earitup/Tearitup/Brent
http://www.go-diaf.com
dkarlovi
Registered User
Posts: 23
Joined: Mon Sep 24, 2007 11:28 am

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by dkarlovi »

rhuk wrote:Well done Jelly! Just want to thank Dicky, Nils, and Jelly for making this happen. It's been a real pleasure testing/debugging this with you guys.
Hey, will this converted forum work with RW's J1.5 bridge? Anyway, I'm just running the converter, no errors yet, I'll report back when it's done.
vtx666
Registered User
Posts: 9
Joined: Wed Oct 03, 2007 2:39 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by vtx666 »

Ok, the conversion took like 5 hours, but is complete now.

Topics, posts and permissions, smilies and attachments look good on a first look.

Avatars however aren't converted like they should. The files are there (in images/avatars/gallery while I think they should be in images/gallery/upload), but they don't show up in the forum.
bluenix
Registered User
Posts: 4
Joined: Thu Nov 08, 2007 1:41 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by bluenix »

Hi! It's great to have a convertor for SMF!
However, while converting, I run into some problems. When proceeding to the last step, I get the following error:

Code: Select all

SQL ERROR [ mysql4 ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: includes/db/dbal.php
LINE: 372
CALL: dbal_mysql->sql_error()

FILE: install/convertors/functions_smf11.php
LINE: 227
CALL: dbal_mysql->sql_in_set()

FILE: install/install_convert.php(1653) : eval()'d code
LINE: 2
CALL: smf_convert_authentication()

FILE: install/install_convert.php
LINE: 1653
CALL: eval()

FILE: install/install_convert.php
LINE: 800
CALL: install_convert->jump()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 402
CALL: install_convert->main()

FILE: install/index.php
LINE: 274
CALL: module->load()
My SMF version is 1.1.4 and I'm trying to convert to a fresh install of phpBB 3 RC7

Any ideas on this?
Thanks in advance!
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 »

oojacoboo wrote:O whoops, sorry about that...
SMF - 1.1 RC3
My only thought is that SMF's database structure changed between RC3 and 1.1.3 (where I designed this convertor). I would be willing to take a look at your database to see if I can spot the failure. I'd need a link where I can download the database, and of course PM would be the best way to receive that :)
7earitup wrote:Hello, I am new here (obviously), and I tried this converter. I get this error:

Code: Select all

    SQL ERROR [ mysql4 ]

    Incorrect string value: '\xF8ath g...' for column 'config_value' at row 1 [1366]

    SQL

    UPDATE phpbb_config SET config_value = 'under�ath gaming community' WHERE config_name = 'sitename'

[blah blah blah] 
Any help on how to fix this would be greatly appreciated. Thanks! ;)
That is a slight bug in the convertor...I was not expecting UTF-8 characters in the site name. I can offer a quick fix for functions_smf.php, find, around line 2227:

Code: Select all

	set_config('sitename', smf_setting('mbname'));
Replace With

Code: Select all

	set_config('sitename', smf_set_encoding(smf_setting('mbname')));
dkarlovi wrote:Hey, will this converted forum work with RW's J1.5 bridge? Anyway, I'm just running the converter, no errors yet, I'll report back when it's done.
My understanding is that the RocketWerx bridge is designed to work with any phpBB3 system.
vtx666 wrote:Ok, the conversion took like 5 hours, but is complete now.

Topics, posts and permissions, smilies and attachments look good on a first look.

Avatars however aren't converted like they should. The files are there (in images/avatars/gallery while I think they should be in images/gallery/upload), but they don't show up in the forum.
The time isn't particularly surprising. For larger boards, it is usually more efficient to run the conversion on your local computer.

As far as the avatars, I don't see why they would be moved into the gallery directory by looking at the code. If you manually move them into the "upload" folder, do they work?

Bluenix: that error means the convertor was unable to find any administrators on your SMF Board. I assume there are some, so perhaps you are having a similar problem as oojacoboo above. What version of SMF is your board running?
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
vtx666
Registered User
Posts: 9
Joined: Wed Oct 03, 2007 2:39 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by vtx666 »

I moved them manually but they still don't work.

Weird thing is that some users have avatars, but those are really old avatars, not the current ones they use at the moment. But most users have no avatars.

The time really doesn't matter to me, I'm really glad with this converter! It work really really well! Thanks again!
bluenix
Registered User
Posts: 4
Joined: Thu Nov 08, 2007 1:41 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by bluenix »

oojacoboo wrote: Bluenix: that error means the convertor was unable to find any administrators on your SMF Board. I assume there are some, so perhaps you are having a similar problem as oojacoboo above. What version of SMF is your board running?
My SMF version is 1.1.4 and I'm trying to convert to a fresh install of phpBB 3 RC7
oojacoboo
Registered User
Posts: 12
Joined: Wed Nov 07, 2007 11:19 pm

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by oojacoboo »

looking through the changelog of SMF since RC3, I see some potential changes that may make a difference.

! Some columns containing message ID's were not formated as unsigned integers. (Search.php, ManageSearch.php, upgrade_1-1.sql, install_1-1.sql)

! Some dates in the installation script were not MySQL STRICT compatible. (install-1.1.sql)

! Prevent strict notices appearing in PHP 5.1 caused by not setting a default timezone. (Load.php, install.php, upgrade_1-1.sql) *I am on 5.2.4*

I would just upgrade my version of SMF, but that would break the bridge that I am currently running. Does any of these changes look suspicious to you?
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:My understanding is that the RocketWerx bridge is designed to work with any phpBB3 system.
Mine too but it doesn't hurt to ask. ;)

Anyway, I did the convert, it did last long but for now I found no problems (granted, haven't really checked yet), avatars are there, my "weird" chars are there (I've been running ISO-8859-2 site), permissions, the works.

Really great, great work. Hat of to you and Dicky.
7earitup
Registered User
Posts: 22
Joined: Thu Nov 08, 2007 6:36 am
Location: Somewhere.
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by 7earitup »

Thanks for the help Jelly - I got a little further this time, BUT I get this error now:

Code: Select all

SQL ERROR [ mysql4 ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: includes/db/dbal.php
LINE: 372
CALL: dbal_mysql->sql_error()

FILE: install/convertors/functions_smf11.php
LINE: 227
CALL: dbal_mysql->sql_in_set()

FILE: install/install_convert.php(1653) : eval()'d code
LINE: 2
CALL: smf_convert_authentication()

FILE: install/install_convert.php
LINE: 1653
CALL: eval()

FILE: install/install_convert.php
LINE: 800
CALL: install_convert->jump()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 402
CALL: install_convert->main()

FILE: install/index.php
LINE: 274
CALL: module->load()
Any more fixes for this? Thanks again! :D
7earitup/Tearitup/Brent
http://www.go-diaf.com
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 »

7earitup & Bluenix: There is a problem converting administrator's permissions that you are both experiencing. Since I cannot produce the problem, could you try this code change please?
In functions_smf.php, around line 218, find

Code: Select all

			if (preg_match('#(^1,|,1,|,1$)#', $row['additionalGroups']) || $row['ID_GROUP'] == 1)
Replace With

Code: Select all

			if (preg_match('#(^1,|,1,|,1$)#', $row['additionalGroups']) || $row['ID_GROUP'] == 1 || $row['additionalGroups'] == 1)
If you still get the same error, try this instead:

Code: Select all

print_r($row);
			if (preg_match('#(^1,|,1,|,1$)#', $row['additionalGroups']) || $row['ID_GROUP'] == 1 || $row['additionalGroups'] == 1)
The second bit should display some debugging information that should help me identify the problem more precisely. Please send it to me, either through PM or on this topic :)
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
7earitup
Registered User
Posts: 22
Joined: Thu Nov 08, 2007 6:36 am
Location: Somewhere.
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by 7earitup »

Getting this now:

Code: Select all

SQL ERROR [ mysql4 ]

[0]

SQL

No values specified for SQL IN comparison

BACKTRACE

FILE: includes/db/dbal.php
LINE: 372
CALL: dbal_mysql->sql_error()

FILE: install/convertors/functions_smf11.php
LINE: 228
CALL: dbal_mysql->sql_in_set()

FILE: install/install_convert.php(1653) : eval()'d code
LINE: 2
CALL: smf_convert_authentication()

FILE: install/install_convert.php
LINE: 1653
CALL: eval()

FILE: install/install_convert.php
LINE: 800
CALL: install_convert->jump()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 402
CALL: install_convert->main()

FILE: install/index.php
LINE: 274
CALL: module->load()
I know your tired of me :lol:
7earitup/Tearitup/Brent
http://www.go-diaf.com
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 »

Is that with the first or second change I provided? I'm hoping the first one :P
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish
7earitup
Registered User
Posts: 22
Joined: Thu Nov 08, 2007 6:36 am
Location: Somewhere.
Contact:

Re: [BETA] SMF 1.1 to phpBB3 Convertor

Post by 7earitup »

A_Jelly_Doughnut wrote:Is that with the first or second change I provided? I'm hoping the first one :P
If I did it right, the second. :?

EDIT: Also, if you'd prefer, I can PM you or IM you on MSN/AIM if you have those.
7earitup/Tearitup/Brent
http://www.go-diaf.com
Locked

Return to “[3.0.x] Convertors”