Hi support team, 

When I tried to create a table by the SQL Query Input data source type of the 1st menu "Create a table linked to an existing data source." , the below error message happens on the red popup window. I used the SQL query :  SELECT * FROM `navien_dsbf_bo_service_ticket` as described in my phpMyAdmin. 

The similar error is also happening on the menu 'Generate a query to MySQL datable'. 

Even, when I tested a manual creation, the page by the shortcode is indefinitely loading the page with the error popup: "DataTables warning: table id=table_1 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1"

you can check this on https://navienuk.com/v1/bo-ticket-management/ 

Anyhow, my main goal is to get a My SQL Db and to edit it via shortcode page..

Please let me know what is wrong urgently, because I have a presentation it on Monday to my boss.

----------------------------------------------------

Error There was an error while trying to save the table! OK  {"table":{"id":7,"title":"New wpDataTable","show_title":1,"table_type":"mysql","connection":"","content": "SELECT * FROM `navien_dsbf_bo_service_ticket` WHERE 1","filtering":1,"filtering_form":0,"sorting":1,"tools":1,"server_side":1,"editable":0, "inline_editing":0,"popover_tools":0,"editor_roles":"","mysql_table_name":"","edit_only_own_rows":0,"userid_column_id":0,"display_length":10, "auto_refresh":0,"fixed_columns":"-1","fixed_layout":0,"responsive":1,"scrollable":0,"word_wrap":0,"hide_before_load":1,"var1":"","var2":"", "var3":"","tabletools_config":{"print":1,"copy":1,"excel":1,"csv":1,"pdf":0},"advanced_settings":"{\"info_block\":1,\"global_search\":1, \"showRowsPerPage\":1,\"clearFilters\":0}","columns":[{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"", "defaultSortingColumn":0,"display_header":"ticket_id","editor_type":"text","filter_type":"number","filterDefaultValue":"","formula":"", "groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":91,"id_column":0,"input_mandatory":0,"orig_header":"ticket_id","pos":0, "skip_thousands_separator":0,"text_after":"","text_before":"","type":"int","valuesList":"","visible":1,"width":"","decimalPlaces":-1, "possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0, "filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"", "linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"", "defaultSortingColumn":0,"display_header":"ticket_description","editor_type":"text","filter_type":"text","filterDefaultValue":"","formula":"", "groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":92,"id_column":0,"input_mandatory":0,"orig_header":"ticket_description","pos":1, "skip_thousands_separator":0,"text_after":"","text_before":"","type":"string","valuesList":"","visible":1,"width":"","decimalPlaces":-1, "possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0, "filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"", "linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"", "defaultSortingColumn":0,"display_header":"ticket_snumber","editor_type":"text","filter_type":"text","filterDefaultValue":"","formula":"", "groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":93,"id_column":0,"input_mandatory":0,"orig_header":"ticket_snumber","pos":2, "skip_thousands_separator":0,"text_after":"","text_before":"","type":"string","valuesList":"","visible":1,"width":"","decimalPlaces":-1, "possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0, "filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"", "linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"", "defaultSortingColumn":0,"display_header":"ticket_report_date","editor_type":"text","filter_type":"text","filterDefaultValue":"","formula":"", "groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":94,"id_column":0,"input_mandatory":0,"orig_header":"ticket_report_date","pos":3, "skip_thousands_separator":0,"text_after":"","text_before":"","type":"date","valuesList":"","visible":1,"width":"","decimalPlaces":-1, "possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0, "filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"", "linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"", "defaultSortingColumn":0,"display_header":"ticket_status","editor_type":"text","filter_type":"number","filterDefaultValue":"","formula":"", "groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":95,"id_column":0,"input_mandatory":0,"orig_header":"ticket_status","pos":4, "skip_thousands_separator":0,"text_after":"","text_before":"","type":"int","valuesList":"","visible":1,"width":"","decimalPlaces":-1, "possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0, "filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"", "linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"", "defaultSortingColumn":0,"display_header":"ticket_title","editor_type":"text","filter_type":"text","filterDefaultValue":"","formula":"", "groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":96,"id_column":0,"input_mandatory":0,"orig_header":"ticket_title","pos":5, "skip_thousands_separator":0,"text_after":"","text_before":"","type":"string","valuesList":"","visible":1,"width":"","decimalPlaces":-1, "possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0, "filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"", "linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"", "defaultSortingColumn":0,"display_header":"ticket_name","editor_type":"text","filter_type":"text","filterDefaultValue":"","formula":"", "groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":97,"id_column":0,"input_mandatory":0,"orig_header":"ticket_name","pos":6, "skip_thousands_separator":0,"text_after":"","text_before":"","type":"string","valuesList":"","visible":1,"width":"","decimalPlaces":-1, "possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0, "filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"", "linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"", "defaultSortingColumn":0,"display_header":"ticket_email","editor_type":"text","filter_type":"text","filterDefaultValue":"","formula":"", "groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":98,"id_column":0,"input_mandatory":0,"orig_header":"ticket_email","pos":7, "skip_thousands_separator":0,"text_after":"","text_before":"","type":"email","valuesList":"","visible":1,"width":"","decimalPlaces":-1, "possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0, "filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"", "linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"", "defaultSortingColumn":0,"display_header":"ticket_telnumber","editor_type":"text","filter_type":"number","filterDefaultValue":"", "formula":"","groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":99,"id_column":0,"input_mandatory":0, "orig_header":"ticket_telnumber","pos":8,"skip_thousands_separator":0,"text_after":"","text_before":"","type":"int","valuesList":"", "visible":1,"width":"","decimalPlaces":-1,"possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0, "calculateMin":0,"sorting":1,"exactFiltering":0,"filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"", "dateInputFormat":"","linkTargetAttribute":"","linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0, "color":"","conditional_formatting":0,"css_class":"","defaultSortingColumn":0,"display_header":"ticket_postcode","editor_type":"text", "filter_type":"text","filterDefaultValue":"","formula":"","groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":100,"id_column":0, "input_mandatory":0,"orig_header":"ticket_postcode","pos":9,"skip_thousands_separator":0,"text_after":"","text_before":"","type":"string", "valuesList":"","visible":1,"width":"","decimalPlaces":-1,"possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0, "calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0,"filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read", "editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"","linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""}, {"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"","defaultSortingColumn":0,"display_header":"ticket_address","editor_type":"text","filter_type":"text","filterDefaultValue":"","formula":"","groupColumn":0,"hide_on_mobiles":0, "hide_on_tablets":0,"id":101,"id_column":0,"input_mandatory":0,"orig_header":"ticket_address","pos":10,"skip_thousands_separator":0,"text_after":"","text_before":"","type":"string","valuesList":"","visible":1,"width":"","decimalPlaces":-1, "possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0,"filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"", "linkTargetAttribute":"","linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"","defaultSortingColumn":0,"display_header":"ticket_installed_date","editor_type":"text", "filter_type":"text","filterDefaultValue":"","formula":"","groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":102,"id_column":0,"input_mandatory":0,"orig_header":"ticket_installed_date","pos":11,"skip_thousands_separator":0,"text_after":"","text_before":"", "type":"date","valuesList":"","visible":1,"width":"","decimalPlaces":-1,"possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0,"calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0,"filterLabel":"","checkboxesInModal":0, "possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"","linkButtonAttribute":0,"linkButtonLabel":"","linkButtonClass":""},{"calculateTotal":0,"color":"","conditional_formatting":0,"css_class":"", "defaultSortingColumn":0,"display_header":"ticket_date_tovisit","editor_type":"text","filter_type":"text","filterDefaultValue":"","formula":"","groupColumn":0,"hide_on_mobiles":0,"hide_on_tablets":0,"id":103,"id_column":0,"input_mandatory":0, "orig_header":"ticket_date_tovisit","pos":12,"skip_thousands_separator":0,"text_after":"","text_before":"","type":"date","valuesList":"","visible":1,"width":"","decimalPlaces":-1,"possibleValuesAddEmpty":0,"possibleValuesAjax":10,"calculateAvg":0, "calculateMax":0,"calculateMin":0,"sorting":1,"exactFiltering":0,"filterLabel":"","checkboxesInModal":0,"possibleValuesType":"read","editingDefaultValue":"","dateInputFormat":"","linkTargetAttribute":"","linkButtonAttribute":0,"linkButtonLabel":"", "linkButtonClass":""}],"info_block":1,"global_search":1,"showRowsPerPage":1,"clearFilters":0},"wdtJsonConfig":{"tableId":"table_1","tableType":"mysql","selector":"#table_1","responsive":true,"editable":false,"inlineEditing":false,"infoBlock":true, "tableWpId":7,"dataTableParams":{"sDom":"BT<'clear'>lftip","bSortCellsTop":false,"bFilter":true,"bPaginate":true,"aLengthMenu":[[1,5,10,25,50,100,-1],[1,5,10,25,50,100,"All"]],"iDisplayLength":10,"columnDefs":[{"sType":"formatted-num","wdtType":"int", "bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"ticket_id","origHeader":"ticket_id","notNull":false,"conditionalFormattingRules":[],"className":"numdata integer column-ticket_id","aTargets":[0]},{"sType":"string", "wdtType":"string","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"ticket_description","origHeader":"ticket_description","notNull":false,"conditionalFormattingRules":[],"className":" column-ticket_description", "aTargets":[1]},{"sType":"string","wdtType":"string","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"ticket_snumber","origHeader":"ticket_snumber","notNull":false,"conditionalFormattingRules":[],"className":" column-ticket_snumber", "aTargets":[2]},{"sType":"date-custom","wdtType":"date","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"ticket_report_date","origHeader":"ticket_report_date","notNull":false,"conditionalFormattingRules":[], "className":" column-ticket_report_date","aTargets":[3]},{"sType":"formatted-num","wdtType":"int","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"ticket_status","origHeader":"ticket_status","notNull":false, "conditionalFormattingRules":[],"className":"numdata integer column-ticket_status","aTargets":[4]},{"sType":"string","wdtType":"string","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"ticket_title","origHeader":"ticket_title", "notNull":false,"conditionalFormattingRules":[],"className":" column-ticket_title","aTargets":[5]},{"sType":"string","wdtType":"string","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"ticket_name","origHeader":"ticket_name", "notNull":false,"conditionalFormattingRules":[],"className":" column-ticket_name","aTargets":[6]},{"sType":"html","wdtType":"email","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"ticket_email","origHeader":"ticket_email", "notNull":false,"conditionalFormattingRules":[],"className":" column-ticket_email","aTargets":[7]},{"sType":"formatted-num","wdtType":"int","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"ticket_telnumber", "origHeader":"ticket_telnumber","notNull":false,"conditionalFormattingRules":[],"className":"numdata integer column-ticket_telnumber","aTargets":[8]},{"sType":"string","wdtType":"string","bVisible":true,"orderable":true,"searchable":true, "InputType":"text","name":"ticket_postcode","origHeader":"ticket_postcode","notNull":false,"conditionalFormattingRules":[],"className":" column-ticket_postcode","aTargets":[9]},{"sType":"string","wdtType":"string","bVisible":true,"orderable":true, "searchable":true,"InputType":"text","name":"ticket_address","origHeader":"ticket_address","notNull":false,"conditionalFormattingRules":[],"className":" column-ticket_address","aTargets":[10]},{"sType":"date-custom","wdtType":"date","bVisible":true, "orderable":true,"searchable":true,"InputType":"text","name":"ticket_installed_date","origHeader":"ticket_installed_date","notNull":false,"conditionalFormattingRules":[],"className":" column-ticket_installed_date","aTargets":[11]},{"sType":"date-custom", "wdtType":"date","bVisible":true,"orderable":true,"searchable":true,"InputType":"text","name":"ticket_date_tovisit","origHeader":"ticket_date_tovisit","notNull":false,"conditionalFormattingRules":[],"className":" column-ticket_date_tovisit","aTargets":[12]}], "bAutoWidth":false,"order":[[0,"asc"]],"ordering":true,"buttons":[{"extend":"print","exportOptions":{"columns":":visible"},"className":"DTTT_button DTTT_button_print","text":"Print"},{"extend":"excelHtml5","exportOptions":{"columns":":visible"}, "className":"DTTT_button DTTT_button_xls","title":"New wpDataTable","text":"Excel"},{"extend":"csvHtml5","exportOptions":{"columns":":visible"},"className":"DTTT_button DTTT_button_csv","title":"New wpDataTable","text":"CSV"},{"extend":"copyHtml5", "exportOptions":{"columns":":visible"},"className":"DTTT_button DTTT_button_copy","title":"New wpDataTable","text":"Copy"}],"bProcessing":false,"serverSide":true,"ajax":{"url":"https:\/\/navienuk.com\/v1\/wp-admin\/admin-ajax.php?action=get_wdtable&table_id=7", "type":"POST"},"sPaginationType":"full_numbers","oSearch":{"bSmart":false,"bRegex":false,"sSearch":""}},"tabletWidth":"1024","mobileWidth":"480","advancedFilterEnabled":true,"advancedFilterOptions":{"aoColumns":[{"type":"number","possibleValuesType":"read", "values":null,"origHeader":"ticket_id","displayHeader":"ticket_id","possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":""},{"type":"text", "possibleValuesType":"read","values":null,"origHeader":"ticket_description","displayHeader":"ticket_description","possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0, "linkButtonLabel":""},{"type":"text","possibleValuesType":"read","values":null,"origHeader":"ticket_snumber","displayHeader":"ticket_snumber","possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"", "checkboxesInModal":0,"linkButtonLabel":""},{"type":"text","possibleValuesType":"read","values":null,"origHeader":"ticket_report_date","displayHeader":"ticket_report_date","possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"", "exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":""},{"type":"number","possibleValuesType":"read","values":null,"origHeader":"ticket_status","displayHeader":"ticket_status","possibleValuesAddEmpty":false, "possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":""},{"type":"text","possibleValuesType":"read","values":null,"origHeader":"ticket_title","displayHeader":"ticket_title", "possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":""},{"type":"text","possibleValuesType":"read","values":null,"origHeader":"ticket_name", "displayHeader":"ticket_name","possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":""},{"type":"text","possibleValuesType":"read","values":null, "origHeader":"ticket_email","displayHeader":"ticket_email","possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":""},{"type":"number", "possibleValuesType":"read","values":null,"origHeader":"ticket_telnumber","displayHeader":"ticket_telnumber","possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0, "linkButtonLabel":""},{"type":"text","possibleValuesType":"read","values":null,"origHeader":"ticket_postcode","displayHeader":"ticket_postcode","possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"", "checkboxesInModal":0,"linkButtonLabel":""},{"type":"text","possibleValuesType":"read","values":null,"origHeader":"ticket_address","displayHeader":"ticket_address","possibleValuesAddEmpty":false,"possibleValuesAjax":10,"defaultValue":"","exactFiltering":false, "filterLabel":"","checkboxesInModal":0,"linkButtonLabel":""},{"type":"text","possibleValuesType":"read","values":null,"origHeader":"ticket_installed_date","displayHeader":"ticket_installed_date","possibleValuesAddEmpty":false,"possibleValuesAjax":10, "defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":""},{"type":"text","possibleValuesType":"read","values":null,"origHeader":"ticket_date_tovisit","displayHeader":"ticket_date_tovisit","possibleValuesAddEmpty":false, "possibleValuesAjax":10,"defaultValue":"","exactFiltering":false,"filterLabel":"","checkboxesInModal":0,"linkButtonLabel":""}],"bUseColVis":true},"filterInForm":false,"serverSide":true,"autoRefreshInterval":0,"processing":true,"fnServerData":true,"columnsFixed":0, "sumFunctionsLabel":"","avgFunctionsLabel":"","minFunctionsLabel":"","maxFunctionsLabel":"","columnsDecimalPlaces":{"ticket_id":-1,"ticket_description":-1,"ticket_snumber":-1,"ticket_report_date":-1,"ticket_status":-1,"ticket_title":-1,"ticket_name":-1, "ticket_email":-1,"ticket_telnumber":-1,"ticket_postcode":-1,"ticket_address":-1,"ticket_installed_date":-1,"ticket_date_tovisit":-1},"columnsThousandsSeparator":{"ticket_id":1,"ticket_status":1,"ticket_telnumber":1},"sumColumns":[],"avgColumns":[], "sumAvgColumns":[],"timeFormat":"h:i A","datepickFormat":"dd\/mm\/yy"},"wdtHtml":"\n

\n \n \"411aedfeed\" \"\/v1\/wp-admin\/admin-ajax.php\"