Gossamer Forum
Home : Products : Gossamer Forum : Pre Sales :

Ultimate Bulletin Board, Version 5.44a

Quote Reply
Ultimate Bulletin Board, Version 5.44a
   

Hi,



I have the following Forum from UBB:

+++++++
Powered by: Ultimate Bulletin Board, Version 5.44a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998-2000.
Deutsche Übersetzung von thinkfactory.
+++++++



Is it possible to transfer the threads to the gossamer Forum?



Sincerly Yours,



Mark Zimmermann
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
Hi,

Yes, the import script will import that version of UBB for you.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Ultimate Bulletin Board, Version 5.44a In reply to
Hi Alex,



thanks, that sounds good!

And therefor, the forum is an licensed version of a commercial forum package I just have to pay

100 $ right?



How long will it take to get the key?

Is there an Installation guide (maybe even in german Laugh ) how I transfer the old into the new forum?



Sincerly Yours

Mark Zimmermann
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
Hi,

It won't take more then 2 days, but if you order now, you'll probably have it by end of today.

To install, download either the Windows Installer (only available in english right now), or the German Standard version and follow the instructions there. They are translated I believe.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Ultimate Bulletin Board, Version 5.44a In reply to
Oops, and yes, you would qualify for the competitive upgrade, and it would only be $100.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
In Reply To:
Is there an Installation guide (maybe even in german Laugh ) how I transfer the old into the new forum?

Importing is fairly easy to do. You do need shell (telnet/ssh) access to the server to run the script (there is an exception, more on that a little later). If you go into the admin/tools directory, you should see an 'import.pl' script. If you run this script (eg. perl import.pl) then it will give you the available options, and a few examples. Before you do perform you import, you'll want to configure Gossamer Forum first, and make sure it's running properly. It's also expected that the forum you're importing from is operational.

Typical options for a UBB import would be:
Code:
perl import.pl --type=UBB5 --source=/path/to/UBB5/install --clear-database --close-forums --add-bad-email

Note that --clear-database will clear out your existing users and posts in Gossamer Forum. You can remove this option if you don't want to do this. If you have users who have already registered for Gossamer Forum using their username that was in UBB, you might want to use the --append-data option.

The --close-forums option will close both Gossamer Forum and UBB.

