Uncaught TypeError: Cannot read properties of undefined (reading 'length')

tableFan22

Hello,
I've been trying to fix this error for days, but unfortunately with no luck... I have the licenses for the editor tables from my company where I work. This is my private account.

            public ActionResult EditorTable()
                    {         
                        string dbConnection = this._configuration.GetSection("ConnectionStrings")[connection];

                        using (var db = new Database("azure", dbConnection))

                            {
                                var response = new Editor(db, "DBtable")
                                    .Model<DBtable>()
                                    .Field(new Field("Name"))
                                    .TryCatch(false)                     
                                    .Process(Request)
                                    .Data();
                                return Json(response);
                            }

                    }

            <div class = "card">
                <div class = "card-header"></div>
                <div class = "card-body">
                    <table id = "tableID" class="table">
                        <thead>
                            <tr>
                                <th>
                                    Name
                                </th>
                                <th></th>
                            </tr>
                        </thead>
                        <tfoot>
                            <tr></tr>
                        </tfoot>  
                    </table>
                </div>
                <div class = "card-footer"></div>
            </div>


            <script type="text/javascript">
                    var editor;  
                    $(document).ready(function(){
                        editor = new $.fn.dataTable.Editor ({
                            ajax: {url: "/Controller/EditorTable" , type: "POST"},
                            table: "#tableID",
                            fields: [{
                                label: "Name",
                                name: "Name"           
                                }
                            ]
                        });

                        $('#tableID').on('click', 'tbody td:not(:first-child)', function (e) {
                            editor.inline(this);
                        });

                       var table = $('#tableID').DataTable({
                        dom: "Bfrtip",
                        lengthMenu: [
                           [10, 25, 50, -1],
                           ['10 rows', '25 rows', '50 rows', 'Show all']
                        ],
                        stateSave: true,
                        ajax: "/Controller/EditorTable",

                        columns: [
                            {
                                data: null,
                                defaultContent: '',
                                className: 'select-checkbox',
                                orderable: false
                            },
                            { data: "Name"}
                        ],
                        select: {
                            style: 'os',
                            selector: 'td:first-child'
                        },
                        buttons: [
                            { extend: "create", editor: editor },
                            { extend: "edit", editor: editor },
                            { extend: "remove", editor: editor },
                            'pageLength'
                        ]
                      });
                  });
                </script>

allan

At what point does the error happen? On load, edit, delete or something else? Can you show me the JSON response from the server when it does happen please?

Thanks,
Allan

tableFan22

hi Allan, it happens directly when the data is displayed. The table says "Loading" all the time

colin

Thanks for the stack trace, but can you also post the response from the server, please, when this error occurs. You'll be able to get this from the network inspector for the browser,

Colin

tableFan22

hi Colin, this is the server response from the page with the editor table..

tableFan22

status 101

colin

That's the problem, the server should be returning valid JSON containing the data for the rows. Have you ran the PHP script on the server, as this would display the errors? Also, have you checked any server-side logfiles to see why that "status 101" message is being returned?

Colin

tableFan22

hello, I found my problem ..the problem was with the json reader