Error in mysql version during upgrade from v2.0

Started by redray, April 16, 2020, 05:45:14 PM

Previous topic - Next topic

redray

Hello!
This is my first  post on this forum.
I'm trying to upgrade SMF from version 2.0 RC1 to last release (2.0.17), using large update package.

I did all the preliminary operation:
- backup directories in htdocs
- backup database.
Then i extracted the content of the upgrade archive inside the forum root, but when run the the upgrade.php file, i receive this error:

Your MySQL version does not meet the minimum requirements of SMF.
Please ask your host to upgrade.


The current  configuration of my server is:
- mysqlnd 5.0.11-dev
- PHP Version 5.6.40-1

the installation notes refer as minimum requirements
- MySQL 4.0.18 or higher.
- PHP 4.1.0 or higher.

Why i receive this error?

Any help is appreciated.

Thanks

Doug Heffernan

Quote from: redray on April 16, 2020, 05:45:14 PM
Hello!
This is my first  post on this forum.
I'm trying to upgrade SMF from version 2.0 RC1 to last release (2.0.17), using large update package.


Your MySQL version does not meet the minimum requirements of SMF.
Please ask your host to upgrade.



Your host is using an outdated mysql version that Smf is not supporting. Ask them to upgrade their mysql.

redray

#2
If i try to execute this query on my mysql server

SHOW VARIABLES LIKE "%version%";

i get this information:


innodb_version: 5.6.30
protocol_version: 10
slave_type_conversions
version: 5.6.30-1~bpo8+1
version_comment: (Debian)
version_compile_machine: x86_64
version_compile_os: debian-linux-gnu

the version here is 5.6. that is greather than the required MySql 4 in the installation note.
where am i wrong?

UPDATE:
When start the update script, on top, i receive this warning:

Warning: mysqli_get_server_info() expects parameter 1 to be mysqli, resource given in /omitted/upgrade.php(2248) : eval()'d code on line 1

I don't know if this can be useful.

PS: Inside of my hosting control panel, i can modify php version (5.6, 7.0, 7.1, 7.2) but the only one able to execute the upgrade script is 5.6.

vbgamer45

That first line is a clue since it means it couldn't get the version information correctly.

Try removing this line from upgrade.php and see if it works

if (!db_version_check())
return throw_error('Your ' . $databases[$db_type]['name'] . ' version does not meet the minimum requirements of SMF.<br /><br />Please ask your host to upgrade.');

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

redray

Good evening!
Thanks for your help!
I made the suggested change to the upgrade.php file and everything worked fine!
Forum updated without any problems.
Thank you all!

vbgamer45

Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Advertisement: