Okay
  Public Ticket #1116290
Irrational behaviour of new row creation
Closed

Comments

  •  2
    Satyakirti started the conversation

    I have a table with the basic details of the customer viz columns are Cust Id which is VARCHAR , First Name VARCHAR Middle Name,  Date of Purchase DATE

    Now the problem is when I try to insert a new row of data the output thrown at me is " There was an error trying to insert a new row!Error:Column Cust _ID can not be NULL"

    In the process of debugging I changed the column type in optional column setup window of WPData Tables to Integer...then I get the same error for the next column ie for First Name. On changing that to integer the bug moves to next column and so forth.

    What is happening and how to debug. I have a separate ID field which is auto increment. 

    This happens in preview window while in runtime trying to add results in hanging of the new record updation window

  • [deleted] replied

    Hi Satyakirti,
    Thank you for the purchase.

    How did you create wpDataTable? Using MySQL query or you created Manual wpDataTable using wpDataTables constructor?

  •  2
    Satyakirti replied

    i have used table constructor

  • [deleted] replied

    Hi Satyakirti,

    Please provide me a temporary WP-admin login for your site 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 party. You can write credentials just check PRIVATE so nobody can see it except us.