Lastly, the --add-bad-email option will add any users who have an invalid email (ie. email's which are formatted wrong, such as "this is an invalid email address"). Their account will be disabled and their email will be set to 'invalid@email.address'. You can do a search in the admin to find these users and enable/fix their accounts.

Adrian
Quote Reply
Re: [brewt] Ultimate Bulletin Board, Version 5.44a In reply to
Hi Adrian,



the install process was easy.

I followed your instructions with the folloing result:



[root@neptun tools]# perl import.pl --type=UBB5 --source=/html/cgi-bin/ubb --clear-database --add-bad-email
Reading import configuration... error!
Cannot locate UBB configuration file (UltBB.setup).
Import unsuccessful.


++++++



The Dir Info of the cgi/ubb/ directory is the following:

total 960
-rwxrwxrwx 1 939 102 2761 Mar 15 23:14 Date.pl
drwxrwxrwx 4 939 102 4096 Jul 8 12:14 Members
-rwxrwxrwx 1 939 102 1222 Mar 15 23:14 Styles.file
-rwxrwxrwx 1 939 102 3499 Apr 23 08:00 UltBB.setup
-rwxrwxrwx 1 939 102 35019 Mar 15 23:14 Ultimate.cgi
-rwxrwxrwx 1 939 102 33615 Mar 15 23:13 announce.cgi
-rwxrwxrwx 1 939 102 55225 Mar 15 23:13 archive.cgi
-rwxrwxrwx 1 939 102 66250 Mar 15 23:13 cpanel.cgi
-rwxrwxrwx 1 939 102 87843 Mar 15 23:13 cpanel2.cgi
-rwxrwxrwx 1 939 102 70553 Mar 15 23:14 cpanel3.cgi
-rwxrwxrwx 1 939 102 13770 Mar 15 23:14 cpanel4.cgi
-rwxrwxrwx 1 939 102 63723 Mar 15 23:14 edit.cgi
-rwxrwxrwx 1 939 102 42795 Mar 15 23:14 forumdisplay.cgi
-rwxrwxrwx 1 939 102 5804 Jun 10 08:45 forums.cgi
-rwxrwxrwx 1 939 102 684 Mar 15 23:14 forumsBACKUP.cgi
-rwxrwxrwx 1 939 102 4360 Mar 15 23:14 mail-lib.pl
-rwxrwxrwx 1 939 102 2029 Jun 8 19:12 mods.file
-rwxrwxrwx 1 939 102 86414 Mar 15 23:14 postings.cgi
-rwxrwxrwx 1 939 102 56864 Mar 15 23:14 search.cgi
-rwxrwxrwx 1 939 102 57803 Mar 15 23:14 ubb_library.pl
-rwxrwxrwx 1 939 102 70051 Mar 15 23:14 ubb_library2.pl
-rwxrwxrwx 1 939 102 50318 Mar 15 23:14 ubbmail.cgi
-rwxrwxrwx 1 939 102 66242 Mar 15 23:14 ubbmisc.cgi


What do I need to do now?



Sincerly Yours Mark Zimmermann
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
In Reply To:
[root@neptun tools]# perl import.pl --type=UBB5 --source=/html/cgi-bin/ubb --clear-database --add-bad-email

In Reply To:
The Dir Info of the cgi/ubb/ directory is the following:

Did you mean cgi-bin/ubb?

All the code is doing there is:
Code:
if (-f $self->{source} . '/UltBB.setup') {
$conf = $self->{source} . '/UltBB.setup';
}
elsif (-f $self->{source} . '/cgi-bin/UltBB.setup') {
$conf = $self->{source} . '/cgi-bin/UltBB.setup';
}
else {
$self->{error} = 'Cannot locate UBB configuration file (UltBB.setup).';
return 0;
}
$self->{source} is the value of the --source option, so all it's doing is checking for the UltBB.setup file in the source directory as well as cgi-bin, otherwise it gives you the error you got. Are you sure you got the path to UBB correct?

Adrian
Quote Reply
Re: [brewt] Ultimate Bulletin Board, Version 5.44a In reply to
Hi Adrian,



you were right the path was wrong.



The new result is:



[root@neptun tools]# perl import.pl --type=UBB5 --source=/home/www/web25/html/cgi-bin/ubb --clear-database --add-bad-email
Reading import configuration... done!
Clearing Gossamer Forum database... done!
Importing User table data... error!
Fatal Error: (ILLEGALVAL) Status cannot contain the value 'Mitglied'
Import unsuccessful.
[root@neptun tools]#




And now ?



Sincerly Yours



Mark Zimmermann
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
It looks like your UBB's member files might be using a different format to the UBB5 version we had. Can you send me a copy of one of your user's userfiles? What version of UBB are you using?

Adrian

Last edited by:

brewt: Jul 10, 2002, 3:18 AM
Quote Reply
Re: [brewt] Ultimate Bulletin Board, Version 5.44a In reply to
Thanks for your fast answer:



I use the follwoing version:



Powered by: Ultimate Bulletin Board, Version 5.44a
© Infopop Corporation (formerly Madrona Park, Inc.), 1998-2000.
Deutsche Übersetzung von thinkfactory.


The files will come per mail.



Thanks again for your help.



Sincerly Yours



Mark
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
Hrm... I looked at the userfile you sent me and it looks fine. Can you run the import with "--debug --debug --debug --debug" and send me the results? Thanks.

Adrian
Quote Reply
Re: [brewt] Ultimate Bulletin Board, Version 5.44a In reply to
Voila:





[root@neptun tools]# perl import.pl --type=UBB5 --source=/home/www/web23/html/cgi-bin/ubb -debug --debug --debug --debug
Reading import configuration... Reading UBB configuration Wrom: BGDADRZFSQHYUCDDJBLVLMHAALPTCXLYRWTQTIPWIGYOKSTTZRCLBDXRQBGJSNBOHMKHJYFMYXOEAIJJPHSCRTNHGSWZIDREXCAXZOWCONEUQZAA

UBB configuration path: /home/www/web23/html/cgi-bin/ubb

UBB non-cgi path: /home/www/web23/html/ubb

UBB cgi path: /home/www/web23/html/cgi-bin/ubb

done!
Importing User table data... GT::SQL::Driver::MYSQL::sth (12764): Executing query: SELECT COUNT(*) FROM gforum_User WHERE user_username = 'Webmaster Bayern-Online' from GForum::Import::UBB::import_users at /home/www/web25/html/cgi-bin/forum/admin/GForum/Import/UBB.pm line 339
GT::SQL::Driver::MYSQL::sth (12764): Executing query: SELECT COUNT(*) FROM gforum_User WHERE user_username = 'Webmaster Fichtelgebirge' from GForum::Import::UBB::import_users at /home/www/web25/html/cgi-bin/forum/admin/GForum/Import/UBB.pm line 339
GT::SQL::Driver::MYSQL::sth (12764): Executing query: SELECT COUNT(*) FROM gforum_User WHERE user_username = 'Zimmermann' from GForum::Import::UBB::import_users at /home/www/web25/html/cgi-bin/forum/admin/GForum/Import/UBB.pm line 339
GT::SQL::Driver::MYSQL::sth (12764): Executing query: SELECT COUNT(*) FROM gforum_User WHERE user_username = 'Kempermann' from GForum::Import::UBB::import_users at /home/www/web25/html/cgi-bin/forum/admin/GForum/Import/UBB.pm line 339
GT::SQL::Driver::MYSQL::sth (12764): Executing query: SELECT COUNT(*) FROM gforum_User WHERE user_username = 'Kempermann' from GForum::Authenticate::auth_valid_username at GForum::Authenticate::auth_valid_username line 215
Imported user data:
$VAR = {
'user_username' => 'Kempermann',
'user_last_seen' => '0',
'user_homepage' => '',
'user_registered' => '952214400',
'user_password' => 'xxxxxx',
'user_email' => 'user@kempermann.net',
'user_icq' => '',
'user_disp_email' => 'user@kempermann.net',
'user_message_notify' => '0',
'user_interests' => '',
'user_real_name' => undef,
'user_status' => 'Mitglied',
'user_location' => '',
'user_signature' => '',
'user_accept_privmsg' => '0',
'user_aim' => undef,
'user_occupation' => '',
'user_posts' => '34'
};

GT::SQL::Driver::MYSQL::sth (12764): Executing query: SELECT COUNT(*) FROM gforum_User WHERE user_username = 'Kempermann' from GForum::Authenticate::auth_valid_username at GForum::Authenticate::auth_valid_username line 215
GT::SQL::Driver::MYSQL::sth (12764): Executing query: SELECT COUNT(*) FROM gforum_User WHERE user_username = 'Kempermann' from GForum::Table::User::_plg_insert at GForum::Table::User::_plg_insert line 200
GT::SQL::Table (12764): Status cannot contain the value 'Mitglied' at /home/www/web25/html/cgi-bin/forum/admin/GT/SQL/Table.pm line 2006.
UBB Username => { id => GForum user_id, permissions => Forum Permissions, username => username }:
$VAR = {};

Imported UBB Administrators:
$VAR = {};

Imported UBB Registered Users (Currently includes Moderators):
$VAR = {};

Duplicate/Invalid users that have NOT been added:
$VAR = {
'zimmermann' => {
'username' => 'Zimmermann',
'reason' => 'Duplicate user',
'signature' => 'Jede theoretische Erklärung ist eine Reduzierung der Intuition.
****
Peter Hoeg'
},
'webmaster bayern-online' => {
'username' => 'Webmaster Bayern-Online',
'reason' => 'Invalid username',
'signature' => 'Mit bayerischem Gruss

Webmaster Bayern-Online.de

Manche leben mit einer so erstaunlichen Routine,
dass es schwerfaellt zu glauben, sie lebten zum ersten mal.
- Stanislaw Jerzy Lec'
},
'webmaster fichtelgebirge' => {
'username' => 'Webmaster Fichtelgebirge',
'reason' => 'Invalid username',
'signature' => 'Eine erfolgreiche Woche !!!!

Mit freundlichen Gruessen,

Frederik Schmidt
_________________
Wer sein Leben so einrichtet, daß er
niemals auf die Schnauze fliegen kann, der kann nur auf dem Bauch kriechen.
___________
H. Riesenhuber'
}
};

error!
Fatal Error: (ILLEGALVAL) Status cannot contain the value 'Mitglied'
Import unsuccessful.






+++++++++++++++++++++++++++



Thanks for your help !!!

Sincerly Yours Mark

Last edited by:

brewt: Jul 11, 2002, 2:17 AM
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
Is 'Mitglied' supposed to be a user status (eg. Registered, Moderator, etc)?

Adrian
Quote Reply
Re: [brewt] Ultimate Bulletin Board, Version 5.44a In reply to
Mitglied is german, means 'member', so it's probably "Registered User" or something like that.

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [brewt] Ultimate Bulletin Board, Version 5.44a In reply to
Mitglied is member



Sincerly Yours Mark
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
Well, you're going to have to edit code to make this work Smile Look at admin/GForum/Import/UBB.pm, line ~292:
Code:
# Update user_status to use GForum style user status (uses :user).
if (lc($gf_row->{user_status}) eq 'member' or lc($gf_row->{user_status}) eq 'junior member') {
$gf_row->{user_status} = REGISTERED;
}
elsif (lc($gf_row->{user_status}) eq 'moderator') {
$gf_row->{user_status} = REGISTERED;
}
elsif (lc($gf_row->{user_status}) eq 'administrator') {
$gf_row->{user_status} = ADMINISTRATOR;
}
# elsif (lc($gf_row->{user_status}) eq 'guest') {
# $gf_row->{user_status} = ANONYMOUS;
# }
That needs to be updated with your translated user status. For example, this line:
Code:
if (lc($gf_row->{user_status}) eq 'member' or lc($gf_row->{user_status}) eq 'junior member') {
needs to be changed to:
Code:
if (lc($gf_row->{user_status}) eq 'member' or lc($gf_row->{user_status}) eq 'junior member' or lc($gf_row->{user_status}) eq 'mitglied') {
Do the same for moderator and administrator.

Adrian

Last edited by:

brewt: Jul 11, 2002, 11:11 AM
Quote Reply
Re: [brewt] Ultimate Bulletin Board, Version 5.44a In reply to
Hi Adrian,



I changed the things as follows:



# Update user_status to use GForum style user status (uses :user).
if (lc($gf_row->{user_status}) eq 'Mitglied' or lc($gf_row->{user_status}) eq 'Junior-Mitglied') {
$gf_row->{user_status} = REGISTERED;
}
elsif (lc($gf_row->{user_status}) eq 'Moderator') {
$gf_row->{user_status} = REGISTERED;
}
elsif (lc($gf_row->{user_status}) eq 'Administrator') {
$gf_row->{user_status} = ADMINISTRATOR;
}
# elsif (lc($gf_row->{user_status}) eq 'guest') {
# $gf_row->{user_status} = ANONYMOUS;
# }




the result was:



[root@neptun tools]# perl import.pl --type=UBB5 --source=/home/www/web25/html/cgi-bin/ubb --clear-database --add-bad-email
Reading import configuration... done!
Clearing Gossamer Forum database... done!
Importing User table data... error!
Fatal Error: (ILLEGALVAL) Status cannot contain the value 'Administrator'
Import unsuccessful.




Please help!



Sincerly Yours

Mark
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
Because of the lc( ... ), you need to make it:

Code:
# Update user_status to use GForum style user status (uses :user).
if (lc($gf_row->{user_status}) eq 'mitglied' or lc($gf_row->{user_status}) eq 'junior-mitglied') {
$gf_row->{user_status} = REGISTERED;
}
elsif (lc($gf_row->{user_status}) eq 'moderator') {
$gf_row->{user_status} = REGISTERED;
}
elsif (lc($gf_row->{user_status}) eq 'administrator') {
$gf_row->{user_status} = ADMINISTRATOR;
}
# elsif (lc($gf_row->{user_status}) eq 'guest') {
# $gf_row->{user_status} = ANONYMOUS;
# }

Adrian
Quote Reply
Re: [brewt] Ultimate Bulletin Board, Version 5.44a In reply to
Hi Adrian,



I went one step more:



Thats the result:




Reading import configuration... error!
Cannot locate UBB configuration file (UltBB.setup).
Import unsuccessful.
[root@neptun tools]# perl import.pl --type=UBB5 --source=/home/www/web25/html/cgi-bin/ubb --clear-database --add-bad-email
Reading import configuration... done!
Clearing Gossamer Forum database... done!
Importing User table data... (6.00s) done!
Importing Category table data... done!
Importing Forum table data... done!
Importing Grouping table data... done!
Importing ForumGroup table data... (1.00s) done!
Importing UserNew table data... done!
Importing ForumModerator table data... done!
Importing Post table data...
0%........................25%........................50%....error!
Unable to load UBB threads file /home/www/web25/html/ubb/Forum10/forum10.threads: Datei oder Verzeichnis nicht gefunden
Import unsuccessful.
[root@neptun tools]#



in this directory you find the following:



total 12
drwxrwxrwx 2 939 102 4096 Apr 2 19:22 ANNC
drwxrwxrwx 2 939 102 4096 Apr 2 19:22 HTML
-rwxrwxrwx 1 939 102 0 Apr 2 19:24 index.html
drwxrwxrwx 4 939 102 4096 Apr 2 19:24 private-EFp8n6238




Please help



Sincerly Yours

Mark Zimmermann
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
Hi Adrian,



could you please help, because it does not work till now.



http://www.gossamer-threads.com/...i?post=206601#206601



Sincerly Yours Mark
Quote Reply
Re: [MarkBT] Ultimate Bulletin Board, Version 5.44a In reply to
It looks like the forum is a private/passworded forum, but in the forums file, it's not marked as one. You can fix this by moving the contents of the private-... directory into the parent directory (eg. /home/www/web25/html/ubb/Forum10).

Adrian
Quote Reply
Re: [brewt] Ultimate Bulletin Board, Version 5.44a In reply to
  
HI Adrian,



thank you very much - everything is OK now.



Sincerly Yours



Mark Zimmermann

Last edited by:

MarkBT: Jul 28, 2002, 4:16 AM