MySQL Error: 1064

MySQL Error: 1064

j3ff3j3ff3 Posts: 3Questions: 0Answers: 0
edited February 2014 in Bug reports
http://datatables.net/release-datatables/examples/server_side/scripts/server_processing.php?sEcho=1&iColumns=5&sColumns=&iDisplayStart=0&iDisplayLength=-10&mDataProp_0=0&mDataProp_1=1&mDataProp_2=2&mDataProp_3=3&mDataProp_4=4&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&sSearch_4=&bRegex_4=false&bSearchable_4=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=1&bSortable_0=true&bSortable_1=true&bSortable_2=true&bSortable_3=true&bSortable_4=true&_=1392663688753

Check param "iDisplayLength" on the server side if it set to minus value and != "-1", Example: "-10".
Mysql query will be ... LIMIT 10, -10 ...

Replies

  • j3ff3j3ff3 Posts: 3Questions: 0Answers: 0
    edited February 2014
    http://datatables.net/release-datatables/examples/server_side/scripts/server_processing.php?sEcho=1&iColumns=5&sColumns=&iDisplayStart=0&iDisplayLength=10&mDataProp_0=0&mDataProp_1=1&mDataProp_2=2&mDataProp_3=3&mDataProp_4=4&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&sSearch_4=&bRegex_4=false&bSearchable_4=true&iSortCol_0=0&sSortDir_0=asc&iSortingCols=9223372036854775807&bSortable_0=true&bSortable_1=true&bSortable_2=true&bSortable_3=true&bSortable_4=true&_=1392663688753

    "iSortingCols=9223372036854775807" == Maximum execution time ?

    From your example code "for ( $i=0 ; $i
  • allanallan Posts: 60,929Questions: 1Answers: 9,932 Site admin
    Should be fixed in the latest libraries with 1.10 I think: http://next.datatables.net/examples/server_side/simple.html

    Allan
This discussion has been closed.