Hi everyone,
My webhost has just sent me and email saying that PHP will soon be upgraded from 5.6 to the latest version of 7.0 and MySQL will be upgraded from 5.6.35 to the latest version of MariaDB 10.1.
So my question is, is SMF 2.0.14 compatible with PHP 7.0 and MariaDB 10.1?
If not for either one, what are if any, the changes that I need to make?
Thank you.
SMF 2.0.14 is php 7 ready MariaDb is not officially supported. it is very close to mysql you may experience minor issues.
For future reference, I can confirm SMF 2.0.14 works with PHP 7.0 and MariaDB 10.1
MySQL version: 10.1.28-MariaDB-1~xenial
PHP: 7.0.24
'Maria' for a very long time here, zero problems.
Does not work with me. The
MariaDB does not create several tables in the install routine.
OS Debian Stretch - (10.1.26-MariaDB-0+deb9u1 Debian 9.1)Quote from: a10 on October 09, 2017, 06:30:52 AM
MySQL version: 10.1.28-MariaDB-1~xenial
PHP: 7.0.24
'Maria' for a very long time here, zero problems.
Erikson
Hello, can only report about this version\combination, 10.1.28-MariaDB-1~xenial, PHP: 7.0.24. Runs 100% well, 2 forums (for many, many years on the hosting).
But, have not tried any fresh install for a long time. May test that someday to see how it behaves.
Hallo dear a10 ;)
What I'm really surprised about is that I get an
old version of a
new MariaDB installation. Stable version is
10.3 Newly installed version is
10.1.26. Sorry, I do not understand.
sudo apt-get -y install mariadb-server mariadb-clientOS: Debian Stretch (About Packages ? ? ?)
Quote from: a10 on September 01, 2018, 01:41:41 PM
Hello, can only report about this version\combination, 10.1.28-MariaDB-1~xenial, PHP: 7.0.24. Runs 100% well, 2 forums (for many, many years on the hosting).
But, have not tried any fresh install for a long time. May test that someday to see how it behaves.
Erikson ???
Just checked the hosting, 'maria' is now 10.1.30. All still well.
Tested a fresh install, all done (from start of ftp'ing files to ready forum) in less than 5 minutes.
Zero problems. Ref creating tables, see attachment. So at least the 'maria' in use on my host is definitely good.
Dear a10,
Excuse me, my mistake. The latest stable version is of course 10.1.30! ;)
Quote from: a10 on September 02, 2018, 04:09:59 AM
Just checked the hosting, 'maria' is now 10.1.30. All still well.
Erikson
Dear a10,
I do not use FTP. I send the files via terminal. What still amazes me and I absolutely do not understand is that the install routine does not install the latest version ?! Why? Why do I get an old version installed? I will uninstall MariaDB again and try a completely new installation. Will contact you again, if it works, but also does not work.
Quote from: a10 on September 02, 2018, 08:07:12 AM
Tested a fresh install, all done (from start of ftp'ing files to ready forum) in less than 5 minutes.
Zero problems. Ref creating tables, see attachment. So at least the 'maria' in use on my host is definitely good.
Erikson
well, do note that MariaDB is not officially supported by SMF 2.0
My 'maria' host specifically informs about supporting smf. And it works 100% well.
This topic has come up before. If you do searches, you'll find several issues with specific implementations of MariaDB.
Challenges are summed up in this thread:
Quote from: shawnb61 on December 23, 2017, 01:47:53 PM
From the support threads here at SMF, I see two issues with MariaDB.
First, is that some MariaDB implementations have reserved words that conflict with SMF column names. This causes syntax errors, primarily in installs, upgrades & I believe package installs will have the same issues. Anywhere columns are added or altered.
Second, is that their numbering scheme has strayed from MySQL. ~10.0.2 is somewhat equivalent to ~5.6. There are several places in SMF code where versions are checked. This is either used to enable/disable features or to use alternate code. SMF checks against MySQL version #s, not MariaDB version #s, and there will be issues there. As a hypothetical example, if MariaDB starts supporting a specific feature in 10.0.5, which mySQL has in 5.7, MariaDB 10.0.2 users will experience "bugs" as SMF thinks the feature is supported, as 10.0.2 > 5.7.
IMO, these are two fairly significant issues that must be resolved before MariaDB can be formally supported.
An example problem:
https://www.simplemachines.org/community/index.php?topic=557046.0
I checked Maria DB again with a new installation. This time I get even more mistakes. I forget MariaDB very fast and use MySql again. Problem solved for me. Thanks to shawnb61, a10 and Kindred! ;)
Erikson
Hi all
My hosts have decided to upgrade to the latest Mariadb version, and now my forum gives me session verification failed errors when i try and access the admin or anything to do with entering a password- are there any ways to overcome this, as my hosts say there is nothing wrong with the servers speak to smf for a resolve?
SMF ver 2.0.15
cPanel Version 74.0 (build 6)
Apache Version 2.4.34
PHP Version 7.0.31
MySQL Version 10.2.17-MariaDB
Architecture x86_64
Operating System linux
Forum : www.soilsearcher.com
Regards
Gary
Entering or Re-Entering the password? Do any of your members report the same issue? Do they have trouble logging in? Have you tried cleaning the forum cache?
Solved for user in other post about database sessions