Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: boris on December 14, 2006, 07:01:08 AM

Title: YaBB Gold converter does NOTHING at all
Post by: boris on December 14, 2006, 07:01:08 AM
SMF Version: SMF 1.1
I tried to convert from Yabb Gold 1.3 to SMF 1.1 using the latest converter.

After entering the correct paths and password, I immediately receive
  Converting...
  Successful.
  Recalculating forum statistics... Successful.
and nothing has been converted at all. Even if I omit the MySQL password or enter invalid paths, the result is the same. Obviously the converter does nothing.

Server: Apache 1.3 - PHP5.2 runinning on Winn2000 (local test server)

Any ideas??

Title: Re: YaBB Gold converter does NOTHING at all
Post by: JayBachatero on December 14, 2006, 09:21:26 AM
This is an issue if your sessions are not being saved.  Who is your hosting company?
Title: Re: YaBB Gold converter does NOTHING at all
Post by: boris on December 14, 2006, 06:03:31 PM
My hosting company, in this case, is me, myself & I !
I have set up SMF on my local machine, and it seems to run without problems.
Well, except for the converter.

Ok, this may be a configuration problem with Apache or PHP. I confess I am not really a pro in this field, could someone help me out?
Currently Apache & PHP are running the default configuration.
Title: Re: YaBB Gold converter does NOTHING at all
Post by: JayBachatero on December 14, 2006, 11:09:27 PM
Are you running windows or linux?
Title: Re: YaBB Gold converter does NOTHING at all
Post by: boris on December 15, 2006, 04:51:10 AM
As stated above (nevermind the spelling mistakes)  ;D

OK, I repeat: I am running an Apache 1.3 with PHP 5.2 on a Windows 2000 machine.
Title: Re: YaBB Gold converter does NOTHING at all
Post by: boris on December 15, 2006, 05:33:46 AM
You have got me on the right track!
session.save_path in php.ini was pointing to a non-existant folder!

A partial success:
I reached Step1, but:
Converting...
Converting membergroups... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_membergroups
    (groupName, onlineColor, minPosts, stars)
    VALUES (SUBSTRING('Forum Founder', 1, 80), '', -1, '';

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

But thats better than nothing, isn't it?

The YaBB forum was heavily modded, so there could be some incompatibilities...
I will now look into the converter code to see if I can fix this issue.

I'll keep you informed!
Title: Re: YaBB Gold converter does NOTHING at all
Post by: JayBachatero on December 15, 2006, 08:31:51 AM
The stars and online colors are not being converted.  Might be a problem with converter.
Title: Re: YaBB Gold converter does NOTHING at all
Post by: boris on December 15, 2006, 11:41:06 AM
It IS a problem with the converter: simply a bug (bracket missing near the end of the statement in line 166). The bug is only triggered if there are additional membergroups.

I have found a few other problems, and I am going to fix them next week. Once I get to the last step, I'm going to send you the script that worked.
Title: Re: YaBB Gold converter does NOTHING at all
Post by: JayBachatero on December 15, 2006, 11:58:14 AM
Oh that's great thanks :).
Title: Re: YaBB Gold converter does NOTHING at all
Post by: boris on December 22, 2006, 04:18:32 PM
OK there we are...
Attached is the script that finally did it!

All changes are commented, just search for 'bug'. I also added support for the LastVisit mod.

Another issue that almost drove me crazy:
If you are logged in when you start the converter, and you check "delete users & messages", you won't be able to log in afterwards, unless you delete the SMF cookie manually!!
The reason is: The converer deletes the admin user you have established during the installation, but you still have the cookie set. Now when SMF checks the cookie, it sees ID_MEMBER=0, although you are trying to log in with another ID, and issues the "Check your cookie settings" message.

Title: Re: YaBB Gold converter does NOTHING at all
Post by: JayBachatero on December 23, 2006, 01:34:52 PM
Thanks for providing the changes that you made.  I'll look into implementing these changes to the current files.
Title: Re: YaBB Gold converter does NOTHING at all
Post by: iougs on January 03, 2007, 06:19:33 PM
Boris:
you sql file works great!
converted from sp 1.4 to smf 1.1.1 successfully .. at least, it seems to have worked.
thanks a lot.
Title: Re: YaBB Gold converter does NOTHING at all
Post by: coralsea on March 01, 2007, 08:13:59 PM
Boris - You are the man!!!!  :D

I was going crackers debugging my Yabb Gold 1 SP 1.3.2 to SMF 1.1.1 convert. The errors it was spitting out made, no sense and changed each install I did (5th time's a charm ?). Didn't see this thread the first time I looked in the forum. This should be a sticky for YaBB 1 folks and a no brainer for the great SMF folks to incorporate.

Thanks for giving back.  
Title: Re: YaBB Gold converter does NOTHING at all
Post by: ret on July 20, 2007, 05:21:17 AM
Just wanted to say a HUGE thank you to Boris and everyone else who's worked on the YaBB 1 Gold converter. My host abruptly pulled my site (YaBB based for years - 2000 registered users, 10000 topics, nearly 70000 posts). Apparently YaBB is on their "banned list"

Anyway, having hacked the perl code in YaBB so much over the years, I didn't hold high hopes for a conversion to work, so I was just blown away that it worked first time. The only thing I had to fix was the per-board permissions (was MBCO extension).

So thank you everyone.

cheers
RET

http://fefcholden.org.au/forum