[SMF Converter] UBB.threads 7.5

[Sea Mac]

Thanks for all the hard work on this! We have been at SMF2, from UBB Threads 7.5.7, for 2 months now and everyone is getting used to all the statistics and new smilies and better posting options at last.

It was well worth it, from our point of view, to switch over from UBB Threads: at the very least because SMF2 is so So MUCH Faster!!! 

I plan to stay a Charter Member and be as supportive as I can be in these forums.

[StanJ]

I do not think this error was covered...

Notice: Undefined index: convert_script in /home/clubadve/public_html/forums/convert.php on line 974

Warning: Invalid argument supplied for foreach() in /home/clubadve/public_html/forums/convert.php on line 977

Notice: Undefined index: convert_script in /home/clubadve/public_html/forums/convert.php on line 989
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/clubadve/public_html/forums/convert.php on line 2496

Notice: Undefined variable: result in /home/clubadve/public_html/forums/convert.php on line 2497

Notice: Undefined index: db_fetch_assoc in /home/clubadve/public_html/forums/convert.php on line 1388

Fatal error: Function name must be a string in /home/clubadve/public_html/forums/convert.php on line 1388

Thoughts?  Using UBB 7.5.8

[Sea Mac]

I'm curious: when did UBB release the 7.5.7 to 7.5.8 update?

If I remember correctly we gave a database dump for version 7.5.7 ... UBB sometimes makes major changes to database structures with even minor (0.0.x) version updates!

This one fact alone could account for any and all errors from a version 7.5.8 database conversion ....

[StanJ]

I did find a fix,  just by going to another browser..
I do get the same error you did, and I did modify it, I would have thought the file would have been updated to reflect the changes you found that you needed..

Here is where I am..

[StanJ]

Sorry, I thought I had answered this, the .8 came out a few weeks ago.  Not long

[StanJ]

I don't have any more the db, so I can't be sure, though you can try adding:

Code Select Expand


$row['board_order'] = (int) $row['board_order'];

just after the line:

Code Select Expand

$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.

If I have this issue
>>>>Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

Where would i place a similar fix?

[forumfjott]

Do you still have the old database? Did you see that happening?

Ask one of the affected users to give you a "wrong" PM ID, check the current SMF database who's the author and destinations and compare that with the old database.
The IDs are all kept, be it users, posts, PMs, etc, so that shouldn't really happen...

What happened was that all users got EVERY SINGLE PM EVER sent, also the deleted by past space restrictions into their inbox.
The person reporting getting others PM, just did'nt remember what he was writing 11 years ago.
All OK

[margarett]

Uff, that's good, then

[emanuele]

The person reporting getting others PM, just did'nt remember what he was writing 11 years ago.

I can't blame him, I don't remember what I wrote half an hour ago... xD

[Sea Mac]

What happened was that all users got EVERY SINGLE PM EVER sent, also the deleted by past space restrictions into their inbox.
The person reporting getting others PM, just did'nt remember what he was writing 11 years ago.
All OK

Yeah, should've warned ya .... ALL deleted PM's will resurrect ... Do consider that a FEATURE and not a Bug ...

[forumfjott]

Would be OK to know beforehand.
Another "Feature" is that all 5000+ members got their original info in their profile. Remember wich mail address you had 10-12-14 years ago?
...just something to think about

[emanuele]

That looks weird.
Honestly I built the converter using as reference a single database. Since I don't like to look into personal informations I didn't check more than the minimum amount of things possible (I didn't go around verifying that old PMs were resurrected, both because I didn't want to go and read peoples' personal discussions and because anyway I couldn't know they were deleted, and the same is true for emails).

TL;DR: I had to "guess" several things.
Some I got right, some I got wrong.
If you can identify how UBB.threads stores the personal informations the converter can be fixed.

[forumfjott]

All in all I'm very pleased!! If my experience can gain others going the same route, it's all worth it

[Ruben Rocha]

