tigrang / cakephp-datatable

JQuery DataTable plugin server-side processing component for CakePHP
47 stars 29 forks source link

Error with cakephp 2.5.2 #48

Closed khiemnd-ait closed 10 years ago

khiemnd-ait commented 10 years ago

I have 4 records with limit 3.

But when I click on link page 2, It's only show prev 1 next.

tigrang commented 10 years ago

Can you get me the response body of the first request and the second request?

khiemnd-ait commented 10 years ago

The first response: {"iTotalRecords":4,"iTotalDisplayRecords":4,"sEcho":1,"aaData":[["1","\u0110ua si\u00eau xe 2","2Fast2Furious","2014-06-04 02:12:40"],["2","Tr\u00f2 ch\u01a1i tr\u00fang th\u01b0\u1edfng 2in1","2-in-1 Award-Winning Games","2014-06-04 02:25:29"],["3","2Fast2Furious","2Fast2Furious","2014-06-04 03:15:45"]]} The second response:{"iTotalRecords":4,"iTotalDisplayRecords":1,"sEcho":2,"aaData":[["4","2Fast2Furious","2Fast2Furious","2014-06-04 03:17:41"]]}

^^

Date: Wed, 9 Jul 2014 09:11:02 -0700 From: notifications@github.com To: cakephp-datatable@noreply.github.com CC: khiemnd@hotmail.com Subject: Re: [cakephp-datatable] Error with cakephp 2.5.2 (#48)

Can you get me the response body of the first request and the second request?

— Reply to this email directly or view it on GitHub.

tigrang commented 10 years ago

How are you setting the limit? On Jul 9, 2014 6:48 PM, "khiemnd" notifications@github.com wrote:

The first response: {"iTotalRecords":4,"iTotalDisplayRecords":4,"sEcho":1,"aaData":[["1","\u0110ua si\u00eau xe 2","2Fast2Furious","2014-06-04 02:12:40"],["2","Tr\u00f2 ch\u01a1i tr\u00fang th\u01b0\u1edfng 2in1","2-in-1 Award-Winning Games","2014-06-04 02:25:29"],["3","2Fast2Furious","2Fast2Furious","2014-06-04 03:15:45"]]} The second response:{"iTotalRecords":4,"iTotalDisplayRecords":1,"sEcho":2,"aaData":[["4","2Fast2Furious","2Fast2Furious","2014-06-04 03:17:41"]]}

^^

Date: Wed, 9 Jul 2014 09:11:02 -0700 From: notifications@github.com To: cakephp-datatable@noreply.github.com CC: khiemnd@hotmail.com Subject: Re: [cakephp-datatable] Error with cakephp 2.5.2 (#48)

Can you get me the response body of the first request and the second request?

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/tigrang/cakephp-datatable/issues/48#issuecomment-48556764 .

khiemnd-ait commented 10 years ago

Hi, I follow your readme file.

<?php echo $this->DataTable->render('Game', array('class'=>'table table-bordered table-hover dataTable'), array('sAjaxSource'=>$this->Html->url(array( 'controller' => 'games', 'action' => 'getGames', 'admin' => false, '?' => array('model'=>'Game') )))); ?> <?php echo $this->Html->scriptStart(array('inline'=>false)); ?>$(document).ready(function(){$.extend( $.fn.dataTable.defaults, { "bFilter": true, "bSort": false, "iDisplayLength": 3, "aLengthMenu": [[1, 2, 3, -1], [1, 2, 3, "All"]]} );});<?php echo $this->Html->scriptEnd(); ?>

Date: Wed, 9 Jul 2014 19:45:39 -0700 From: notifications@github.com To: cakephp-datatable@noreply.github.com CC: khiemnd@hotmail.com Subject: Re: [cakephp-datatable] Error with cakephp 2.5.2 (#48)

How are you setting the limit?

On Jul 9, 2014 6:48 PM, "khiemnd" notifications@github.com wrote:

The first response:

{"iTotalRecords":4,"iTotalDisplayRecords":4,"sEcho":1,"aaData":[["1","\u0110ua

si\u00eau xe 2","2Fast2Furious","2014-06-04 02:12:40"],["2","Tr\u00f2

ch\u01a1i tr\u00fang th\u01b0\u1edfng 2in1","2-in-1 Award-Winning

Games","2014-06-04

02:25:29"],["3","2Fast2Furious","2Fast2Furious","2014-06-04 03:15:45"]]}

The second

response:{"iTotalRecords":4,"iTotalDisplayRecords":1,"sEcho":2,"aaData":[["4","2Fast2Furious","2Fast2Furious","2014-06-04

03:17:41"]]}

^^

Date: Wed, 9 Jul 2014 09:11:02 -0700

From: notifications@github.com

To: cakephp-datatable@noreply.github.com

CC: khiemnd@hotmail.com

Subject: Re: [cakephp-datatable] Error with cakephp 2.5.2 (#48)

Can you get me the response body of the first request and the second

request?

Reply to this email directly or view it on GitHub.

Reply to this email directly or view it on GitHub

https://github.com/tigrang/cakephp-datatable/issues/48#issuecomment-48556764

.

— Reply to this email directly or view it on GitHub.

tigrang commented 10 years ago

Ok, can you get the request params as well?

On Wed, Jul 9, 2014 at 8:11 PM, khiemnd notifications@github.com wrote:

Hi, I follow your readme file.

<?php echo $this->DataTable->render('Game', array('class'=>'table table-bordered table-hover dataTable'), array('sAjaxSource'=>$this->Html->url(array( 'controller' => 'games', 'action' => 'getGames', 'admin' => false, '?' => array('model'=>'Game') )))); ?> <?php echo $this->Html->scriptStart(array('inline'=>false)); ?>$(document).ready(function(){$.extend( $.fn.dataTable.defaults, { "bFilter": true, "bSort": false, "iDisplayLength": 3, "aLengthMenu": [[1, 2, 3, -1], [1, 2, 3, "All"]]} );});<?php echo $this->Html->scriptEnd(); ?>

Date: Wed, 9 Jul 2014 19:45:39 -0700 From: notifications@github.com To: cakephp-datatable@noreply.github.com CC: khiemnd@hotmail.com Subject: Re: [cakephp-datatable] Error with cakephp 2.5.2 (#48)

How are you setting the limit?

On Jul 9, 2014 6:48 PM, "khiemnd" notifications@github.com wrote:

The first response:

{"iTotalRecords":4,"iTotalDisplayRecords":4,"sEcho":1,"aaData":[["1","\u0110ua

si\u00eau xe 2","2Fast2Furious","2014-06-04 02:12:40"],["2","Tr\u00f2

ch\u01a1i tr\u00fang th\u01b0\u1edfng 2in1","2-in-1 Award-Winning

Games","2014-06-04

02:25:29"],["3","2Fast2Furious","2Fast2Furious","2014-06-04 03:15:45"]]}

The second

response:{"iTotalRecords":4,"iTotalDisplayRecords":1,"sEcho":2,"aaData":[["4","2Fast2Furious","2Fast2Furious","2014-06-04

03:17:41"]]}

^^

Date: Wed, 9 Jul 2014 09:11:02 -0700

From: notifications@github.com

To: cakephp-datatable@noreply.github.com

CC: khiemnd@hotmail.com

Subject: Re: [cakephp-datatable] Error with cakephp 2.5.2 (#48)

Can you get me the response body of the first request and the second

request?

Reply to this email directly or view it on GitHub.

Reply to this email directly or view it on GitHub

< https://github.com/tigrang/cakephp-datatable/issues/48#issuecomment-48556764

.

— Reply to this email directly or view it on GitHub.

— Reply to this email directly or view it on GitHub https://github.com/tigrang/cakephp-datatable/issues/48#issuecomment-48560955 .

khiemnd-ait commented 10 years ago

The first:model=Game&sEcho=1&iColumns=4&sColumns=%2C%2C%2C&iDisplayStart=0&iDisplayLength=3&mDataProp_0=0&sSearch_0=&bRegex_0=false&bSearchable_0=true&mDataProp_1=1&sSearch_1=&bRegex_1=false&bSearchable_1=true&mDataProp_2=2&sSearch_2=&bRegex_2=false&bSearchable_2=true&mDataProp_3=3&sSearch_3=&bRegex_3=false&bSearchable3=true&sSearch=&bRegex=false&=1404967632356The second:model=Game&sEcho=2&iColumns=4&sColumns=%2C%2C%2C&iDisplayStart=3&iDisplayLength=3&mDataProp_0=0&sSearch_0=&bRegex_0=false&bSearchable_0=true&mDataProp_1=1&sSearch_1=&bRegex_1=false&bSearchable_1=true&mDataProp_2=2&sSearch_2=&bRegex_2=false&bSearchable_2=true&mDataProp_3=3&sSearch_3=&bRegex_3=false&bSearchable3=true&sSearch=&bRegex=false&=1404967632357I don't see any problems with request params.

Date: Wed, 9 Jul 2014 21:35:30 -0700 From: notifications@github.com To: cakephp-datatable@noreply.github.com CC: khiemnd@hotmail.com Subject: Re: [cakephp-datatable] Error with cakephp 2.5.2 (#48)

Ok, can you get the request params as well?

On Wed, Jul 9, 2014 at 8:11 PM, khiemnd notifications@github.com wrote:

Hi,

I follow your readme file.

<?php echo $this->DataTable->render('Game', array('class'=>'table

table-bordered table-hover dataTable'),

array('sAjaxSource'=>$this->Html->url(array( 'controller' => 'games',

'action' => 'getGames', 'admin' => false, '?' => array('model'=>'Game')

)))); ?>

<?php echo $this->Html->scriptStart(array('inline'=>false));

?>$(document).ready(function(){$.extend( $.fn.dataTable.defaults, {

"bFilter": true, "bSort": false, "iDisplayLength": 3, "aLengthMenu": [[1,

2, 3, -1], [1, 2, 3, "All"]]} );});<?php echo $this->Html->scriptEnd(); ?>

Date: Wed, 9 Jul 2014 19:45:39 -0700

From: notifications@github.com

To: cakephp-datatable@noreply.github.com

CC: khiemnd@hotmail.com

Subject: Re: [cakephp-datatable] Error with cakephp 2.5.2 (#48)

How are you setting the limit?

On Jul 9, 2014 6:48 PM, "khiemnd" notifications@github.com wrote:

The first response:

{"iTotalRecords":4,"iTotalDisplayRecords":4,"sEcho":1,"aaData":[["1","\u0110ua

si\u00eau xe 2","2Fast2Furious","2014-06-04 02:12:40"],["2","Tr\u00f2

ch\u01a1i tr\u00fang th\u01b0\u1edfng 2in1","2-in-1 Award-Winning

Games","2014-06-04

02:25:29"],["3","2Fast2Furious","2Fast2Furious","2014-06-04 03:15:45"]]}

The second

response:{"iTotalRecords":4,"iTotalDisplayRecords":1,"sEcho":2,"aaData":[["4","2Fast2Furious","2Fast2Furious","2014-06-04

03:17:41"]]}

^^

Date: Wed, 9 Jul 2014 09:11:02 -0700

From: notifications@github.com

To: cakephp-datatable@noreply.github.com

CC: khiemnd@hotmail.com

Subject: Re: [cakephp-datatable] Error with cakephp 2.5.2 (#48)

Can you get me the response body of the first request and the second

request?

Reply to this email directly or view it on GitHub.

Reply to this email directly or view it on GitHub

<

https://github.com/tigrang/cakephp-datatable/issues/48#issuecomment-48556764

.

Reply to this email directly or view it on GitHub.

Reply to this email directly or view it on GitHub

https://github.com/tigrang/cakephp-datatable/issues/48#issuecomment-48560955

.

— Reply to this email directly or view it on GitHub.

tigrang commented 10 years ago

Can you try this for me (untested):

Comment line 170 in DataTableComponent.php and add this after line 165 (under $this->_search):

$totalDisplayed = $this->_object->find('count', $settings);
khiemnd-ait commented 10 years ago

Hi,

It's okie now, many thanks!

Sent from my iPhone

On 10 Jul 2014, at 12:47, "Tigran Gabrielyan" notifications@github.com wrote:

Can you try this for me (untested):

Comment line 170 in DataTableComponent.php and add this on after line 165 (under $this->_search):

$totalDisplayed = $this->_object->find('count', $settings); — Reply to this email directly or view it on GitHub.