Forums

It appears that the page limit setting in CC5 does not do anything. Regardless of what I change it to I always get a max of 30 rows.
[attachment=0]pagelimit.JPG[/attachment]

Array
(
    [0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `wrdsw_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
    [1] => SELECT `Connection`.`id` AS `Connection.id`, `Connection`.`title` AS `Connection.title`, `Connection`.`params` AS `Connection.params`, `Connection`.`extras` AS `Connection.extras`, `Connection`.`published` AS `Connection.published` FROM `wrdsw_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'CCT_Tracker_Mentor' AND `Connection`.`published` = '1'
    [2] => DESCRIBE `wrdsw_cf_CCT_CCTRequirements`
    [3] => DESCRIBE `wrdsw_cf_CCT_CCTSubmissions`
    [4] => SELECT COUNT(`rq`.`req_id`) AS `rq.count` FROM `wrdsw_cf_CCT_CCTRequirements` AS `rq` LEFT JOIN `wrdsw_cf_CCT_CCTSubmissions` AS `s` ON `s`.`req_id` = `rq`.`req_id` AND `s`.`user_id` = 1107 WHERE `rq`.`classtype` = 'CCT-0' GROUP BY `rq`.`req_id`
    [5] => SELECT `rq`.`req_id` AS `rq.req_id`, `rq`.`item` AS `rq.item`, `rq`.`type` AS `rq.type`, `rq`.`duewk` AS `rq.duewk`, `rq`.`viewlink` AS `rq.viewlink`, `rq`.`submitlink` AS `rq.submitlink`, `rq`.`status` AS `rq.status`, `s`.`datesubmitted` AS `s.datesubmitted`, `s`.`sub_id` AS `s.sub_id`, `s`.`report` AS `s.report`, `s`.`itemsubmitted` AS `s.itemsubmitted` FROM `wrdsw_cf_CCT_CCTRequirements` AS `rq` LEFT JOIN `wrdsw_cf_CCT_CCTSubmissions` AS `s` ON `s`.`req_id` = `rq`.`req_id` AND `s`.`user_id` = 1107 
WHERE `rq`.`classtype` = 'CCT-0' GROUP BY `rq`.`req_id` ORDER BY `rq`.`duewk` ASC, `s`.`datesubmitted` DESC 
LIMIT 30
)

ok, correction, it is working. Even though I had cleared the CC cache and cleared the joomla cache, after a couple of hours and a fresh login the list displays all rows. sorry for the head fake.

Hi t3living,

There is IMHO a CC bug in that is stores some variables in the User session and offers no simple way to clear them. The validation count is probably oen of these so once the session had expired and you logged in again it was reset but not before.

Bob