Page 6 of 20

Posted: Tue May 11, 2004 8:42 pm
by ElForesto
Well, I let the converter do it's thing once I renamed the folders and the threads files, and it did not convert everything over quite right. We ended up a lot of missing posts, and a good number of missing forum members. It would seem that the problem is due to us not having our forums in sequential order, which has caused the converter much confusion to begin with. I guess renaming them isn't a real solution.

Is there a way to have UBB redo the forum numbers so that they are sequential? Can we prune out the forum numbers no longer used? Could this be the cause of many of our posts and members not converting, even without throwing any errors? Should I be giving the old converter a try? We're trying to avoid having the old UBB board as an archive and having to start over from scratch.

Posted: Wed May 12, 2004 11:06 am
by Graham
I still need to look into the problem you are having, since I as yet can't reproduce it (but I only have later versions of UBB on my machine).

If you want to try the older version you can do, it seems the slightly more stable version for the oldest versions at present, which is why I maintain both.

On the other hand if you have the debug file from the conversion (probably not since it is off by default), it might provide a few clues.

Posted: Wed May 12, 2004 5:13 pm
by ElForesto
I'll try using the older version tomorrow, and also seeing if I can turn on the debug file in the newer version. (I'll presume the information can be found in this thread. ;))

This is giving me a schooling into why UBB is such a pain in the rear. :(

Posted: Thu May 13, 2004 10:13 am
by Charles R
Hi,

I was wondering if the importer was also importing polls or just members and posts.

thanks :)

Posted: Thu May 13, 2004 11:33 am
by Graham
ElForesto: Actually it's in the readme file which came with it ;) (right down at the bottom). The newer versions are actually not such a pain since the format has been standardised a bit more, it's the older 6.0.x and 6.1.x which are a pain :mrgreen:

Charles R: No it does not do polls, the format is too different for this to be a worthwhile exercise.

Posted: Thu May 13, 2004 6:31 pm
by ElForesto
Okay, so I think I found my issue... using the wrong set of vars. :oops: There was a duplicate copy of those files in UBB's CGI directory, and I had been using those. (D'oh!) I pointed it towards the other vars, and it's much happier. Still can't figure out for the life of me why someone would do something like that. *scratches head*

We'll see how it does once it's done.

(upgraded) UBB 6.03 -> phpBB2 2.0.8

Posted: Sat Jun 05, 2004 6:42 am
by clockwood
Hi, I am also getting the path error using 0.3.1. I am running Ubb 6.03 (upgraded from 5.x) on linux. I suspect the UBB upgrade is the issue here.

----------------------------------------------------------------------------
SUCCEEDED Loading UBB.classic configuration file (vars_config.cgi)
FAILED Checking UBB.classic CGI path (ultimatebb.cgi)
FAILED Checking UBB.classic members path (memberslist.cgi)
FAILED Checking UBB.classic non-CGI path (on.gif)
----------------------------------------------------------------------------

I've checked my paths with the vars_config file, and everything matches up.

I have tried all the fixes posted in this and several other threads. I've changed the both delimiter settings in conv_classic php to [60].

Any ideas?

