Problems during installation SMF 2.0.19 with MySQL 5.7

[Strich8Forum]

Hi!
I want to install SMF in version 2.0.19. Why? I have to migrate my old Phorum-installation, because there is no support for PHP-version greater than 7, and the import-tool is designed for SMF 2.0.19. After migration i will upgrade to the latest SMF-version.
Server-settings: PHP 5.3, new added MySQL-database: 5.7.
During installation (install.php) the script stops at step 2: "the version of your database is too old and does not match with the minimum requirements of SMF".

Any ideas what i can do? My hoster only lets me create MySQL databases 5.7 or 8.0 (no chance even with v8.0 - already tried  ).

Thanks in advance!

[Illori]

https://download.simplemachines.org/requirements.php

it should work with both of those mysql. what does your phpinfo say about the mysql version?

[Strich8Forum]

PHP Version 5.3.29 (phpinfo)
MySQL Server-Version: 5.7.41 (phpMyAdmin)

The requirements say...
SMF 2.1 - MySQL 5.6.0 or higher...
SMF 2.0 - MySQL 4.0.18 or higher (at least 4.1.0 would be better)...

When SMF 2.1 was released, they recommend MySQL 5.6. Now i have to install old SMF 2.0 with a newer database-version (5.7) - thats why i´m wondering and don´t know what to do right now 

[Doug Heffernan]

PHP Version 5.3.29 (phpinfo)

That's your problem, right there. Neither Smf 2.0 or 2.1. supports such an older version. You will have to upgrade the php version as well.

[Strich8Forum]

Ok, thanx for your answer. So i have to create a new domain, change the php-settings to "new" (e.g. 7.0), and try to install SMF. But MySQL can be changed to 8.0?

But the requirements say:
SMF 2.0.19-2.0.19: PHP 5.3-8.0

[vbgamer45]

I would manually change the install.php to remove the script.
"the version of your database is too old and does not match with the minimum requirements of SMF"

[Strich8Forum]

PHP Version 5.3.29 (phpinfo)

That's your problem, right there. Neither Smf 2.0 or 2.1. supports such an older version. You will have to upgrade the php version as well.

Done. I created a subdomain, set to php 7.0 --> installation went on. Thank you Doug 

[Strich8Forum]

Next problem... 

I read about problems when having 2 different databases. Phorum runs on <database1> with <user1>. I installed SMF on <database2> with <user2>. The convert-tool 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'"
Anybody please? 

[Strich8Forum]

Now i want to start the converter...

Because it´s a question about converter, i started a new thread here.