UserExtended icon indicating copy to clipboard operation
UserExtended copied to clipboard

Installation fails on MariaDB

Open kosmonowt opened this issue 7 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

kosmonowt avatar May 26 '17 12:05 kosmonowt

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

Thanks, Shawn

ShawnClake avatar May 26 '17 13:05 ShawnClake

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

kosmonowt avatar Jun 30 '17 09:06 kosmonowt

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.

ShawnClake avatar Jun 30 '17 20:06 ShawnClake

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

ControllerNetwork avatar Jun 24 '18 23:06 ControllerNetwork

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.

ShawnClake avatar Jun 26 '18 14:06 ShawnClake

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

FarhanShares avatar Dec 16 '19 02:12 FarhanShares

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.

pablorq avatar Apr 15 '20 06:04 pablorq