Advertisement:

Author Topic: YaBB Gold converter does NOTHING at all  (Read 16419 times)

Offline boris

  • Newbie
  • *
  • Posts: 7
YaBB Gold converter does NOTHING at all
« 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??


Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: YaBB Gold converter does NOTHING at all
« Reply #1 on: December 14, 2006, 09:21:26 AM »
This is an issue if your sessions are not being saved.  Who is your hosting company?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline boris

  • Newbie
  • *
  • Posts: 7
Re: YaBB Gold converter does NOTHING at all
« Reply #2 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.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: YaBB Gold converter does NOTHING at all
« Reply #3 on: December 14, 2006, 11:09:27 PM »
Are you running windows or linux?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline boris

  • Newbie
  • *
  • Posts: 7
Re: YaBB Gold converter does NOTHING at all
« Reply #4 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.

Offline boris

  • Newbie
  • *
  • Posts: 7
Re: YaBB Gold converter does NOTHING at all
« Reply #5 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!

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: YaBB Gold converter does NOTHING at all
« Reply #6 on: December 15, 2006, 08:31:51 AM »
The stars and online colors are not being converted.  Might be a problem with converter.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline boris

  • Newbie
  • *
  • Posts: 7
Re: YaBB Gold converter does NOTHING at all
« Reply #7 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.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: YaBB Gold converter does NOTHING at all
« Reply #8 on: December 15, 2006, 11:58:14 AM »
Oh that's great thanks :).
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline boris

  • Newbie
  • *
  • Posts: 7
Re: YaBB Gold converter does NOTHING at all
« Reply #9 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.


Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: YaBB Gold converter does NOTHING at all
« Reply #10 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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline iougs

  • Newbie
  • *
  • Posts: 4
Re: YaBB Gold converter does NOTHING at all
« Reply #11 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.

Offline coralsea

  • Newbie
  • *
  • Posts: 2
Re: YaBB Gold converter does NOTHING at all
« Reply #12 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.  

Offline ret

  • Semi-Newbie
  • *
  • Posts: 14
Re: YaBB Gold converter does NOTHING at all
« Reply #13 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 [nofollow]