Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: margarett on March 06, 2015, 07:19:58 AM

Title: FUDForum 3.0.4
Post by: margarett on March 06, 2015, 07:19:58 AM
This is a beta, don't just scrap your working forum at the end of the process!

I picked a local install of FUD 3.0.4, created some content and, using the existing converter for FUD 2.6.x (http://download.simplemachines.org/?converters;software=fud), I tried to get something working for this software.

What the converter will convert:

Known issues/limitations

Password recovery
Since passwords are not converted, you need to follow the usual steps for password recovery. If you cannot email yourself a new password, use this trick from the wiki (http://wiki.simplemachines.org/smf/I_accidentally_lost_my_admin_account!_What_can_I_do):
QuoteResetting an admin users password

Use phpMyAdmin (or similar) to locate (within the "_members" table) the member whose password is to be reset. In the database field entitled "passwd", enter a new password using plain text.
Then, clear out (erase) any existing content in the database field entitled "password_salt".
The next time the member logs in (using the new password), SMF will automatically re-encrypt his credentials.

How to use the converter
* Install SMF in the same server as FUD, in a separate folder, in the same or different database
* If installed in different databases, make sure that the MySQL user from SMF is allowed to SELECT (at least) the database from FUD
* Upload the files "convert.php" and "fud_to_smf.sql" to your SMF folder
* Upload file "fud_globals.php" to your FUD folder (where GLOBALS.php is)
* Run the converter --> www.whatever-path-to-smf.com/convert.php

That's it. If interested test and let us know the outcome.
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 07, 2015, 06:54:02 AM
Hi and thanks for giving this converter some attention.
I must say I'm more than a little scared to test this because I am not sure I won't break anything.
For instance, can the upload of fud_globals.php in the FUD folder mess up something ?
Title: Re: FUDForum 3.0.4
Post by: margarett on March 07, 2015, 06:58:56 AM
Nop. FUD doesn't care about the file and the converter only reads info from the origin. That remains untouched.
Of course, a full backup never hurts ;)
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 07, 2015, 07:26:18 AM
Another question :
I have already an smf database under the fudforum one, there are only 63 tables inside (dating back from when I tried the 2.6 converter.
Can I install smf and use this base or do I have to create a new one and delete (perhaps) the existing one ?
Title: Re: FUDForum 3.0.4
Post by: margarett on March 07, 2015, 07:34:54 AM
Is it 2.0.9?
If so and if you didn't customize SMF, then you can keep the same installation. The converter empties the affected tables before it works each step ;)
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 07, 2015, 07:44:11 AM
No, it's a previous version don't remember because I deleted the smf folder but kept the database for some reason.
Title: Re: FUDForum 3.0.4
Post by: margarett on March 07, 2015, 02:16:53 PM
If it's 2.0.x it's not a problem, the database hasn't changed.

Anyway, you need a functional SMF for the conversion, so you have to install it. So yes, delete that. You can just drop the tables and use the same database ;)
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 08, 2015, 03:12:05 AM
Hi,
The strange thing is that I can't seem to be able to access the files from the browser. I've a permission problem I can't fix.
I've put the SMF folder at the root of the site, permissions are 755 for folders and 644 for files, which works with the other
fudforum install. I tried 775, 777 recursively ..
I am baffled...
Title: Re: FUDForum 3.0.4
Post by: margarett on March 08, 2015, 10:33:55 AM
What does it show to you? 404 not found?
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 08, 2015, 10:45:34 AM
This :

Forbidden

You don't have permission to access /SMF/install.php on this server.

And 403  Forbidden on the browser tab
Title: Re: FUDForum 3.0.4
Post by: margarett on March 08, 2015, 10:51:49 AM
Uh... You server logs should tell you why that error pops up. Or maybe ask your host?
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 08, 2015, 11:43:46 AM
Right, made a stupid mistake, SMF installed and working ! :)

* If installed in different databases, make sure that the MySQL user from SMF is allowed to SELECT (at least) the database from FUD

They are both under "bartopmania", so it's the same database, right ?
Title: Re: FUDForum 3.0.4
Post by: margarett on March 08, 2015, 05:05:47 PM
If that's your database name, then yes ;)
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 08, 2015, 05:21:36 PM
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of FUDforum 3.0.4. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: Incorrect database name ''

How do I fix this ? :)

ps at the top of the windows there was this message :

Notice: Undefined variable: DBHOST_DBNAME in /web/bartopmania/smf/convert.php(451) : eval()'d code on line 1

