UBB.classic (UBB 6.x) Convertor - v0.2.5

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham » Thu May 22, 2003 7:51 pm

Not to my knowledge.

However, if you can post a copy of a forum_x.threads file from this version (preferably for a forum with less than 20 or so threads), I or someone else ought to be able to point out the changes you need to make to get it to work with a bit of work.
"So Long, and Thanks for All the Fish"

phpBB Useful Links: Knowledge Base | Userguide | Forum Search | MOD Database | Styles Database
My Links: Blog!

dmclark
Registered User
Posts: 20
Joined: Sat May 03, 2003 10:07 pm
Location: Boston, MA
Contact:

Post by dmclark » Thu May 22, 2003 8:03 pm

ok, here you go:

Code: Select all

%forum_topics = (
    q!000001! => q!2452528.1807!,
    q!000002! => q!2452581.1239!,
    q!000003! => q!2452619.0611!,
    q!000004! => q!2452602.1037!,
    q!000005! => q!2452691.1042!,
    q!000006! => q!2452724.1301!,
  );


1;
the other problem we are having is migration of login name vs viewable name.

thanks,

SevenIsMy
Registered User
Posts: 18
Joined: Thu Feb 20, 2003 12:20 pm

Post by SevenIsMy » Thu May 22, 2003 11:33 pm

if i am ready with the release of my forum and have some time i can show u the changes that i made to the code (some bugfixes and improvements)
(why not yet? i am not sure that is bugfree and some of the changes are only for my ubb version)

Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham » Fri May 23, 2003 8:21 am

OK, the main changes that I have seen to be made to this since DPK's last release are as follows

All these changes are in func_convertor.php

Around line 43 find

Code: Select all

doInputSelect("Select the version series of your UBB board that you are converting to PHPBB2", "convert_version", "63|%%|62|%%|61|%%|60", "6.3.x|%%|6.2.x|%%|6.1.x|%%|6.0.x", "");
replace with

Code: Select all

doInputSelect("Select the version series of your UBB board that you are converting to PHPBB2", "convert_version", "65|%%|64|%%|63|%%|62|%%|61|%%|60", "6.5.x|%%|6.4.x|%%|6.3.x|%%|6.2.x|%%|6.1.x|%%|6.0.x", "");
Around line 503, find and comment out

Code: Select all

        if (@mysql_query("UPDATE ".$config[sql_prefix]."groups SET group_id='-1' WHERE group_id='1'")) {
          doRowText2("1", "...phpbb: successfully updated mysql table ".$config[sql_prefix]."groups");
        }
        else {
          doRowText2("2", "...phpbb: unsuccessfully updated mysql table ".$config[sql_prefix]."groups");
          $error = 1;
        }
Around line 519, find and comment out

Code: Select all

        if (@mysql_query("UPDATE ".$config[sql_prefix]."user_group SET group_id='-1' WHERE user_id='-1'")) {
          doRowText2("1", "...phpbb: successfully updated mysql table ".$config[sql_prefix]."user_group");
        }
        else {
          doRowText2("2", "...phpbb: unsuccessfully updated mysql table ".$config[sql_prefix]."user_group");
          $error = 1;
        }
Around line 998, find:

Code: Select all

      $moderators = array_slice($moderators, 0, count($moderators)-1);
and replace it with this

Code: Select all

      if (($config[convert_version] == "64") || ($config[convert_version] == "65")) 
      { 
        $moderators = array_slice($moderators, 0, count($moderators)-2); 
      } 
      else 
      { 
        $moderators = array_slice($moderators, 0, count($moderators)-1); 
      }
Around line 1310, find

Code: Select all

      else if ($config[convert_version] == "63") {
        $string_rep_a = "! => q!";
        $string_rep_b = "q!";
        $string_rep_c = "!";
      }
Insert after

Code: Select all

      else if ($config[convert_version] == "64") {
        $string_rep_a = "! => q!";
        $string_rep_b = "q!";
        $string_rep_c = "!";
      }
      else if ($config[convert_version] == "65") {
        $string_rep_a = "! => q!";
        $string_rep_b = "q!";
        $string_rep_c = "!";
      }
Around line 1321, find

