Advertisement:

Author Topic: [SMF Converter] UBB.threads 7.5  (Read 43028 times)

Offline emanuele

  • SMF Super Hero
  • *******
  • Posts: 14,156
  • Gender: Male
  • THERE'S JUST ME
[SMF Converter] UBB.threads 7.5
« on: October 26, 2013, 12:01:46 PM »
Here it is an hopefully working converter for UBB.threads 7.5.

Thanks to Sea Mac and his collaborators that provided the database and support to fix the converter.

I hope it will be helpful to others as well.
« Last Edit: October 26, 2013, 12:38:10 PM by emanuele »


Take a peek at what I'm doing! ;D



Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Offline Sea Mac

  • Jr. Member
  • **
  • Posts: 136
  • Gender: Male
    • Software Santa
Re: [SMF Converter] UBB.threads 7.5
« Reply #1 on: October 26, 2013, 12:55:55 PM »
1,000,000 thanks for helping us out!

Our forum had 12 years at UBB Classic/Threads: with OVER 247,000 posts in more than 22,200 topics. Famous people - Like John Morley and (I think) Terence McKenna - have posted (and since died) and we REALLY Wanted to preserve what they wrote to us ....

But it seems that UBB Threads is not being updated, or developed, much (if at all) and is now becoming practically unusable - requiring older versions of PHP and the like. I've been a SMF user (and beta tester of 2) for 7 years: and had WANTED to get my Home forum "Up to Date" and SECURE since 2007. But NO ONE has (until today) a viable converter for UBB Threads 7.5.7 to ANY open source PHP BBS ... so we were "Stuck" in that old UBB Threads - stranded actually!

You Saved our "Gold" for Us!!!! WE are eternally grateful!!! (And SMF users 4ever ...
:laugh: )

I suppose I should report the problems with the WYSIWYG editing (leaving 'extra' BBC tags scattered throughout posts and the like) these New SMF users are reporting to me
::) .... (Sigh). And Posts in GrandChildren Boards are not showing up in "Last Post" item on front page ... (Whaaaa. big whoop ::) )

But most of them have never SEEN detailed Stats before - or so many ways to add expression to posting - and are as delighted as children at Christmas with the NEW forum.

You do magnificent work - Thank You!!

Sea Mac and the Gang ..

Offline emanuele

  • SMF Super Hero
  • *******
  • Posts: 14,156
  • Gender: Male
  • THERE'S JUST ME
Re: [SMF Converter] UBB.threads 7.5
« Reply #2 on: October 26, 2013, 01:06:15 PM »
Glad to be able to help. :)

I suppose I should report the problems with the WYSIWYG editing (leaving 'extra' BBC tags scattered throughout posts and the like) these New SMF users are reporting to me ::)
It's a known bug.
I think I tried to fix some of those errors while working on 2.1 (the fixes should still be around in the "fixes or bogus bug" board and should be possible to find them), but then I stopped when a brand new editor was used to replace the current one (And the second option is that you can install the SCEditor mod that brings the editor that will be used on SMF 2.1 to SMF 2.0).

And Posts in GrandChildren Boards are not showing up in "Last Post" item on front page ... (Whaaaa. big whoop ::) )
And this is done like that by design, in order to keep the performance impact of such operations at an acceptable level.


Take a peek at what I'm doing! ;D



Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] UBB.threads 7.5
« Reply #3 on: October 26, 2013, 01:08:58 PM »
The grand children "thing" is normal, as you may know.
There is a MOD to solve that, but with a performance hit attached...

kudos emanuele, you're the conversion master :P
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline Ichinen

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] UBB.threads 7.5
« Reply #4 on: October 26, 2013, 01:57:24 PM »
I'm echoing what Sea Mac wrote:

Quote
1,000,000 thanks for helping us out!

Our forum had 12 years at UBB Classic/Threads: with OVER 247,000 posts in more than 22,200 topics. Famous people - Like John Morley and (I think) Terence McKenna - have posted (and since died) and we REALLY Wanted to preserve what they wrote to us ....
But it seems that UBB Threads is not being updated, or developed, much (if at all) and is now becoming practically unusable - requiring older versions of PHP and the like. I've been a SMF user (and beta tester of 2) for 7 years: and had WANTED to get my Home forum "Up to Date" and SECURE since 2007. But NO ONE has (until today) a viable converter for UBB Threads 7.5.7 to ANY open source PHP BBS ... so we were "Stuck" in that old UBB Threads - stranded actually!

You Saved our "Gold" for Us!!!! WE are eternally grateful!!! (And SMF users 4ever ... :laugh: )

"Famous people - Like John Morley and (I think) Terence McKenna - have posted (and since died) and we REALLY Wanted to preserve what they wrote to us ...."

Not to mention Karl Hanes (who worked with Salvia divinorum for depression, when it was legal in Australia); there are others, but I will respect their privacy.

