Okay
  Public Ticket #1116092
Cannot query Mysql Table. Page hangs
Closed

Comments

  •  2
    Satyakirti started the conversation

    I have purchased WpData Tables today. However after activation when I tried to create a test table using both Create New Table as also Table Constructor methods the page hangs into infinite looping.

    The mysql connection test on external db is successful however table generation fails or loops.

    The difference I see between table constructor method and create new table method is in terms of identification and population of table and columns with constructor. After that when i try to save the table the circle animation keeps looping without result.

  •  2
    Satyakirti replied

    The above problem got solved on restarting the machine but I am facing another problem.

    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.

    I have replied you on your another ticket about this