Advertisement:

Author Topic: SMF PHP 7.0 and MariaDB 10.1  (Read 1882 times)

Offline Valtam

  • Semi-Newbie
  • *
  • Posts: 21
SMF PHP 7.0 and MariaDB 10.1
« on: September 19, 2017, 11:43:54 AM »
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.

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,373
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #1 on: September 19, 2017, 11:49:05 AM »
SMF 2.0.14 is php 7 ready    MariaDb is not officially supported. it is very close to mysql you may experience minor issues.
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

Offline Valtam

  • Semi-Newbie
  • *
  • Posts: 21
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #2 on: October 08, 2017, 08:44:39 PM »
For future reference, I can confirm SMF 2.0.14 works with PHP 7.0 and MariaDB 10.1

Offline a10

  • Charter Member
  • Sr. Member
  • *
  • Posts: 797
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #3 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.
2.0.15, php 7.0.29, ssl. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown.

Offline Erikson

  • Jr. Member
  • **
  • Posts: 103
  • Gender: Male
  • Great SMF Fan - Fanlist...
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #4 on: September 01, 2018, 09:22:31 AM »
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)

MySQL version: 10.1.28-MariaDB-1~xenial
PHP: 7.0.24

'Maria' for a very long time here, zero problems.

Erikson
The best Forum Software? - SMF ./. The Best Support? - SMF-Support

Offline a10

  • Charter Member
  • Sr. Member
  • *
  • Posts: 797
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #5 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.
2.0.15, php 7.0.29, ssl. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown.

Offline Erikson

  • Jr. Member
  • **
  • Posts: 103
  • Gender: Male
  • Great SMF Fan - Fanlist...
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #6 on: September 01, 2018, 08:54:13 PM »
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.

Code: [Select]
sudo apt-get -y install mariadb-server mariadb-client
OS: Debian Stretch (About Packages ? ? ?)

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 ???
The best Forum Software? - SMF ./. The Best Support? - SMF-Support

Offline a10

  • Charter Member
  • Sr. Member
  • *
  • Posts: 797
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #7 on: September 02, 2018, 04:09:59 AM »
Just checked the hosting, 'maria' is now 10.1.30. All still well.
2.0.15, php 7.0.29, ssl. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown.

Offline a10

  • Charter Member
  • Sr. Member
  • *
  • Posts: 797
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #8 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.
« Last Edit: September 02, 2018, 08:22:53 AM by a10 »
2.0.15, php 7.0.29, ssl. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown.

Offline Erikson

  • Jr. Member
  • **
  • Posts: 103
  • Gender: Male
  • Great SMF Fan - Fanlist...
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #9 on: September 02, 2018, 07:13:26 PM »
Dear a10,

Excuse me, my mistake. The latest stable version is of course 10.1.30! ;)

Just checked the hosting, 'maria' is now 10.1.30. All still well.

Erikson
The best Forum Software? - SMF ./. The Best Support? - SMF-Support

Offline Erikson

  • Jr. Member
  • **
  • Posts: 103
  • Gender: Male
  • Great SMF Fan - Fanlist...
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #10 on: September 02, 2018, 07:19:52 PM »
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.

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
The best Forum Software? - SMF ./. The Best Support? - SMF-Support

Online Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 56,924
  • Gender: Male
    • Kindred-999 on GitHub
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #11 on: September 02, 2018, 08:30:44 PM »
well, do note that MariaDB is not officially supported by SMF 2.0
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline a10

  • Charter Member
  • Sr. Member
  • *
  • Posts: 797
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #12 on: September 03, 2018, 05:44:42 AM »
My 'maria' host specifically informs about supporting smf. And it works 100% well.
2.0.15, php 7.0.29, ssl. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown.

Offline shawnb61

  • Support Specialist
  • Sr. Member
  • *
  • Posts: 901
    • sbulen on GitHub
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #13 on: September 03, 2018, 11:33:15 AM »
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:
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
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Offline Erikson

  • Jr. Member
  • **
  • Posts: 103
  • Gender: Male
  • Great SMF Fan - Fanlist...
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #14 on: September 04, 2018, 05:19:49 PM »
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
The best Forum Software? - SMF ./. The Best Support? - SMF-Support

Offline soilsearcher

  • Semi-Newbie
  • *
  • Posts: 16
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #15 on: Yesterday at 11:58:08 AM »
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 [nofollow]

Regards

Gary

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • Sophist Member
  • *
  • Posts: 1,142
  • Gender: Male
    • Macedonian electronics forum
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #16 on: Yesterday at 06:38:07 PM »
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?
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Online vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,373
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: SMF PHP 7.0 and MariaDB 10.1
« Reply #17 on: Yesterday at 06:39:10 PM »
Solved for user in other post about database sessions
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