I have a ubbclassic forum with 2.9 million posts.
This importer works fine with no errors.

Now I did have to convert to UBBthreads before I could use it.
And even though I tweaked the numbers to speed it up.
7 days for both conversions.
It works fine.

However I have a issue with the inline images posted ,not attachments.
where  due to a modification in classic to control display size.
The links were imported as:

Code Select Expand

<img src="http://i91.photobucket.com/albums/k313/wcocke/5FCC709D-5AC0-4F03-BFB3-548BB780A072_zpsmfv5zkzq.jpg" width="600" height="800" alt=" - " />
instead of say:
[img]http://i91.photobucket.com/albums/k313/wcocke/5FCC709D-5AC0-4F03-BFB3-548BB780A072_zpsmfv5zkzq.jpg" width="600" height="800" alt=" - " [/img]

Which varies in width and height size per post.
So they don't display in the post.

So where do I go from here?
I can change the prefix and suffix tags to

Code Select Expand

[img] [/img] or [html] [/html].
But deleting the height and width tags I have had no success.
But even if I could delete the size tags then goto the cp and change the display size it will not update existing posts.
So the big images will blow out the page and cause scrolling to view.
The other issue is some posts  are stored in the database as say

Code Select Expand

<img src =" and some are stored as <img src=&quot; same goes for the end tag
Or any other  combination of  escaped  or normal characters are placed in the database.
Possibly due to experimenting on the mod over they years.
Another item is the alt tag  is used but some are blank and some have values which vary.
And some are embedded as

Code Select Expand

[url] bla ba<img src=;bla blas height width alt />[/url]

Any suggestions on what would be best method to follow to make the images appear again in smf.

BTW, they work fine in ubbthreads after importing from ubb classic.
Any suggestions on what to do.

[Ruben Rocha]

I know this topic is old but will try anyway for a reply.

Still working on a test run of this importer.
Getting very close to a last run.
Got the image tags worked out.

But my dilemma is user titles did not import to smf. Which I really need.
The converter does not even address the field.
In ubb it is table  user_profile
the field is USER_TITLE

In the converter it does query the user_profile table but only for the password.

Can somebody help me modify this importer to  allow member titles to import from UBBthreads to smf?

[Ruben Rocha]

well I guess ignore this post I figured out how to do it by adding a line in the query.

[petergariepy]

I have a 7.6.1.1 install of UBBThreads.   https://www.vccachat.org [nofollow]
I have a 2.0.15 install of SMF.  http://smf.vccachat.org/ [nofollow]

I tried to install converter package without success.  https://download.simplemachines.org/index.php?converters;id=11

I got the error found below.

So I followed the recommendations after the error and uploaded the 2 files manually to smf/Packages/converter and set the permissions to the folder and files are recommended.  Unfortunately the Package Manager doesn't recognize that its there.

Any help is appreciated.

Peter

-----


An Error Has Occurred!
Package upload failed due to the following error:
"Although the package was downloaded to the server it appears to be empty. Please check the Packages directory, and the "temp" sub-directory are both writable. If you continue to experience this problem you should try extracting the package on your PC and uploading the extracted files into a subdirectory in your Packages directory and try again. For example, if the package was called shout.tar.gz you should:
1) Download the package to your local PC and extract it into files.
2) Using an FTP client create a new directory in your "Packages" folder, in this example you may call it "shout".
3) Upload all the files from the extracted package to this directory.
4) Go back to the package manager browse page and the package will be automatically found by SMF."

[petergariepy]

I moved the smf test site to:  http://vccaforums.org/ [nofollow]

[Ruben Rocha]

I started another conversion from UBB to smf from another site
This site has a lot of image attachments not inline images.
But it appears that this importer and the public one does not import them.
Is there some way to do so?

[Ruben Rocha]

This importer still works with ubb 7.6.1
To a degree.
I have modded this to import more data than the default  but there are still some intervention query's that I run to import custom groups and custom fields. and attachments in a gallery forum.