(I've also tried the 0.2.6 convertor, but it only refreshes the first page, resetting the form fields to their defaults.)

At the end of the day, I only really need my member's info (usernames/passwords) converted . I don't care so much about the posts. I can leave UBB up as an archive. If there is an easy way to just convert my users, then that is just as welcome!

Posted: Tue Jun 08, 2004 11:12 am
by Graham
Hi, can you post the contects of your vars_config file please so that I can check the details of it (blank out any passwords or URL's if you want to).

Also, if you can just make sure that the paths in it are correct it would be helpful.

Posted: Tue Jun 08, 2004 7:54 pm
by clockwood
Paths are correct:

Code: Select all

%vars_config = (
CGIPath => "/www/server.net/docs/cgi/common_room",
NonCGIPath => "/www/server.net/docs/community/ubb",
MembersPath => "/www/server.net/docs/cgi/common_room/Members",
VariablesPath => "/www/server.net/docs/cgi/common_room",
CGIURL => "http://www.server.net/cgi/common_room",
NonCGIURL => "http://www.server.net/community/ubb",
cache_pw => "********",
Cookie_Number => "2452745.1707",
BBName => "The Common Room",
);
1;
Thanks for the help.

Posted: Wed Jun 09, 2004 11:33 am
by Graham
And it's another set of delimiters someone decided to use :roll:

Go to the line mentioned earlier in the thread for the delimiters and insert the following:

Code: Select all

	$delimiters[60][0] = ' => "';
	$delimiters[60][1] = '';
	$delimiters[60][2] = '"';
This should hopefully fix it.

Posted: Wed Jun 09, 2004 12:21 pm
by Smokezz
I ran the conversion last night on my boards. The one thing I noticed, is the posts are all out of order. Instead of being ordered by the most recent reply like on the UBB board, they seem to pretty much be random. Is there a way to fix this?

Great job on the converter though, everything seemed to work perfectly! :)


Eric

Posted: Thu Jun 10, 2004 11:00 am
by Graham
Yes that is a side effect of the way phpBB sorts the posts (and the conversion process).

The fix is as follows:
Open viewforum.php
Find the following bit of code

Code: Select all

$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time 
 FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
 WHERE t.forum_id = $forum_id
  AND t.topic_poster = u.user_id
  AND p.post_id = t.topic_first_post_id
  AND p2.post_id = t.topic_last_post_id
  AND u2.user_id = p2.poster_id 
  AND t.topic_type <> " . POST_ANNOUNCE . " 
  $limit_topics_time
 ORDER BY t.topic_type DESC, t.topic_last_post_id DESC 
 LIMIT $start, ".$board_config['topics_per_page'];
Change it to

Code: Select all

$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time 
 FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
 WHERE t.forum_id = $forum_id
  AND t.topic_poster = u.user_id
  AND p.post_id = t.topic_first_post_id
  AND p2.post_id = t.topic_last_post_id
  AND u2.user_id = p2.poster_id 
  AND t.topic_type <> " . POST_ANNOUNCE . " 
  $limit_topics_time
 ORDER BY t.topic_type DESC, p2.post_time DESC 
 LIMIT $start, ".$board_config['topics_per_page'];
Save the file and upload it, and that should resolve any problems with the order in which the topics are displayed in the forum.

Posted: Fri Jun 11, 2004 11:52 pm
by clockwood
Hey Graham,
Thank you so much, that did the trick! I had to disable search indexing because it was taking at least 15 minutes to convert 250 posts at a time. Of course I'll have to suffer later when I rebuild the search tables :(

I am having one more issue that you are aware of:
I guess these are old posts and the linebreaks display as <BR> or <P> ?

If it is this, then the fix for this is already included in my development version of the code for the next release. If anyone needs it, I'll post instructions on the changes needed.


Hyperlinks in signatures are also showing up as html (<A HREF="">)Can you post the required changes or email them to me at chad@epilogue.net?


Also, how do you re-start the conversion process from the first step?

Posted: Mon Jun 14, 2004 11:13 am
by Graham
I've sent you the updated files by email.

To restart the process, you need to delete an entry from the database.

Go to the phpbb_config table and find anything where the config_name value is ubb_convert_* and remove it.

Posted: Fri Jul 02, 2004 8:15 pm
by catcherman
I read through all of these hoping I would find the fix without having to post, but *ugh* it didn't want to happen that way.

When I check for PHP Configuration:

Code: Select all

SUCCEEDED Loading UBB.classic configuration file (vars_config.cgi) 
FAILED Checking UBB.classic CGI path (ultimatebb.cgi) 
FAILED Checking UBB.classic members path (memberslist.cgi) 
FAILED Checking UBB.classic non-CGI path (on.gif) 
A fatal error has occurred and the conversion process is unable to start. Please check the information above for details of the error(s), and correct them and try again. 
So I uploaded the file, filecheck.php, and entered my path to my vars files (/homepages/42/d105111359/htdocs/cgi-bin):

Code: Select all

Checking path exists.......PASSED
Checking path is a directory.......PASSED
Checking path is readable.......PASSED
Checking vars_config.cgi is in the directory.......PASSED
Checking vars_config.cgi is readable.......PASSED
Reading vars_config.cgi.......PASSED

File contents:


%vars_config = (
CGIPath => q!/homepages/42/d105111359/htdocs/cgi-bin!,
NonCGIPath => q!/homepages/42/d105111359/htdocs/ubb!,
MembersPath => q!/homepages/42/d105111359/htdocs/board_members!,
VariablesPath => q!/homepages/42/d105111359/htdocs/cgi-bin!,
CGIURL => q!http://www.catcherman.com/cgi-bin!,
NonCGIURL => q!http://www.catcherman.com/ubb!,
cache_pw => "********",
Cookie_Number => "2453189.1503",
BBName => q~Catching Stories~,
);
1;
I have already tried changing the values in the arrays as mentioned earlier in this thread (two instances), but neither worked for me.

I hope you have an answer for me. Plllllease... :wink:

Thanks Graham.