From The Document Foundation Wiki
Jump to navigation Jump to search

I cannot edit a newly created table.

There could be several reasons for this difficulty.

  • The table doesn't contain a primary key or a unique index.

In this case, open the table in Edit mode and select a column which uniquely identifies the row, open the context menu and select the "Primary Key" entry then save the table. After this the table will be editable.

  • The rights on the table aren't correctly set up. This is the case when the table mysql.tables_priv isn't correctly set up. To verify this, open a new request and insert the text.