Translations:Faq/Base/009/1/en

    From The Document Foundation Wiki

    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.