Hi

My system is on localhost but will be on the web in the next week ..

I have a transaction table and when I try and delete or edit a row, the system produces an error 

On Edit

Error! There was an error trying to update the row! 

Error: Unknown column 'id' in 'where clause'

This is my SQL statement

SELECT 
*
FROM
transactions
WHERE
transactions.member_id = %CURRENT_USER_ID%

On Delete

Success ! Row has been Deleted !

but the row is still present in the table 

Any help would be much appreciated 

Thanks

Colin

Hi

I have solved the problem the id column 

Change Column EDITING, Column cannot be empty setting was Enabled.

Although the column cannot be empty, as it is auto incremented given by the table definition, wpDataTables does not need to populate the column, so the above setting must be Disabled.

Change Column EDITING, Column cannot be empty setting should be  Disabled or OFF.

So this ticket can now be closed, thanks.

Best

Colin