Server Error on third column sort

dpanscik

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

allan

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

Allan

dpanscik

I am using editor-dll version 2.3.2

allan

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

dpanscik

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

This does indeed solve the problem.