As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #1682174
update and delete a row failing
Closed

Comments

  •  6
    cpshart started the conversation
    August 19, 2018 at 3:05pm

    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

  •  6
    cpshart replied
    August 20, 2018 at 7:22am

    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