The PHPBB => SMF convertor

[Kerux]

Is there any special way to have your forum set up for this to work? I have tried it with 2 separate MySQL databases the phpbb on one and the SMF forum on the other, it said everything went through perfectly, yet when I clicked back to my forum, nothing at all was there.  Do they have to be on the same SQL and just different users? I haven't had much time to examine the php file to see what its actually doing, so any relate, helpful info would be appreciated

[[Unknown]]

The user SMF is running on needs to have access to both databases.  You will also need to go to Admin -> Forum Maintenance -> recount totals to get things working properly.

-[Unknown]

[Kerux]

The database user or the admin forum user?  I tried to use the same user on both databases and it said that the one already exists so counted add it to the other data base *shrug* I have a few ideas that I am going to try on my extra few databases Hopfully i can figure it out myself if not I just might go ahead and try out my credit card and sign up as a charter member lol and have someone do it for me lol

Thanks so far for all the help.

[[Unknown]]

I'm willing to help you with the conversion if you can't get it to work, but it would mean giving me your password to cpanel and ftp.

-[Unknown]

[Kerux]

I fittled with it and just got upset again LoL i deleted all but 2 of my databases and sent you all the nessisary info.
Thanks for your help. 

[Kerux]

* Kerux kicks computer *

Normally I am pretty level headed with stuff, but this is getting to be a little nerving. I am doing a fresh install of 1 beta 4.1 (some reason beta 5 wont do a straight install due to other problems with my host's settings) then going to upgrade, then think about trying to convert....

[Oldiesmann]

One thing I found when upgrading someone's phpBB: phpBB allows certain characters in usernames that SMF doesn't, such as spaces, commas and apostrophes, so make sure you run these queries after you update if you have any members with these "forbidden" characters in their names:

Code Select Expand

#Replace all spaces with underscores
UPDATE smf_members SET memberName=replace(memberName,' ','_'), realName=replace(realName,' ','_');

#Strip out commas
UPDATE smf_members SET memberName=replace(memberName,',',''), realName=replace(realName,',','');

#Strip out apostrophes
UPDATE smf_members SET memberName=replace(memberName,'\'',''), realName=replace(realName,'\'','');

Apostrophes cause all kinds of problems, and so do spaces. Commas don't cause as many problem, but keep you from being able to set that person as a moderator (since you can seperate the names of moderators with commas), and might cause other problems.

[Grudge]

Hey,

Believe it or not I was working on adding this to the converter for the last 30 minutes (yes - it did take me that long!). Anyway - I added this line to the converter before the dat is changed:

Code Select Expand


$row['memberName'] = preg_replace('/[^\s0-9A-Za-z#,-\.:=?@^_äöéèöüçåãâáàßêìíîïðñòóôõøùúûýÿ]/is', '-', $row['memberName']);


and that seems to work - replacing everything illegal with a hypen I hope :|

[Oldiesmann]

I think replacing spaces with _ and stripping the rest is more fun

[Kerux]

Hey,

Believe it or not I was working on adding this to the converter for the last 30 minutes (yes - it did take me that long!). Anyway - I added this line to the converter before the dat is changed:

Code Select Expand


$row['memberName'] = preg_replace('/[^\s0-9A-Za-z#,-\.:=?@^_äöéèöüçåãâáàßêìíîïðñòóôõøùúûýÿ]/is', '-', $row['memberName']);


and that seems to work - replacing everything illegal with a hypen I hope :|

And this makes it better yes?

[Oldiesmann]

Yep. That will replace any character that SMF might see as "illegal" in a username with a hyphen. You can remove the "0-9" part of the query since SMF shouldn't have a problem with numbers in the username.

[Grudge]

Oldiesman. The bits in the brackets are the ALLOWED characters. Removing 0-9 will remove digits from anyones username!

[Oldiesmann]

Oh... Sorry Grudge. I thought the preg_replace function was similar to the MySQL REPLACE function.

[[Unknown]]

It is, but this:

[^...]

Means any character NOT in that list.

-[Unknown]

[Kerux]

I ran the convertor, and it succesfully copied all my users, private messages, profiles, off-site avatars, categories, boards and post counts. But no posts. *chuckles* And that was when trying to go from PHPBB 2.0.8 to SMF 4.1

The convertor didnt report back ANY errors.....any ideas?

[Oldiesmann]

When I ran it, I was converting a phpBB 2.06 board (I think), and the only thing that it didn't convert were moderators and permissions, and the "recount stats" thing didn't work either, although that might have been due to illegal characters in some of the nicknames.

[Kerux]

* Kerux is desperate, because he wants to be running an SMF board

agian....I plead LoL. What can I do to get it to convert the messages and polls? mods and permissions i can do myself and am not really interested in converting, but the thing that seems like it would be hard to do by hand is the messages and polls. and thats the only thing that didnt copy (that i see) even though there were no errors.  i would convert them by hand if i could.

Converting...
Converting members... successful.
Converting categories... successful.
Converting boards... successful.
Converting topics... successful.
Converting messages... (this may take some time) successful.
Converting polls... successful.
Converting poll options... successful.
Converting previous poll votes... successful.
Converting personal messages... successful.
Converting personal messages (step 2)... successful.
Converting topic notifications... successful.
Recalculating forum statistics... successful.

[[Unknown]]

Very strange.  Have you tried going to:

Admin -> Forum Maintenance -> Find and repair any errors.

-[Unknown]

[Kerux]

yup

The following errors are fouling up your forum (blank if none):
Topic 2 contains no messages
Topic 4 contains no messages
Topic 5 contains no messages
Topic 9 contains no messages
Topic 11 contains no messages
Topic 12 contains no messages
Topic 14 contains no messages
Topic 15 contains no messages
Topic 17 contains no messages
Topic 18 contains no messages
Topic 21 contains no messages
Topic 23 contains no messages
Topic 26 contains no messages
Topic 27 contains no messages
Topic 29 contains no messages
Topic 30 contains no messages
Topic 31 contains no messages
Topic 32 contains no messages
Topic 33 contains no messages
Topic 34 contains no messages
Topic 35 contains no messages
Topic 36 contains no messages
Topic 37 contains no messages
Topic 38 contains no messages
Topic 39 contains no messages
Topic 40 contains no messages
Topic 41 contains no messages
Topic 45 contains no messages
Topic 46 contains no messages
Topic 47 contains no messages
Topic 49 contains no messages
Topic 50 contains no messages
Topic 51 contains no messages
Topic 52 contains no messages
Topic 53 contains no messages
Topic 54 contains no messages
Topic 55 contains no messages
Topic 56 contains no messages
Topic 57 contains no messages
Topic 59 contains no messages
Topic 60 contains no messages
Topic 61 contains no messages
Topic 62 contains no messages
Topic 64 contains no messages
Topic 65 contains no messages
Topic 66 contains no messages
Topic 67 contains no messages
Topic 69 contains no messages
Topic 71 contains no messages
Topic 72 contains no messages
Topic 73 contains no messages
Topic 74 contains no messages
Topic 75 contains no messages
Topic 76 contains no messages
Topic 78 contains no messages
Topic 79 contains no messages
Topic 80 contains no messages
Topic 81 contains no messages
Topic 84 contains no messages
Topic 85 contains no messages
Topic 87 contains no messages
Topic 88 contains no messages
Topic 89 contains no messages
Topic 90 contains no messages
Topic 91 contains no messages
Topic 92 contains no messages
Topic 94 contains no messages
Topic 95 contains no messages
Topic 96 contains no messages
Topic 98 contains no messages
Topic 99 contains no messages
Topic 100 contains no messages
Topic 101 contains no messages
Topic 102 contains no messages
Topic 103 contains no messages
Topic 105 contains no messages
Topic 106 contains no messages
Topic 108 contains no messages
Topic 109 contains no messages
Topic 110 contains no messages
Topic 111 contains no messages
Topic 112 contains no messages
Topic 113 contains no messages
Topic 114 contains no messages
Topic 115 contains no messages
Topic 117 contains no messages
Topic 118 contains no messages
Topic 119 contains no messages
Topic 120 contains no messages
Topic 121 contains no messages
Topic 122 contains no messages
Topic 124 contains no messages
Topic 125 contains no messages
Topic 126 contains no messages
Topic 127 contains no messages
Topic 128 contains no messages
Topic 129 contains no messages
Topic 130 contains no messages
Topic 131 contains no messages
Topic 132 contains no messages
Topic 133 contains no messages
Topic 134 contains no messages
Topic 135 contains no messages
Topic 137 contains no messages
Topic 138 contains no messages
Topic 139 contains no messages
Topic 140 contains no messages
Topic 141 contains no messages
Topic 142 contains no messages
Topic 143 contains no messages
Topic 144 contains no messages
Topic 145 contains no messages
Topic 146 contains no messages
Topic 147 contains no messages
Topic 148 contains no messages
Topic 149 contains no messages
Topic 150 contains no messages
Topic 151 contains no messages
Topic 152 contains no messages
Topic 153 contains no messages
Topic 154 contains no messages
Topic 155 contains no messages
Topic 157 contains no messages
Topic 158 contains no messages
Topic 159 contains no messages
Topic 160 contains no messages
Topic 161 contains no messages
Topic 163 contains no messages
Topic 164 contains no messages
Topic 165 contains no messages
Topic 166 contains no messages

Would you like to fix these errors?

131 topic(s) without messages have been removed successfully

All errors fixed! You will want to check on any created categories, boards, or topics to decide what to do with them.

you can tell there is a major difference LoL
http://www.treysdomain.org/forum/  <phpbb
http://www.treysdomain.org/lighthouse/ <SMF

[[Unknown]]

Do you want to send me your FTP password (again I think :/, I delete them so they don't pose problems for people...) and I can try it?

-[Unknown]

[Kerux]

sure