MariaDB error on new installation

JasonLABS

Service: DigitalOcean
Linux: Ubuntu 16.04
Server: Apache/2.4.18
MariaDB: 10.2.10-MariaDB
PHP: PHP 7.1.11
Composer: 1.5.2

The installation goes perfectly when I issue the command:

composer create-project flarum/flarum . --stability=beta

When I open a browser and go to the root of the project and enter the name, database credentials, and administrator credentials, then click on the installation button. I get the error that pops up here, reported on github.

Something went wrong: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'notifications_read_time' (SQL: ALTER TABLE *removed* CHANGE notification_read_time notifications_read_time DATETIME DEFAULT 'NULL')

It looks like according to this comment in github that the only option to use MariaDB is to wait for a fix from the dev team.

Is there a work around in the mean time?

I don't currently have the option to downgrade MariaDB on my production server as many other projects depend on the set up I have currently.

I apologize if this has been answered somewhere, I just haven't been able to come across the answer yet.

luceos

JasonLABS you can edit the files mentioned somewhere in the issue. Sadly there's no other fix I currently can think of.

JasonLABS

luceos Thanks for the input! I had a feeling this was the case.

Hifihedgehog

I have been going back and forth with Pockethold's excellent developer the last few days and I think I found my recent Flarum installation issue. My webhost has migrated their servers to the latest version of MariaDB as of several weeks ago. Are the latest versions of MariaDB still a problem in beta 8? If so, I have really no way to develop for or use Flarum now especially since I have three years invested with this provider.

EDIT: Awesome. It indeed has been fixed long, long ago in beta 8! flarum/core1211#issuecomment-405461675 Thanks, Team Flarum!

luceos

Hifihedgehog Is the latest versions of MariaDB still a problem in beta 8

No this is fixed in beta 8, although beta 8 does require php 7.1 or 7.2 (7.3 is untested).

Staszek

Sorry for off topic, but I don't want to make new one for this post. Why don't you write a few sentences about current state of beta8 in Dev Diary? ??

lensco

Running into this issue as well. I tried following along with the Github issue, but can someone tell me exactly (in simple terms) what to do to get Flarum running on MariaDB 10.2? I'd run beta 8 if I could, but most extensions don't seem to support it and I don't even know how to. The long wait is killing me…

jordanjay29

lensco can someone tell me exactly (in simple terms) what to do to get Flarum running on MariaDB 10.2?

Downgrade to 10.1.

lensco

jordanjay29 Right, I'll ask my shared hosting provider. Surely they'll understand. 🙂

jordanjay29

lensco You asked for simple. 😉

Unfortunately, this is an issue with shared hosting, and one that Flarum doesn't have a lot of power to resolve. The dependencies it relies on sometimes has narrower requirements than we'd like, and shared hosts are often notorious for staying on old versions of PHP/MySQL or not offering the selection necessary when a situation like this occurs.

I can hope that when Beta 8 releases, this will be largely resolved and we won't encounter future issues from MariaDB, but it does suck in the meantime.