Server Error on third column sort

Server Error on third column sort

dpanscikdpanscik Posts: 202Questions: 47Answers: 0

I have encountered a error that I had not noticed before on any of my other tables. When I sort any column three times in a row I get a server error. The 3rd payload request is very different than payload 1 and 2.

Step #1 - Load a table

Step #2 - sort a column (first sort)

Step #3 - sort same column (second sort)

Step #4 - sort same column (third sort)

Error message in server

Browser error message

This is the code that the browser says is throwing the error

First payload

draw: 3
columns[0][data]: ChildLocator
columns[0][name]: 
columns[0][searchable]: true
columns[0][orderable]: true
columns[0][search][value]: 
columns[0][search][regex]: false
columns[1][data]: AllDone
columns[1][name]: 
columns[1][searchable]: true
columns[1][orderable]: true
columns[1][search][value]: 
columns[1][search][regex]: false
columns[2][data]: Scheduled
columns[2][name]: 
columns[2][searchable]: true
columns[2][orderable]: true
columns[2][search][value]: 
columns[2][search][regex]: false
columns[3][data]: HighlightYellow
columns[3][name]: 
columns[3][searchable]: true
columns[3][orderable]: true
columns[3][search][value]: 
columns[3][search][regex]: false
columns[4][data]: PatientName
columns[4][name]: 
columns[4][searchable]: true
columns[4][orderable]: true
columns[4][search][value]: 
columns[4][search][regex]: false
columns[5][data]: PatientPhone
columns[5][name]: 
columns[5][searchable]: true
columns[5][orderable]: true
columns[5][search][value]: 
columns[5][search][regex]: false
columns[6][data]: Patient_DOB
columns[6][name]: 
columns[6][searchable]: true
columns[6][orderable]: true
columns[6][search][value]: 
columns[6][search][regex]: false
columns[7][data]: MDname
columns[7][name]: 
columns[7][searchable]: true
columns[7][orderable]: true
columns[7][search][value]: 
columns[7][search][regex]: false
columns[8][data]: WCclaimNo
columns[8][name]: 
columns[8][searchable]: true
columns[8][orderable]: true
columns[8][search][value]: 
columns[8][search][regex]: false
columns[9][data]: InsuranceName
columns[9][name]: 
columns[9][searchable]: true
columns[9][orderable]: true
columns[9][search][value]: 
columns[9][search][regex]: false
columns[10][data]: EditedDate
columns[10][name]: 
columns[10][searchable]: true
columns[10][orderable]: true
columns[10][search][value]: 
columns[10][search][regex]: false
columns[11][data]: EditedBy
columns[11][name]: 
columns[11][searchable]: true
columns[11][orderable]: true
columns[11][search][value]: 
columns[11][search][regex]: false
columns[12][data]: 
columns[12][name]: 
columns[12][searchable]: false
columns[12][orderable]: false
columns[12][search][value]: 
columns[12][search][regex]: false
order[0][column]: 4
order[0][dir]: asc
order[0][name]: 
start: 0
length: 10
search[value]: test
search[regex]: false

Second payload

draw: 5
columns[0][data]: ChildLocator
columns[0][name]: 
columns[0][searchable]: true
columns[0][orderable]: true
columns[0][search][value]: 
columns[0][search][regex]: false
columns[1][data]: AllDone
columns[1][name]: 
columns[1][searchable]: true
columns[1][orderable]: true
columns[1][search][value]: 
columns[1][search][regex]: false
columns[2][data]: Scheduled
columns[2][name]: 
columns[2][searchable]: true
columns[2][orderable]: true
columns[2][search][value]: 
columns[2][search][regex]: false
columns[3][data]: HighlightYellow
columns[3][name]: 
columns[3][searchable]: true
columns[3][orderable]: true
columns[3][search][value]: 
columns[3][search][regex]: false
columns[4][data]: PatientName
columns[4][name]: 
columns[4][searchable]: true
columns[4][orderable]: true
columns[4][search][value]: 
columns[4][search][regex]: false
columns[5][data]: PatientPhone
columns[5][name]: 
columns[5][searchable]: true
columns[5][orderable]: true
columns[5][search][value]: 
columns[5][search][regex]: false
columns[6][data]: Patient_DOB
columns[6][name]: 
columns[6][searchable]: true
columns[6][orderable]: true
columns[6][search][value]: 
columns[6][search][regex]: false
columns[7][data]: MDname
columns[7][name]: 
columns[7][searchable]: true
columns[7][orderable]: true
columns[7][search][value]: 
columns[7][search][regex]: false
columns[8][data]: WCclaimNo
columns[8][name]: 
columns[8][searchable]: true
columns[8][orderable]: true
columns[8][search][value]: 
columns[8][search][regex]: false
columns[9][data]: InsuranceName
columns[9][name]: 
columns[9][searchable]: true
columns[9][orderable]: true
columns[9][search][value]: 
columns[9][search][regex]: false
columns[10][data]: EditedDate
columns[10][name]: 
columns[10][searchable]: true
columns[10][orderable]: true
columns[10][search][value]: 
columns[10][search][regex]: false
columns[11][data]: EditedBy
columns[11][name]: 
columns[11][searchable]: true
columns[11][orderable]: true
columns[11][search][value]: 
columns[11][search][regex]: false
columns[12][data]: 
columns[12][name]: 
columns[12][searchable]: false
columns[12][orderable]: false
columns[12][search][value]: 
columns[12][search][regex]: false
order[0][column]: 3
order[0][dir]: desc
order[0][name]: 
start: 0
length: 10
search[value]: test
search[regex]: false