I must say, though, that we were becoming a bit frantic, being 'stuck' at UBB Classic (then Threads), because many of us ONLY post our research and reports of findings at WorldEyes, and it would have been tragic to have lost all that, since much of our work cannot be found anyplace else on the internet...

I am deeply grateful to Sea Mac for all his tinkering with SMF at his other websites, to make sure SMF fits our WorldEyes community like a glove.

And emanuele, you have no idea what a service you've provided in creating that converter for us - and WE got to help with getting the bugs out, so the next "UBB refugees" will have a squeaky clean converter. Thank you, so much.

*bowing Respect and Appreciation*

Ichinen / anna
« Last Edit: October 29, 2013, 10:08:39 AM by Ichinen »

Offline forumfjott

  • Semi-Newbie
  • *
  • Posts: 81
Re: [SMF Converter] UBB.threads 7.5
« Reply #5 on: November 07, 2013, 12:57:54 PM »
Hi there
Never done converting before, but the process seemed straight forward and I gave it a go.

This is how far I got :D

Quote
Converting members... Successful.
Converting categories... Successful.
Converting boards...Wrong value type sent to the database. Integer expected. (board_order)

I'm converting from Ubbthreads 7.5 to smf 2.0.6
Any clue what I can do to get things running further?

Offline Sea Mac

  • Jr. Member
  • **
  • Posts: 136
  • Gender: Male
    • Software Santa
Re: [SMF Converter] UBB.threads 7.5
« Reply #6 on: November 07, 2013, 01:30:06 PM »
Hi there
Never done converting before, but the process seemed straight forward and I gave it a go.

This is how far I got :D

Quote
Converting members... Successful.
Converting categories... Successful.
Converting boards...Wrong value type sent to the database. Integer expected. (board_order)

I'm converting from Ubbthreads 7.5 to smf 2.0.6
Any clue what I can do to get things running further?
This might depend on what version of UBB Threads you are running.

The UBB Threads database we gave to the development team here was for UBB Threads 7.5.7 (the "latest" version of UBB Threads). What version of UBB Threads are you running?