Code: Select all

      else if ($config[convert_version] == "63") {
replace with

Code: Select all

      else if (($config[convert_version] == "63") || ($config[convert_version] == "64") || ($config[convert_version] == "65")) {
Around line 1481, find

Code: Select all

add_search_words($posted_id, stripslashes($posted_post), stripslashes($posted_thetopic));
replace with

Code: Select all

add_search_words('', $posted_id, stripslashes($posted_post), stripslashes($posted_thetopic));
I think that's all the changes that are needed to make it work with UBB 6.4 and 6.5 and phpBB 2.0.4, if you hit a problem,post so that someone can assist.

PS. As a favour, can someone with 6.4 and/or 6.5 please send me a copy of the vars_misc.cgi file from your UBB system by private message so that I can check the separator characters in that as well. Thanks.
Last edited by Graham on Mon May 26, 2003 3:16 pm, edited 2 times in total.

dmclark
Registered User
Posts: 20
Joined: Sat May 03, 2003 10:07 pm
Location: Boston, MA
Contact:

Post by dmclark » Fri May 23, 2003 10:09 pm

I get pretty far, but then run into the following:

Code: Select all

PASS ...ubb: successfully found and opened 00000003.cgi file on server for member moni 
PASS ...phpbb: successfully selected user moni from mysql table phpbb_forums 
PASS ...phpbb: successfully selected user moni from mysql table phpbb_user_group 
PASS ...phpbb: successfully inserted values into mysql table phpbb_auth_access 
  
PASS ...ubb: successfully found and opened 00000003.cgi file on server for member moni 
PASS ...phpbb: successfully selected user moni from mysql table phpbb_forums 
PASS ...phpbb: successfully selected user moni from mysql table phpbb_user_group 
PASS ...phpbb: successfully inserted values into mysql table phpbb_auth_access 
  
FAIL ...ubb: unsuccessfully found and opened .cgi file on server for member moni; moderator unable to be converted 

Target
Registered User
Posts: 1
Joined: Sun May 25, 2003 3:33 am

Post by Target » Sun May 25, 2003 3:36 am

You left out some pipes in that first replacement. It should read instead:

Code: Select all

doInputSelect("Select the version series of your UBB board that you are converting to PHPBB2", "convert_version", "65|%%|64|%%|63|%%|62|%%|61|%%|60", "6.5.x|%%|6.4.x|%%|6.3.x|%%|6.2.x|%%|6.1.x|%%|6.0.x", "");

Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham » Sun May 25, 2003 8:17 am

Yep, well spotted. I've edited it accordingly so that there is a single list of the updates needed.

dmclark, I assume that this is at the point of converting the modertors? Not being the one who wrote the code it takes a while to work out where the problems are coming from. If you were to retry it (with the minor correction pointed out above), does it let you proceed past that point or not (you can always add the moderators again later if it does just so you get the topics over). If it still fails, can you post your vars_mods.cgi (I think it's called that) file so that we can see what's different about it.

dmclark
Registered User
Posts: 20
Joined: Sat May 03, 2003 10:07 pm
Location: Boston, MA
Contact:

Post by dmclark » Sun May 25, 2003 6:25 pm

Graham,

actually, it i s stumbling on an admin. Even after that fix, no luck -- and it wont continue past it. it appears to import all the users, but i cannot even go back & import just posts.

the contenits of my vars_mods.cgi is:

Code: Select all

$Forum29Moderator = "00000162";
$Forum2Moderator = "00000001||^||00000003||^||00000004||^||00000011";
$Forum4Moderator = "00000001||^||00000003||^||00000004";
$Forum20Moderator = "00000001||^||00000003";
$Forum12Moderator = "00000001||^||00000003||^||00000005";
$Forum21Moderator = "00000002";
$Forum22Moderator = "00000130";
$Forum14Moderator = "00000001||^||00000003";
$Forum9Moderator = "00000001||^||00000003||^||00000005";
$Forum24Moderator = "00000001";
$Forum16Moderator = "00000001||^||00000003||^||00000002";
$Forum25Moderator = "00000006";
$Forum17Moderator = "00000001||^||00000003||^||00000002";
$Forum27Moderator = "00000001||^||00000002||^||00000003";
$Forum28Moderator = "00000003";

1;
thank for all the help.

Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham » Sun May 25, 2003 8:21 pm

Can you confirm that it's failing on the last moderator (ie. it's gone through all the numbers in the file you posted in order and is failing after the last one)? That's the only place I can see where it should be doing that member twice in a row, and if it is, then the fix looks to be easy.

dmclark
Registered User
Posts: 20
Joined: Sat May 03, 2003 10:07 pm
Location: Boston, MA
Contact:

Post by dmclark » Sun May 25, 2003 8:44 pm

Graham,

From what i can tell, it's a couple of screen past user import -- the part where it's trying to associate users with forums.

Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham » Mon May 26, 2003 3:14 pm

OK, the change required to fix this involves adding some extra logic in the moderator conversion code (dmclark has tried it and it works). I've edited my previous post so that all the required changes are in the one post.

manuelbp
Registered User
Posts: 2
Joined: Sat May 31, 2003 2:54 pm
Location: Uruguay
Contact:

Post by manuelbp » Sat May 31, 2003 3:37 pm

When I try to convert my ubb 6.3 forums, everything works fine till the convertor tries to import the topics.

When it finds the first topic on the first forum, it freezes. This are the last two lines that are outputed:

Code: Select all

PASS ...phpbb: successfully found and opened 000015.cgi file on server for forum 1 
PASS ...phpbb: successfully inserted values into mysql table phpbb_topics
Any clue on what might be happening? Thanks !

Graham
Former Team Member
Posts: 8462
Joined: Tue Mar 19, 2002 7:11 pm
Location: UK
Contact:

Post by Graham » Sat May 31, 2003 3:41 pm

Have you made the changes I list towards the bottom of the previous page? They fix a number of issues affecting the convertor as well as adding support for the later versions of UBB. You look to be suffering from one of these issues from the error you describe.

manuelbp
Registered User
Posts: 2
Joined: Sat May 31, 2003 2:54 pm
Location: Uruguay
Contact:

Thanks !!

Post by manuelbp » Sat May 31, 2003 7:58 pm

Thanks !

That fix in the code solved the problem. I'm sorry for not reading the hole thread before posting myself. It was my intension but I gave up after reading 5 of the 24 pages. :lol:

Thanks again.

User avatar
Captain Pervert
Registered User
Posts: 48
Joined: Mon May 26, 2003 3:24 pm
Location: Netherlands
Contact:

Post by Captain Pervert » Sun Jun 01, 2003 12:23 pm

I just converted 6.1.0.1 to phpBB and it worked fine, except for ALL [img] and [url] tags and some quote tags too.

Every image and URL that was posted, has been replaced with $3.

A total mess.

Check this, for example.

http://www.cosanostra.nl/forum/viewtopic.php?t=180

Locked

Return to “[2.0.x] Convertors”

Who is online

Users browsing this forum: No registered users and 9 guests