News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

[SMF Converter] phpBB - 2.0.19+

Started by JayBachatero, January 13, 2007, 02:47:08 AM

Previous topic - Next topic

ThorstenE

Squash, which version of phpbb2_to_smf.sql are you using? the phpbb2_to_smf.sql from the first post (attached) of this topic should work..

Squash

#561
Quote from: TE on August 19, 2008, 12:05:24 PM
Squash, which version of phpbb2_to_smf.sql are you using? the phpbb2_to_smf.sql from the first post (attached) of this topic should work..

I believe it's the one from here..... I am not positive to be honest.

Can you provide me the proper link since I believe i have tried the proper one.

Thanks in advance...this issue is driving me crazy...it actually imported posts up to 2007 but nothing after  :-X



It is the one from here...i downloaded it and replaced the other on my server...still the same error

It seems to have duplicate issues

ThorstenE

this one should work:
http://www.simplemachines.org/community/index.php?action=dlattach;topic=142124.0;attach=61756
the posts are converted with $ignore = true; as argument.. this means all INSERTS have the parameter IGNORE and Duplicates will be skipped without warning..

if the trouble continues you can edit the phpbb2_to_smf.sql with a texteditor and change:
---* {$to_prefix}messages 200
to
---* {$to_prefix}messages 100
This will make the converter only do 100 posts at time. This should hopefully help and let you get through the posts conversion.

Squash

Thanks for the link...

I downloaded the right one possibly now.....it's slowly going thru all of them. Before that it would start and error right away. I'm hoping this is a good sign. 8)

I'm guessing this can take awhile? I had over 150,000 posts or so on the forum. This may be awhile, and thanks for the help....I'm a technical spazz

Squash

I got this error after it had been going for 40 minutes or so...any ideas?

"Got a packet bigger than 'max_allowed_packet' bytes"

SleePy

You could either edit your my.cnf (you need root server access) to increase that variable and restart mysql.

Or for the section you are converting currently, you could lower the number of posts,topics,members,what ever it is doing to a smaller chunk of data.
This will make conversion take a little bit longer, but should hopefully prevent this.

I have seen this happen from time to time with posts or pms that are really big.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Squash

Okay so I reduced it to 100 and I still error about 142000 posts in.

I get this message again
"Caused the error:
Got a packet bigger than 'max_allowed_packet' bytes"

I'm guessing but could be wrong on this. I have some single posts that are news letters type posts, that my site does weekly. They are huge at times and I could be wrong but is there some sort of word limit setting? It seems to stall on these long long posts each time.

Any help would be great. Is there something I can edit again?

ThorstenE

try 50 messages at the same time.. (this will make the conversion procecc really slow)
---* {$to_prefix}messages 50
another option would be to install a local webserver (XAMPP for example and do it local) or to contact your host and ask him, if he can (temporary) increase the 'max_allowed_packet' parameter from MySQL.

Squash

I'll give 50 a try.....I'll leave it running overnight if need be.

It has stalled twice on the same spot and same error...so if 50 doesn't work I'll contact my host.

Thanks

Squash

Fifty fail so I'm taking one last try at 25 and then I'll contact my host on the issue and ask them to increase the size.....

It again got stuck on about the same spot >:(

SleePy

It is most likely a message that is really really big. MySQL isn't liking the size of the message.

If you look at your url. You will see a substep=####
That is the id of the last message it worked on before it did the timeout protection.
You can use that and work your way up from there to figure out which message is causing this.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Squash

Interesting enough it failed again but all the data made the move!!!!!

Lucky me

Squash

Quote from: Squash on August 21, 2008, 02:32:31 AM
Interesting enough it failed again but all the data made the move!!!!!

Lucky me

I wanted to take the time to say thanks for the help on converting over. I have been using SMF now for less than 2 solid days and have to say it beats the hell out of my old phpBB board hands down. The fact I'm not getting 25 spambots a day signing up is sweet!!!!

Thanks for the help 8)

allymcbeal

Quote from: TE on August 15, 2008, 11:59:19 AM
maybe it's cause from:
GROUP BY vote_id, vote_user_id;

try the attached version..
I try, now in the older poll I can see the voter from the 15 august 2008 (I say this date because the last vote is about this day) but not the voter older.

void4ever

I'm looking to convert from a phpBB board ver. 2.0.22 with the following mods.
Topic Calendar - Categories Hierarchy by Ptirhiik 2.2.2
Categories hierarchy by Ptirhiik 2.1.1 RC5
As well as some minor mods, an advanced user search, and extented templates.

Would the converter on page 1 be a good place to start, or perhaps some of the other various links i've seen in this thread?

Also are there any recommended mods i should install to SMF before attempting to convert a php board with the mods i have on it?

Thanks for any info guys!!

Void4ever

ThorstenE

the best choice would be starting with the version on the first page and a blank, fresh installed SMF.. ..

void4ever

Sounds like a plan, i'm sure i'll be back soon :)

Void4ever

void4ever

So aside from calendar events not being linked to threads, subfolders, and ranks, everything looks pretty good. I honestly didn't expect the calendar thing, nor the subfolders since those were plugins to phpbb. And instead of being a subfolder they are just all thrown into the main page. I can edit that no problem.

The ranks installed themselves over membergroups which i assume is what SMF uses, though in phpbb ranks weren't used for permissions of any type, just something fun to put under peoples names. It looks like the same can be done here as well just not setting any permissions.

It's unfortunate that every single rank came through with a phpbb in front of it, here's an example:
phpBB Bacon of Light
phpBB Barbaric Warlord
phpBB Beast Knight
phpBB Beauty Queen

I'm willing to bet it has something to do with the plugins installed on phpbb though. Not a huge deal to manually edit, just a lot of them to do :P

I want to thank everyone whos worked on this converter, excellent job!

Void4ever

SleePy

The converter prefixes all membergroups with phpBB, as to not get groups confused for common groups such as Admins and moderators.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

void4ever

Ahhh i understand then.

One more question if you don't mind. I'm trying to wrap my head around permissions vs (what i call) ranks, or member groups i guess.

Like i said on my phpbb boards we had fun little messages (ranks) the admins could set below someones name in a post (like the ones above). They had no effect on board permissions however.

Am i able to do the same thing with the member groups in SMF, and just use the permission section for board settings? Or am i looking for some type of plugin?

void4ever

Void4ever

Advertisement: