Deleting just a few records I query to delete all selected records (say 1000 records), but it delet

chagold

I query to delete all selected records (say 1000 records) and it appears to me that it deleted all, but in practice it only deletes 24 records.
The debug check shows that the delete query was only on a few records.
How to solve it?

var table = $('#table_id').DataTable( {
        scrollY: 400,
        dom: 'Bfrtip',
        select: true,
        //keys: true,
        buttons: [
            { extend: 'create', editor: editor },
            { extend: 'edit',   editor: editor },
            { extend: 'remove', editor: editor }
        ],
        

        order: [[ 0, 'DESC' ]],
        qpageLength: 300,
        data: data,
        ajax: {
            url: 'https://www.karyera.org.il/controlPanel-new/jobs.php',
            dataSrc: ''
        },
        //scrollY:        200,
        deferRender:    true,
        scroller:       true,
    
        
        responsive: true,
        columns: [
            
        
         
        { data: 'job_id' },
        { data: 'job_sub_id' },     
        { data: 'city' },
        { data: 'scope' ,"width": "60px"},

        { data: 'job_phone' ,"width": "60px"},
        { data: 'job_fax' ,"width": "60px"},
        { data: 'job_email' ,"width": "60px"},
        { data: 'genedr' ,"width": "60px"},
        { data: 'date' ,"width": "60px"},

        { data: 'hot_job_or_not' ,"width": "60px"},

        { data: 'job_info' ,"width": "60px"},
        { data: 'business_owner' },
        { data: 'contact_person' ,"width": "60px"},
        { data: 'area' ,"width": "60px"},
        { data: 'name_rep' ,"width": "60px"},
        { data: 'source' ,"width": "60px"},

        { data: 'id_number' ,"width": "60px",visible: false},

        { data: 'id',visible: false},
        //{ data: 'citi_id' ,"width": "60px",visible: false},
        { data: 'phone' ,"width": "60px",visible: false},
        { data: 'email' ,"width": "60px",visible: false},
        { data: 'adress' ,"width": "60px",visible: false},
        { data: 'date_orginal' ,"width": "60px",visible: false},

        
        { data: 'private_company' ,"width": "60px",visible: false},


        { data: 'publish_on_others' ,"width": "60px",visible: false},
        
        { data: 'Mobile' ,"width": "60px",visible: false},
        { data: 'city_location' ,"width": "60px",visible: false},
        { data: 'owner_contact_person' ,"width": "60px",visible: false},
        { data: 'approved_by_karyera' ,"width": "60px",visible: false},
        { data: 'u_name' ,"width": "60px",visible: false},
        { data: 'u_password' ,"width": "60px",visible: false},
        { data: 'id_number' ,"width": "60px",visible: false},

        { data: 'credit_owner_full_name' ,"width": "60px",visible: false},
        { data: 'credit_type' ,"width": "60px",visible: false},
        { data: 'credit_num' ,"width": "60px",visible: false},
        { data: 'cvv' ,"width": "60px",visible: false},
        { data: 'expire' ,"width": "60px",visible: false},
        { data: 'comment' ,"width": "60px",visible: false},
        { data: 'credit_num' ,"width": "60px",visible: false},
        { data: 'phone_to_credit_copmany' ,"width": "60px",visible: false}


        ]
    } 
    );

{"data":[],"debug":[{"query":"DELETE FROM  `business_owner` WHERE (`id` = :where_1 )OR(`id` = :where_4 )OR(`id` = :where_7 )OR(`id` = :where_10 )OR(`id` = :where_13 )OR(`id` = :where_16 )OR(`id` = :where_19 )OR(`id` = :where_22 )OR(`id` = :where_25 )OR(`id` = :where_28 )OR(`id` = :where_31 )OR(`id` = :where_34 )OR(`id` = :where_37 )OR(`id` = :where_40 )OR(`id` = :where_43 )OR(`id` = :where_46 )OR(`id` = :where_49 )OR(`id` = :where_52 )OR(`id` = :where_55 )OR(`id` = :where_58 )OR(`id` = :where_61 )OR(`id` = :where_64 )OR(`id` = :where_67 )OR(`id` = :where_70 )OR(`id` = :where_73 )","bindings":[{"name":":where_1","value":"17817","type":null},{"name":":where_4","value":"17818","type":null},{"name":":where_7","value":"17819","type":null},{"name":":where_10","value":"17820","type":null},{"name":":where_13","value":"17821","type":null},{"name":":where_16","value":"17822","type":null},{"name":":where_19","value":"17823","type":null},{"name":":where_22","value":"17824","type":null},{"name":":where_25","value":"17825","type":null},{"name":":where_28","value":"17826","type":null},{"name":":where_31","value":"17827","type":null},{"name":":where_34","value":"17828","type":null},{"name":":where_37","value":"17829","type":null},{"name":":where_40","value":"17830","type":null},{"name":":where_43","value":"17831","type":null},{"name":":where_46","value":"17832","type":null},{"name":":where_49","value":"17833","type":null},{"name":":where_52","value":"17834","type":null},{"name":":where_55","value":"17835","type":null},{"name":":where_58","value":"17836","type":null},{"name":":where_61","value":"17837","type":null},{"name":":where_64","value":"17838","type":null},{"name":":where_67","value":"17839","type":null},{"name":":where_70","value":"17840","type":null},{"name":":where_73","value":"17841","type":null}]}]}

allan

Very likely you need to increase the max_input_vars option in your PHP install.

Allan