Third payload

draw: 6
columns[0][data]: ChildLocator
columns[0][name]: 
columns[0][searchable]: true
columns[0][orderable]: true
columns[0][search][value]: 
columns[0][search][regex]: false
columns[1][data]: AllDone
columns[1][name]: 
columns[1][searchable]: true
columns[1][orderable]: true
columns[1][search][value]: 
columns[1][search][regex]: false
columns[2][data]: Scheduled
columns[2][name]: 
columns[2][searchable]: true
columns[2][orderable]: true
columns[2][search][value]: 
columns[2][search][regex]: false
columns[3][data]: HighlightYellow
columns[3][name]: 
columns[3][searchable]: true
columns[3][orderable]: true
columns[3][search][value]: 
columns[3][search][regex]: false
columns[4][data]: PatientName
columns[4][name]: 
columns[4][searchable]: true
columns[4][orderable]: true
columns[4][search][value]: 
columns[4][search][regex]: false
columns[5][data]: PatientPhone
columns[5][name]: 
columns[5][searchable]: true
columns[5][orderable]: true
columns[5][search][value]: 
columns[5][search][regex]: false
columns[6][data]: Patient_DOB
columns[6][name]: 
columns[6][searchable]: true
columns[6][orderable]: true
columns[6][search][value]: 
columns[6][search][regex]: false
columns[7][data]: MDname
columns[7][name]: 
columns[7][searchable]: true
columns[7][orderable]: true
columns[7][search][value]: 
columns[7][search][regex]: false
columns[8][data]: WCclaimNo
columns[8][name]: 
columns[8][searchable]: true
columns[8][orderable]: true
columns[8][search][value]: 
columns[8][search][regex]: false
columns[9][data]: InsuranceName
columns[9][name]: 
columns[9][searchable]: true
columns[9][orderable]: true
columns[9][search][value]: 
columns[9][search][regex]: false
columns[10][data]: EditedDate
columns[10][name]: 
columns[10][searchable]: true
columns[10][orderable]: true
columns[10][search][value]: 
columns[10][search][regex]: false
columns[11][data]: EditedBy
columns[11][name]: 
columns[11][searchable]: true
columns[11][orderable]: true
columns[11][search][value]: 
columns[11][search][regex]: false
columns[12][data]: 
columns[12][name]: 
columns[12][searchable]: false
columns[12][orderable]: false
columns[12][search][value]: 
columns[12][search][regex]: false
start: 0
length: 10
search[value]: test
search[regex]: false

Answers

  • allanallan Posts: 63,205Questions: 1Answers: 10,415 Site admin

    What script are you using for server side processing? It sounds like it can't cope with the order parameter not being submitted.

    Allan

  • dpanscikdpanscik Posts: 202Questions: 47Answers: 0

    I am using editor-dll version 2.3.2

  • allanallan Posts: 63,205Questions: 1Answers: 10,415 Site admin

    That's odd - I don't think I've seen that error. I'll try it when I get into the office. For the moment you could do:

    DataTable.defaults.column.orderSequence = ['asc', 'desc'];
    

    to disable the third "No sort" option when clicking on the header.

    Allan

  • dpanscikdpanscik Posts: 202Questions: 47Answers: 0
    DataTable.defaults.column.orderSequence = ['asc', 'desc'];
    

    This does indeed solve the problem.

Sign In or Register to comment.