Notice: Undefined variable: DBHOST_TBL_PREFIX in /web/bartopmania/smf/convert.php(451) : eval()'d code on line 1
Title: Re: FUDForum 3.0.4
Post by: margarett on March 08, 2015, 11:25:39 PM
Did you supply the correct path to FUD? It seems it can't read the information...
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 08, 2015, 11:46:41 PM
I think the path is correct, there's a problem of database name
Quote
The error that was received from the Database was: Incorrect database name ''

In fact there's one "big" database and under it there's "bartopmania" ---> FUD db
Under "bartopmania" there's                                             "bartopmania_SMF" ---> SMF db

Seems I have to fill info in the convert_php file ? DBHOST ...something ,
                                                                           
Title: Re: FUDForum 3.0.4
Post by: margarett on March 09, 2015, 05:48:21 AM
No, you don't. I see what you mean now.

In phpmyadmin (recent versions at least), when you create several databases with the same prefix, it groups those. So you don't have any database named "bartopmania", you have 2 or more "bartopmania_xxxxxx" databases.
Anyway, whatever database name you have, the converter should read it from GLOBALS.php so that's not the problem.

Could you please PM me your cPanel login details? Now that I wrote the converter, I'd like to see it in action :P
Title: Re: FUDForum 3.0.4
Post by: margarett on March 10, 2015, 07:12:08 PM
OK, now I see your problem (sorry, I could just look at this today...)

The version of FUD that I installed had some kind of "link" from GLOBALS.php to FUDforum/include/GLOBALS.php, so putting fud_globals.php on the root was enough. In your case you have an include to the "real" file so it fails to load the info. Give me some minutes ;)
Title: Re: FUDForum 3.0.4
Post by: margarett on March 10, 2015, 07:38:30 PM
OK, so your conversion is complete, I fixed the file fud_globals and, since I was there already, I performed the conversion. No errors :)

Please go to your SMF (you need to reset your password...) and perform the maintenance tasks --> find errors and recount totals.
Let me know if you find any problems ;)

For security reasons I removed the converter files, you can find them attached to the first post of this topic ;)
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 11, 2015, 02:43:35 AM
Wow ! Impressive job  :)
I reset my admin password by emailing myself a new one and that worked perfectly.  8)

However, there are some pictures that don't show up, quite a lot of them actually, after I ran the maintenance tasks
you mentionned. I get that kind of thing :

index.php?=getfile&id=776&private=0

Also, will it be possible to "replace" the existing FUD install by this one or any request to an existing message will have
to be re-directed ?
Last : will members have to reset their passwords to log in ?

Thx and kudos to a very nice job so far ! When I see the kind of support you and other top members provide,
I am really grateful and happy to be able to switch to this great forum platform !  :D
Title: Re: FUDForum 3.0.4
Post by: margarett on March 11, 2015, 06:00:15 AM
Quote from: eldritch1969 on March 11, 2015, 02:43:35 AM
Thx and kudos to a very nice job so far ! When I see the kind of support you and other top members provide,
I am really grateful and happy to be able to switch to this great forum platform !  :D
Thank you :)

QuoteLast : will members have to reset their passwords to log in ?
Unfortunately yes :(

QuoteHowever, there are some pictures that don't show up, quite a lot of them actually, after I ran the maintenance tasks
you mentionned. I get that kind of thing :

index.php?=getfile&id=776&private=0
Can you please link me a topic where that happens? The "original" topic in FUD and the corresponding "converted" topic in SMF ;) PM me if you don't want the links in public ;)

QuoteAlso, will it be possible to "replace" the existing FUD install by this one or any request to an existing message will have
to be re-directed ?
First part, yes. You just need to remove the FUD files from "www" and put the contents of "smf" folder in "www". then you load and run repair_settings to fix the URL and paths in SMF ;)
What is repair_settings.php? (http://wiki.simplemachines.org/smf/Repair_settings.php)
BUT DON'T DO THIS ALREADY!!! First you should test SMF, check if it was correctly converted, convert again, check again, etc, etc... Don't rush it ;)
The second part... Not really sure. Out of the box, no...
But it should be possible to fetch the URL, process it and cause a redirect... Eg:
www.yourforum.com/index.php?t=msg&th=2&start=0&
Should become
www.yourforum.com/index.php?topic=8.0

I'm pretty sure something will be forgotten with this approach but hey, better than nothing :P
Title: Re: FUDForum 3.0.4
Post by: margarett on March 11, 2015, 10:06:33 AM
OK, 2 things:

