[BETA] SMF 1.1 RC2 Converter - Including update for vB 3.5

[zix]

There is an error with yabb to SMF converter.

Pls fix.

Code Select Expand


Warning: file($boarddir/Variables/Settings.pl): failed to open stream: No such file or directory in /home/livingth/public_html/smf/yabb2_to_smf.php on line 94

Warning: Invalid argument supplied for foreach() in /home/livingth/public_html/smf/yabb2_to_smf.php on line 95
Converting membergroups...
Warning: file($boarddir/Variables/membergroups.txt): failed to open stream: No such file or directory in /home/livingth/public_html/smf/yabb2_to_smf.php on line 116

Warning: Invalid argument supplied for foreach() in /home/livingth/public_html/smf/yabb2_to_smf.php on line 117
Successful.
Converting members... Unsuccessful!
This query:

    ALTER TABLE `livingth_smf2`.smf_members
    DROP PRIMARY KEY,
    CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL default 0;

Caused the error:

    Can't DROP 'PRIMARY'; check that column/key exists

[JayBachatero]

You need to use the .sql file along with the convert.php.  The convert.php is located here in this topic and the .sql is at 1.1 Converters topic.

[zix]

for yabb 2, there are only .php converters. I tried with the converter only, but it doesnt work. I get those errors.

My version of yabb is 2.1

[JayBachatero]

My mistake.  It's mixed in with the .sql so I though that converter file was a .sql also.  I've never done a YaBB conversion.  I'll take a look into it.

[Yellowrose]

may be a silly question but need to ask anyway. How are these converters for converting a very large number of posts like say 98,000

[JayBachatero]

It shouldn't have a problem.  You can give it a try.  The converter doesn't touch your live forum.

[pushkin22]

Hi,

I want to convert from MyBB 1.1 to SMF and I have some questions about the conversation...

What about the passwords? Should the users request new passowords or are the old passwords converted?
And what happens with avatars and smilies? Are they converted/transfered too?


PS: Sorry for my bad english... 

[J. Williams]

If SMF uses same password encryption as MyBB, you should be fine. If not, you'd have to reset everyone's password

[JayBachatero]

The members have to reset their password.

[jkrlvgn]

So, I used the converter (both from Grudge, and the one from Jay), and I keep getting this in the forums...not sure if there's anything that can take care of this or not...

It looks something like this....



Where the "[img src=\ " starts and ends.  If it was just this post, it'd be one thing.  But other posts do about the same thing...like..with quotes.

Does it matter if I was using 2.1.6 on IPB?  I wasn't sure...


EVERYTHING else, though, is great.  Maybe someone can help me out, at least with what I can do to take out the messy looking code, if not converting it.

[JayBachatero]

Which .sql file did you use?

[jkrlvgn]

The one at the beginning of this thread: 

Code Select Expand

http://www.simplemachines.org/community/index.php?topic=65677.0

With the convert.php that was linked there too.  The other convert.php had the problem with coverting the statistics and all....somehow left me with a blank forum when I double checked to see if it worked.  So, I was like..."Oh.  There's NEW files HERE."

I downloaded them, erased the stuff on the other board, just to be sure, and then converted again with the -new- one, and everything was successful, except for the smileys and the quotes.  Also noticed that some of the http:// links embedded in the code tags lost the "h" in "http".

That I'm not worried about.  If it weren't so many posts that were quoted, I wouldn't worry about the other either...but there are a LOT of quote tags, especially with mine.

I'm not much of a coder, but I think I could modify whatever it is that needs to be modified....or....if I used the wrong files (again!), then maybe you could point me in the right direction?

[JayBachatero]

No the quote is still not working right.  The guys over at phpfreaks.com converted to SMF recent;y and they are having the same error.

[jkrlvgn]

Bah...damn you, IPB!!!!!  CURSE YOU AND YOUR COMPLICATED EVILNESS!!!


.........anyway......umm..ok.  So, basically, we don't know exacty why it is, just that it is.  So, the best way to take care of it is to do it manually, or...just leave it as it is.

I mean, the "code" tags work.  They work beautifully...and..I kinda thought they were almost the same.  Then again, I'm not a coder...so...I wouldn't know, right?

Blah.  *LOL* Anyway...I'm getting another drink.   Maybe it'll come to me in a dream.  If it does, before you guys know, I'll message ya to tell you...but...I doubt it.  More than likely it'll be something that's SO simple that it wasn't though of yet.

Ok..well..I'll just check back and see if it gets fixed.  Everything else, though, works perfectly.  And that's awesome.


Thanks!!

[JayBachatero]

The problem is that IPB parses the code and then inserts it to the database.  In SMF the BBC code is inserted to the database and parsed on the fly.

[crazyhorse]

Reese this conveter is only to convert to SMF 1.1 RC2.

-JayBachatero

that's right, and I've the SMF 1.1 RC2
But I want to convert from IPB 2.0.4...what sql file I need to use?

tnx

[JayBachatero]

Try the one on the 1.1 Converters topic.

[madness]

Conversion was successful. Thank you SMF! I used to think Invision was better until I had to mod the hell out of it to get good features. ty again

[jkrlvgn]

OK!  Here's how I fixed -my- problem...most of you should be able to fix it your way too, just in case you're having the same one I was.



It seems that when converting a forum from IPB to SMF (I'm not sure about the other forums), it parses the code differently, or something.

And, actually, I answered my own question with this...granted, it might not be the same fix, but it should help out with forums in my situation.


I had an idea ahead of time that I'd have to do some manual deletions through the database...and I figured out how to replace/delete strings of text, HOWEVER I couldn't do it with the quotes, like in this string:

[img src=\"style_emoticons/[#EMO_DIR#]/biggrin.gif\" style=\"vertical-align:middle\" emoid=\"\" border=\"0\" alt=\"biggrin.gif\" /]

It was really starting to bug me....and then I figured it out.  If I remove the quotes first, then I could remove the string that was left, and still keep my smileys where they're supposed to be.  So...I set up a query in mySQL:

Code Select Expand

update smf_messages set body = REPLACE(body, '"', '');

Basically, that removes all quotes in the given field, in this case the BODY (which is where the actual messages are kept).  On my forum, we're not using quotes - " , so it's no big deal.  After that was done, it left my problem string as:

[img src=\style_emoticons/[#EMO_DIR#]/biggrin.gif\ style=\vertical-align:middle\ emoid=\\ border=\0\ alt=\biggrin.gif\ /]

From here, I just took out the elements in parts of what I wanted to delete.  In this case, I wanted to keep the smiley, because that's what was in this message in the original forum.  SO.....the next query I ran was:

Code Select Expand

update smf_messages set body = REPLACE(body, '[img src=\\style_emoticons/[#EMO_DIR#]/biggrin.gif\\ style=\\vertical-align:middle\\ emoid=\\', '');

...and that got rid of the first part of the string.  So...what was left was:

\ border=\0\ alt=\biggrin.gif\ /]

Which is PARTIALLY right, because you can see the smiley up front now...but, it's got a hell of a tail, so I needed to go ahead and take out the rest of the string like before:

Code Select Expand

update smf_messages set body = REPLACE(body, '\\ border=\\0\\ alt=\\biggrin.gif\\ /]', '');


Which left me with:



And...there we have it.  Of course, I had to do it with the other emoticons too, but it was MUCH easier than trying to weed through every message to get out that extra text.

Anyway, just thought I'd share!!!

Thanks!!

[JayBachatero]

Thanks for sharing this jkrlvgn.  IPB store all BBC tags in a weird way.  I don't know why they do it like this.