(If it is a version of 7.5 BEFORE 7.5.7 I would recommend that you upgrade your version of UBB Threads to version 7.5.7 first. It seems UBB makes significant changes to their databases even between 'minor' 0.0.X releases so I wouldn't think an earlier version would convert without a hitch.)

Hope this helps!

Offline emanuele

  • SMF Super Hero
  • *******
  • Posts: 14,156
  • Gender: Male
  • THERE'S JUST ME
Re: [SMF Converter] UBB.threads 7.5
« Reply #7 on: November 07, 2013, 02:55:02 PM »
I don't have any more the db, so I can't be sure, though you can try adding:
Code: [Select]
$row['board_order'] = (int) $row['board_order'];
just after the line:
Code: [Select]
$row['description'] = str_replace("\"", """, $row['description']);this won't fix the issue, but at least it should let you continue.
Some boards may be in the wrong order after the conversion.


Take a peek at what I'm doing! ;D



Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Offline forumfjott

  • Semi-Newbie
  • *
  • Posts: 81
Re: [SMF Converter] UBB.threads 7.5
« Reply #8 on: November 07, 2013, 04:26:24 PM »
managed to get past this one, but is now stuck on the next part.

Quote
Converting topics...
Wrong value type sent to the database. Integer expected. (id_last_msg)

This one I don't see a solution to. Will try to update to 7.5.7 during the weekend if you cannot help me on this one.

Thanks a lot for your attention

Offline emanuele

  • SMF Super Hero
  • *******
  • Posts: 14,156
  • Gender: Male
  • THERE'S JUST ME
Re: [SMF Converter] UBB.threads 7.5
« Reply #9 on: November 07, 2013, 06:11:16 PM »
O_o

No idea, sorry. I'd have to have a look at the database to know what could be wrong on that one...
It may be something related to polls, but it's difficult to guess.


Take a peek at what I'm doing! ;D



Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Offline forumfjott

  • Semi-Newbie
  • *
  • Posts: 81
Re: [SMF Converter] UBB.threads 7.5
« Reply #10 on: November 08, 2013, 08:02:48 AM »
I don't even know where to start looking...
Fingers crossed for the update to fix it

Offline forumfjott

  • Semi-Newbie
  • *
  • Posts: 81
Re: [SMF Converter] UBB.threads 7.5
« Reply #11 on: November 08, 2013, 08:45:05 AM »
Update did not fix it :(

I've googled the issue, but cannot find any other having asked the same question.
Mind me asking... Is it related to the newly installed forum or the old one?
Can it be skipped?

Offline Oldiesmann

  • Developer
  • SMF Super Hero
  • *
  • Posts: 24,814
  • Gender: Male
  • Ask me about the function DB :)
    • oldiesmann on Facebook
    • Oldiesmann on GitHub
    • http://www.linkedin.com/in/michaeleshom on LinkedIn
    • @oldiesmann on Twitter
    • Archie Comics Fan Forum
Re: [SMF Converter] UBB.threads 7.5
« Reply #12 on: November 08, 2013, 11:58:19 AM »
The only way to fix that issue is to either figure out what's causing it to begin with, or add code to force that value to be an integer, which will cause more problems later on (after the conversion, information about the last post in a particular topic may not be displayed properly).

Without access to the database, it's difficult to say what could be causing that.
Michael Eshom
Webmaster / SMF Lead Developer
oldiesmann@simplemachines.org

Offline emanuele

  • SMF Super Hero
  • *******
  • Posts: 14,156
  • Gender: Male
  • THERE'S JUST ME
Re: [SMF Converter] UBB.threads 7.5
« Reply #13 on: November 09, 2013, 10:55:47 AM »
The ubb db schema has TOPIC_LAST_POST_ID as int, a LEFT JOIN should not cause problems with the first table (AFAIK), and it cannot be skipped because IIRC SMF has an index on (id_last_msg, id_board) that would prevent throw in "random" numbers...


Take a peek at what I'm doing! ;D



Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

Offline StanJ

  • Jr. Member
  • **
  • Posts: 173
Re: [SMF Converter] UBB.threads 7.5
« Reply #14 on: November 09, 2013, 07:34:23 PM »
so do I install a fresh SMF  ie myforum.com/smf/ and the put the import gizmo myforum.com/smf/convert.php

Offline Colin

  • Lead Developer
  • SMF Hero
  • *
  • Posts: 7,760
  • Gender: Male
  • SMF Developer
    • colinschoen on GitHub
Re: [SMF Converter] UBB.threads 7.5
« Reply #15 on: November 10, 2013, 01:04:44 AM »
Have a read through this before doing any of it, if you will. It will explain what to do, step by step.

http://wiki.simplemachines.org/smf/Converting
"If everybody is thinking alike, then somebody is not thinking." - Gen. George S. Patton Jr.

Colin

Offline forumfjott

  • Semi-Newbie
  • *
  • Posts: 81
Re: [SMF Converter] UBB.threads 7.5
« Reply #16 on: November 10, 2013, 02:41:32 PM »
OK.
Deleted the last forum and try again.
I now have clean install smf v2.0.6.
Database is set to the same as the present ubbthreads database. The prefix is set to smf_.

Forum up and running OK

........

uploaded the two files:
ubbt7-5_to_smf.sql
convert.php

run convert.php
................

Same error

Converting topics...
Wrong value type sent to the database. Integer expected. (id_last_msg)

.................

I have seen through the database and cannot even find any tables or other data mentioning id_last_msg, so I'm 100% stuck.
I'll grant access to the PHPMyAdmin for emanuelle if you think you can help me get things going...

mentalist

  • Guest
Re: [SMF Converter] UBB.threads 7.5
« Reply #17 on: November 10, 2013, 04:45:43 PM »
in ubbthreads75_to_smf.sql find:
Code: [Select]
---* {$to_prefix}topics
---{

add after
Code: [Select]
$row['id_last_msg'] = (int) $row['id_last_msg'];

Offline forumfjott

  • Semi-Newbie
  • *
  • Posts: 81
Re: [SMF Converter] UBB.threads 7.5
« Reply #18 on: November 11, 2013, 07:17:34 AM »
Thanks Dexter

New error msg:

Converting topics...
Wrong value type sent to the database. Integer expected. (id_member_updated)

 :-\

Found it in
Code: [Select]
/******************************************************************************/
--- Converting topics...
/******************************************************************************/

TRUNCATE {$to_prefix}topics;
TRUNCATE {$to_prefix}log_topics;
TRUNCATE {$to_prefix}log_boards;
TRUNCATE {$to_prefix}log_mark_read;

---* {$to_prefix}topics
---{
$row['id_last_msg'] = (int) $row['id_last_msg'];
$ignore = true;
---}
SELECT
t.TOPIC_ID AS id_topic, t.TOPIC_IS_STICKY AS is_sticky, t.FORUM_ID AS id_board,
t.POST_ID AS id_first_msg, t.TOPIC_LAST_POST_ID AS id_last_msg,
t.USER_ID AS id_member_started, t.TOPIC_LAST_POSTER_ID AS [b]id_member_updated[/b],
IFNULL(ps.POLL_ID, 0) AS id_poll,
t.TOPIC_REPLIES AS num_replies, t.TOPIC_VIEWS AS num_views,
t.TOPIC_STATUS = 'C' AS locked, t.TOPIC_IS_APPROVED as approved
FROM {$from_prefix}TOPICS AS t
LEFT JOIN {$from_prefix}POLL_DATA as ps ON (ps.POST_ID = t.POST_ID);

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] UBB.threads 7.5
« Reply #19 on: November 11, 2013, 07:26:04 AM »
You should try the same principle:
Code: [Select]
$row['id_member_updated'] = (int) $row['id_member_updated'];

Although the main concern would be to understand WHY are those fields not interpreted as integers in the first place.
Can you check in SMF "smf_topics" table if the "id_last_msg" was correctly converted in your last run?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair