Error when the project is over postresql

Created on 9 March 2022, almost 3 years ago
Updated 29 November 2024, 20 days ago

Problem/Motivation

Whe the drupal is over postresql database, and we try to create a new field, this erros happens:

Error message
Close
There was a problem creating field IP vachiano: Exception thrown while performing a schema update. SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "NULL" LINE 8: "ip_vachiano_ip_start" NULL, ^: CREATE TABLE "node__ip_vachiano" ( "bundle" varchar(128) NOT NULL default '', "deleted" smallint NOT NULL default 0, "entity_id" bigint CHECK (entity_id >= 0) NOT NULL, "revision_id" bigint CHECK (revision_id >= 0) NOT NULL, "langcode" varchar(32) NOT NULL default '', "delta" bigint CHECK (delta >= 0) NOT NULL, "ip_vachiano_ip_start" NULL, "ip_vachiano_ip_end" NULL, CONSTRAINT node__ip_vachiano____pkey PRIMARY KEY ("entity_id", "deleted", "delta", "langcode") ); Array ( )

And the field isn't created

🐛 Bug report
Status

Closed: duplicate

Version

2.0

Component

Code

Created by

🇧🇴Bolivia vacho Cochabamba

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024