Installation fails on MariaDB

Question

Installation fails on MariaDB

Opened this issue 8 years ago · 7 comments

Hi, I am getting this error during install:

Update failed

"SQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default value NULL (SQL: alter table "clake_userextended_friends" add column "accepted" tinyint(1) not null)" on line 662 of /var/customers/webs/maultrommel/ijhs/vendor/laravel/framework/src/Illuminate/Database/Connection.php

would it be problematic to set a default to this column?

Cheers,
Andreas

Answer 1 · 2017-05-26T13:03:09.000Z

Hey Andreas, thanks for the catch! A default of 0 will work just fine. I'll fix this in the next update.

Thanks,
Shawn

Answer 2 · 2017-06-30T09:31:43.000Z

Hi @ShawnClake, do you have any Idea when this can be done?

Answer 3 · 2017-06-30T20:44:47.000Z

Hey @kosmonowt, I expect to have something tanglible to release in a few weeks. Work has been busy and I've been involved in an unrelated project for a few months.

Answer 4 · 2018-06-24T23:09:12.000Z

Check my comment on issue #130 it may help you @robndg

Answer 5 · 2018-06-26T14:41:23.000Z

Unfortunately, I have very little time to contribute to this project these days. If anyone has any interest in maintaining this project, send me an email.

Answer 6 · 2019-12-16T02:34:29.000Z

Update: MariaDB 10.4.x with PHP 7.3.x, it is fixed.

Answer 7 · 2020-04-15T06:55:42.000Z

Also fails on SQLite DB.

SQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default value NULL (SQL: alter table "clake_userextended_friends" add column "accepted" tinyint(1) not null)

This is on install on OctoberCMS build 464.