It seems that your attachments weren't converted, I need to take a look at that, but it should be (has to! :P ) fixable.
The inline pictures, unfortunately not. SMF doesn't support inline attachments... There are 2 MODs which do that, but aren't compatible with FUD's syntax.
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 11, 2015, 10:53:59 AM
so it means that photos won't be seen inside messages ?
If it is the case, how can members include them ?
Title: Re: FUDForum 3.0.4
Post by: margarett on March 11, 2015, 11:05:50 AM
After I fixed the issue with attachments :P the pictures that are attached to the post will still be attached. But will not be shown inline --> directly inside the post content.

After the conversion, new pictures can be attached using SMF's default attachments system. And you can post new pictures inline if you use one of these MODs
https://github.com/Spuds/SMF-ILA
http://custom.simplemachines.org/mods/index.php?mod=3770

But the existing posts will not have images in posts. They will be attached, yes, but not directly shown inside the post :(
Title: Re: FUDForum 3.0.4
Post by: margarett on March 11, 2015, 07:29:39 PM
OK so I fixed some minor things but the attachments were actually correctly converted, it's just that in SMF guests have no permission to see them :P
So everything is in place. Any further problems that you spotted?
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 12, 2015, 01:14:48 AM
Hi !
Talking about attachments, when I click on some of them, they don't show up as photos, I have a message asking me to download the file. I can't even see them. Isn't there any way to have a kind of plug-in like Lightbox to watch them ?

Also, smileys don't show up, I suppose there won't be a way to get them back ?
Title: Re: FUDForum 3.0.4
Post by: margarett on March 12, 2015, 05:44:26 AM
Can you point me to one of these attachments?

About the smileys, I have to check but I *think* that the converter doesn't handle them. I'll check ;)
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 12, 2015, 06:44:15 AM
Ok, no problem about the smileys :)

http://smf.bartopmania.com/index.php?topic=904.0 (http://smf.bartopmania.com/index.php?topic=904.0)

This for instance, but there are plenty others. If I click on one of them, it just ask for d/load the pic;
Title: Re: FUDForum 3.0.4
Post by: Illori on March 12, 2015, 07:23:08 AM
<img src="images/smiley_icons/gamer.gif" border="0" alt="gamer">

can you create an images/smiley_icons folder and put the old fudforum smileys in that folder? that should make them appear.
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 12, 2015, 12:19:25 PM
Thx
Does it have to be this folder's name ?
I transferred the fud icon folder renamed "fudforum" in smf's smileys folder and make it default
but that doesn't work
Title: Re: FUDForum 3.0.4
Post by: margarett on March 12, 2015, 12:27:26 PM
Nop, that doesn't work...

The thing is... Most forum softwares use "codes" for the smileys (which are parsed when the post is being displayed), the same way they use BBC for inline attachments. FUD is... strange :P
The smileys are added as images directly in the post body, so that the only way is really to have the same images path available in SMF.
Title: Re: FUDForum 3.0.4
Post by: eldritch1969 on March 12, 2015, 12:45:06 PM
Yep, that's fine by me.
Strange that some pictures show up, whereas others don't. If they can't be dosplayed, it'll have to stay like that
Title: Re: FUDForum 3.0.4
Post by: m_k on September 04, 2017, 10:05:55 AM
With this setup:

FUDforum: 3.0.8RC1
PHP: 7.0.22-0ubuntu0.16.04.1
Database: mysql 5.7.19-0ubuntu0.16.04.1 (mysqli)
Operating system: Linux 4.4.0-87-generic


I get the following error message when running the converter:

Converting members...
Notice: Undefined property: mysqli_result::$EOF in /var/www/html/smf/convert.php on line 2721

Notice: Undefined property: mysqli_result::$Fields in /var/www/html/smf/convert.php on line 2725

Notice: Trying to get property of non-object in /var/www/html/smf/convert.php on line 2726

Fatal error: Uncaught Error: Call to undefined method mysqli_result::MoveNext() in /var/www/html/smf/convert.php:2731 Stack trace: #0 /var/www/html/smf/convert.php(1251): convert_fetch_assoc(Object(mysqli_result)) #1 /var/www/html/smf/convert.php(51): doStep1() #2 {main} thrown in /var/www/html/smf/convert.php on line 2731


Is this fixable in an easy way?

EDIT: Fixed by downgrading to PHP 5.6 and SMF 2.0.13
Title: Re: FUDForum 3.0.4
Post by: m_k on September 04, 2017, 10:50:36 AM
Line 43 should look like this for things to work:

         id AS id_member, SUBSTRING(login, 1, 80) AS member_name, '' AS opeā”‚forum@vultr:~/1993$ ls | wc -l
    nid_uri, '' AS ignore_boards,