Unable to install 2.0.0-alpha4 version: SQL error

Created on 2 August 2023, over 1 year ago
Updated 30 August 2023, over 1 year ago

Problem/Motivation

I was trying to install the alpha version (2.0.0-alpha4), and it throws me error as follows. However the dev version working fine.

In ExceptionHandler.php line 46:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual t
hat corresponds to your MariaDB server version for the right syntax to use near 'big) NOT NULL COMMENT 'Notifica
tion message based on confiuration',
"status"...' at line 9: CREATE TABLE "notifications" (
"id" INT unsigned NOT NULL auto_increment COMMENT 'Unique ID for this record.',
"entity_id" INT unsigned NOT NULL DEFAULT 0 COMMENT 'Entity id of action performed',
"entity_uid" INT unsigned NOT NULL DEFAULT 0 COMMENT 'Entity uid of action performed',
"action" VARCHAR(30) NOT NULL DEFAULT '' COMMENT 'Actions type Create, Update, Delete',
"bundle" VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Name of the bundle',
"uid" VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'uid of actioned user',
"user_name" VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Name of the user',
"message" TEXT(big) NOT NULL COMMENT 'Notification message based on confiuration',
"status" INT NOT NULL COMMENT 'Status of the notification',
"created" INT NOT NULL COMMENT 'Timestamp for the record insert.',
PRIMARY KEY ("id"),
INDEX "notification_uid" ("uid" (191)),
INDEX "notification_entity" ("entity_id"),
INDEX "notification_created_timestamp" ("created")
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4 COMMENT 'Create table used to store data of each site notificati
onsโ€ฆ'; Array
(
)

In StatementWrapperIterator.php line 110:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual t
hat corresponds to your MariaDB server version for the right syntax to use near 'big) NOT NULL COMMENT 'Notifica
tion message based on confiuration',
"status"...' at line 9

Failed to run drush en notifications_widget: exit status 1

Steps to reproduce

install the alpha version:
composer require 'drupal/notificationswidget:^2.0@alpha' and drush en notifications_widget

Proposed resolution

Fix SQL error.

Remaining tasks

User interface changes

API changes

Data model changes

๐Ÿ› Bug report
Status

Fixed

Version

2.0

Component

Code

Created by

๐Ÿ‡ฎ๐Ÿ‡ณIndia mukhtarm

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

Comments & Activities

Production build 0.71.5 2024