Converting from Phorum 5.1.22 to SMF 2.0.19

[Strich8Forum]

Hi together,

i strongly have to migrate my forum and installed SMF in order to migrate.
Why? I´m still running on php 5.3    and cannot upgrade to php 7 or 8 - installed Phorum won´t work...
So first i installed SMF 2.0.19 with the converter-tool and ran into problems...

First of all my settings:

Domain1 (php 5.3)
Phorum (5.1.22)
Database1 (MySQL 5.7) with User1

sub.Domain1 (php 8.0)
SMF (2.0.19)
Database1 (MySQL 5.7) with User1

Why the same database? I read about problems when having 2 different databases. Phorum runs on <database1> with <user1>. I installed SMF on <database2> with <user2>. The converter wants access for <user2> on <database1> to read the content of Phorum. Unfortunately i cannot give access for <user2> to <database1>, so i made a fresh installation of SMF in <database1> with <user1> (syntax "smf_" for all new entries in that existing database).
Now i want to start the converter, and at "step 1" i become the error-code "Unknown system variable 'SQL_MAX_JOIN_SIZE'"

Does anybody has an idea what i can do next?

Thanks!

[vbgamer45]

Hmm thats a strange error. In the convert.php we have a check if version is greater than 5.6 to use max_join_size join size instead.

Try manually editing the convert.php file and change both spots where it says SQL_MAX_JOIN_SIZE to max_join_size

[Strich8Forum]

Try manually editing the convert.php file and change both spots where it says SQL_MAX_JOIN_SIZE to max_join_size

Thanks, that worked! Now the converter starts directly at step 1 with "Converting... Converting members..." and won´t stop. Nothing happens. Nothing? Wrong. The converter deletes the table "smf_members", so i have to re-install SMF again...

Any further ideas? 

[vbgamer45]

Hmm strange it shouldn't delete the table.

[Strich8Forum]

Sorry... converter does NOT delete the table, but the users inside.

[vbgamer45]

That's expected in a conversion process

[Strich8Forum]

Okay, but what about "Now the converter starts directly at step 1 with "Converting... Converting members..." and won´t stop." I waited about 10 minutes, but nothing happened. Even there are no imported users in the "smf_members"-table.

[Strich8Forum]

No further ideas? What could be the problem, that the converter stops at step 1 when trying to import users from Phorum?
Thanks in advance!

[vbgamer45]

Try to add debug to the url on the page you are stuck ?debug=1 or &debug=1 if you don't have a ? in the url.

[Strich8Forum]

Thanks. First of all: i used an old converter, downloades years ago 

After first attempt with the "new" converter, the members-table was empty. Ok, i created a new user, made it an admin in MySQL, fine.
Next try. Now the converter says "no installation found or database-user has no rights... (MySQL-error 1146). Ok, lets log out of MySQL and close the FTP-session.
Next try. Now the converter went on and stuck at "Converting... Successful. Recalculating forum statistics... " Lets try the debug again.

On top of the page (above the header "Phorum 5 to SMF Converter") there are these notices:

Notice: Undefined index: convert_script in /var/www/vhosts/<SERVER>/html/forum_smf/convert.php on line 66
Notice: Undefined index: start in /var/www/vhosts/<SERVER>/html/forum_smf/convert.php on line 111

In the "result-body" (main frame of the converter) there are these notices:

Notice: Undefined index: substep in /var/www/vhosts/<SERVER>/html/forum_smf/convert.php on line 993
Converting members...
Notice: Undefined index: member_name in /var/www/vhosts/<SERVER>/html/forum_smf/convert.php on line 1275
Notice: Undefined index: real_name in /var/www/vhosts/<SERVER>/html/forum_smf/convert.php on line 1276

Notice 1275 and 1276 will repeat about continuously...

Any further ideas? It´s hell...

[Strich8Forum]

Do i have a problem with php-settings or the non-installed SSL-maybe?

• https://<DOMAIN>/<old Phorum> - php 5.3, SSL-certificate
• https://sub.<DOMAIN>/forum_smf - php 8.0, no SSL installed (therefore i get always "net::ERR_CERT_COMMON_NAME_INVALID")

Someone any ideas?

[Strich8Forum]

Thank god there is ChatGPT    I asked how to migrate Phorum to SMF, and with version 15 (took some approaches to fix bugs) i became a script that imported...
- all users
- all threads and topics
- even most of the private messages
 
The script converted directly from Phorum 5.1.22 to SMF 2.1.4 - i first installed SMF 2.0.19 because the "official" SMF-converter was scripted this way.

ChatGPT even told me how to repair the counter (only 1 user [me] was shown, but ~ 2000 have been imported), to show the threads (all threads were imported in the database, but not visible in SMF) and how to show USERNAME, not even REAL NAME next to a thread.

This thread can be closed - no more questions