I just installed the Data module for Drupal 8.7.1. I am trying to create a new table using the Data UI. But everytime I try to create a new table, I get an error saying "The 'id' field specification does not define 'not null' as TRUE". I am not sure how to fix the error. Further the "Adopt Table" button is also showing a completely blank screen, even though there are tables in the drupal database that are not being used by any other module or process.

CommentFileSizeAuthor
dataTableUI.PNG37.94 KBJunaidChaudry
dataTableUIError.PNG30.91 KBJunaidChaudry

Comments

JunaidChaudry created an issue. See original summary.

JunaidChaudry’s picture

JunaidChaudry commented
Category: Support request » Bug report
Priority: Normal » Critical
emilianobaum’s picture

emilianobaum commented

I experienced the same problem (D8) when I try to assign PRIMARY KEY to a field. If I create the table, and then edit it and assign PRIMARY KEY to the same field, the operation succeeds.
Also, the ADOPT TABLE function does not work. I can create tables, but not adopt them. With the same user I can connect through the command line and create tables in it without problems. If I look at the permissions (SHOW GRANTS) they are the same.