SMF 2.x to phpBB 3.2

[Juju]

As I was trying to convert my own forum from SMF 2.0 to phpBB, I found this thing that only works with phpBB 3.0, I went ahead and made it work on phpBB 3.2.

Here's the result of my work: https://github.com/juju2143/smf2-phpbb-convertor
Download latest version: https://github.com/juju2143/smf2-phpbb- ... master.zip

Be sure to install the extension before installing your board, or at least before converting, and please tell me if you find any issues.

[Blacktiger63]

Great you converted it and we can try this now, but before I try I can already tell you I found an issue before starting to try it.

I had a look at the content of the functions_smf20.php file and found the same problem I found and mentioned in my topic (with the fix).
It's about this statement:

Code: Select all

$message = preg_replace('/\[quote=(.*?)\]/s', '[quote="\1"]', $message);

and 3 similar once right below it. This will cause strange quote text stuff.
You need to replace " by just " to fix this.

I described my issue and this solution in my thread here in the 3rd post:
viewtopic.php?f=561&t=2444941

I will correct this and give it a try to see if I find any other issues also occuring with the older conversion tool (message parser error and img code stuff).

[vero]

Today, I fixed the code and made a pull request to this importer in the repository in Github and it looks like Juju approved it.

[Blacktiger63]

Yep, I've seen it, thank you.
I also noted it as an issue with a link to this thread.

However, this quote was an easy fix. The other issues are a bit more problematic.

[vero]

Care to share what issues you're having with the import programme? I haven't had an opportunity to test it yet, as I am planning on converting a SMF forum to phpBB in a couple weeks so I would like to get this import tool fixed as soon as possible.

[Blacktiger63]

Have a look at github. It's a heavy failure on user conversion.

[SirLouen]

I've been wanting to convert from ages ago, but one of the things that draws me back from converting is that my forum has pretty-urls functionality, and obviously for SEO purposes if I convert and the new forum does not have the exact same urls, there will be hundreds of 404 in my site.

Any ideas on how to manage this?

[gfa-SkyRanger]

Hi,
is there any further information, about how to run this?

Its not clearly explained, how to "run" this convertor.

The readme says

Code: Select all

1. Install your phpBB board
2. Rename the install folder to something else
3. Upload the extension in the ext folder from this repo to the correct location and enable it in the ACP
4. Rename the install folder back
5. Upload the files in the install folder from this repo to the correct location
6. Run the convertor in the installer
7. Delete the install folder
8. Have fun

But on line 6 im stuck.
If i run the installer, its tells me to delete the install folder.
if i run the file "https://[URL]/cms/install/convertors/convert_smf20.php", then i get a white page and nothing happens.

I want to try to convert from smf 2.0.15 to phpBB 3.2.7

any solution there?


thx, SkyRanger

[JeanCremers]

Hi,
Tried to use this mod on a fresh phpbb 3.2 but it doesn't show up in the ACP.
Any ideas? Thank you.

[janus_zonstraal]

Did you put it in /ext/juju2143/smfauth/config

[kjuenke]

Hi,
is there any further information, about how to run this?

Its not clearly explained, how to "run" this convertor.

The readme says

Code: Select all

1. Install your phpBB board
2. Rename the install folder to something else
3. Upload the extension in the ext folder from this repo to the correct location and enable it in the ACP
4. Rename the install folder back
5. Upload the files in the install folder from this repo to the correct location
6. Run the convertor in the installer
7. Delete the install folder
8. Have fun

But on line 6 im stuck.
If i run the installer, its tells me to delete the install folder.
if i run the file "https://[URL]/cms/install/convertors/convert_smf20.php", then i get a white page and nothing happens.

I want to try to convert from smf 2.0.15 to phpBB 3.2.7

any solution there?


thx, SkyRanger

Did you get this to work? I get the white screen too.
I'm not sure how to run the convertor.

[barrypoore]

I have just finished running this convertor and for the most part it appeared to run ok however my users have not been migrated over and I cannot login anymore as admin.

I have tried the new admin user I set up when installing PHPBB aswell as one of the ones from the old SMF forum but none of them login.

I opened the users table in the database and cannot find any of the users in there, in geeksmf_members table I have 43,336 members and none of these appear to have come across, I did encounter the following error during the conversion.

In /Users/xxx/websites/forum/install/convert/convertor.php on line 778
SQL: INSERT IGNORE INTO phpbb_users etc etc
Array ( [message] => Unknown column 'user_pass_convert' in 'field list'

Code: Select all

 => 1054 )

I assume this is what the issue is, can anyone shed any light on this?

I was converting from SMF 2.0.14 to PHPBB 3.2.11

[Mick]

In phpMyAdmin, run the following, which will create an admin user named Admin1 with a password of admin. From that point you should be able to get into the ACP.

Code: Select all

INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_jabber, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin1', 'admin1', 0, '21232f297a57a5a743894a0e4a801fc3', '[email protected]', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '');

Change your table prefix if it is not phpbb_

See Executing SQL Queries in phpMyAdmin if you are unfamiliar with running database queries.

As soon as you have done this, use the temporary admin account to change the details on the original admin account, then delete the temporary account.

This is because:

1. Anyone could use that account to log in to your board if you didn't change the password.
2. This temporary user has not been fully set up (e.g. it is not a member of the "Registered users" group, so it won't have normal access to your forums).

To remove the account you will first need to remove founder status from it:

ACP> USERS AND GROUPS tab> Manage Users> Admin1> Overview> Founder = No

[barrypoore]

Hi, thanks for the info, I've ran the query and generated the user, once submitting the login button a mysql error is now returning, so I'll need to try and investigate that apre:

SQL ERROR [ mysqli ]

Unknown column 'user_pass_convert' in 'field list' [1054]