Hi Diego,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

1. You can either click a row, then click into the "Edit" button at the top right;
   You can check which editing buttons you enabled, there are "new Row",  "edit" and "Delete a row".
   
   Or as you said, if you enabled the in-line editor tool - then you can double click a cell and edit it directly.
   
   
   
2. In regards to that error :
   Please check which Column are you choosing as the 'id column for editing'.
   You can hover on the tooltip, as on my screenshot, and see the description for the rules, how this column must be configured in order for our editing to work.
   
   

As you can see, it must be an integer column type and needs to have these properties : auto-increment and unique.
Can you show us screenshots from your source Database table, is a column like that selected for editing?


Let me know if that isolates the issue.


3. There are other important limitations for editing in our SQL Tables, please note as per the Documentation :

• Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables.
• Only MySQL tables or tables created with “Create a table manually” and “Create a table by importing data from data source” options of “Create a Table” page can be edited.
• Server-side processing MUST be turned on for front-end editing – Note: It will turn on automatically if you forget to enable it.
• MySQL Views cannot be edited properly – only one of the underlying tables can be edited if you pass the proper ID.

So please also check all these points and see if you are calling the data only from one SQL source table, or do you have any JOIN/UNION, etc, if you made an SQL VIEW or if the ID column for editing isn't properly set.

Let me know if you isolated the root of this issue.

Hi Diego,

At this point, it is best if you can grant us remote Admin access to see your table's back-end setup, then we can investigate it.

Please provide me a temporary WP-admin (administrator) user for your website where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

You can write credentials here, just make sure to mark the reply as PRIVATE, then nobody can see them except us.

And confirm this table ID, please.