• Resolved dizwell

    (@dizwell)


    Hello Peter:

    Sorry, but I appear to have broken something with my composers table: I click on Data Explorer, find my table in the list and click ‘Explore’. The table’s rows are then displayed, along with an ‘Import’ button up top, but no ‘add new’ button.

    Off the top of your head, can you think of something I may have done that would prevent me from being able to add new rows to the table via the Data Explorer screens?

    I can fire up MySQL on the server and add additional rows directly there, but that’s obviously not as convenient!

    I assume I must have switched on a ‘read-only’ mode flag somewhere, or something else equally dumb. My other tables in Data Explorer have ‘Add New’ buttons, no trouble: it’s just this one. Anything you can suggest to look at by way of table settings/design or what have you would be appreciated.

    If you need all the gory details about the table design, etc. then let me know and I can put a page together with the relevant screenshots.

    Sorry to bother you so soon, once more!
    Regards
    Howard

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    No problem Howard 😊

    The most common reasons that prevent transactions are:
    – There is no primary key or unique index on the table
    – Transactions are disabled

    To enable transctions:
    – Open Settings
    – WP Data Access
    – Back-end
    – See section “Allow transactions?”

    Does this help?
    Peter

    Thread Starter dizwell

    (@dizwell)

    Bingo. Guess which dummy had removed the primary key on a column and forgot to put it back?!

    Thank you. I felt sure you’d be able to diagnose my errors fairly swiftly!

    Regards
    H

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Cannot add rows to table in Data Explorer’ is closed to new replies.