Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'settings' can't have a default value

Created on 12 May 2025, 12 days ago

Problem/Motivation

I get this error when i enable module
Drupal 11.1.7
PHP 8.4.6
Mysql 8.0.35

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'settings' can't have a default value: CREATE TABLE "noahs_page_builder_page" ( "page_id" INT NOT NULL auto_increment COMMENT 'Primary Key: Unique noahs_page_builder ID.', "noahs_id" VARCHAR(56) NOT NULL, "uid" INT NOT NULL DEFAULT 0 COMMENT 'Creator user\'s \"users\".uid', "entity_id" VARCHAR(56) NOT NULL DEFAULT 0 COMMENT 'Creator from \"entity\".entity_id', "langcode" VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Language', "settings" LONGTEXT DEFAULT '' COMMENT 'Save the json-html', "page_settings" LONGTEXT DEFAULT '' COMMENT 'Save the json-html', "modified_date" VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Modified Date', "entity_type" VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Entity type', PRIMARY KEY ("page_id") ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4 COMMENT 'Store data from Noahs'; Array ( ) in Drupal\Core\Extension\ModuleInstaller->installSchema() (line 681 of /var/www/html/web/core/lib/Drupal/Core/Extension/ModuleInstaller.php).

Steps to reproduce

Enable module

🐛 Bug report
Status

Active

Version

2.7

Component

Code

Created by

🇮🇹Italy trickfun

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024