Hello
CC is only displaying 2 records on the page.
I have sent 5 tests. They all arrive by email with attachments, and are in the database. But only 2 are shown on page.
Any thoughts?
Many thanks
jo
Hi jo,
No idea.
Do they all have different record ids?
Is there any WHERE filter set on the listing?
Is there a limit set on the number of records to be shown?
Do they all show up if you turn Debug on?
Bob
Hi Bob, yes, I turned debug on and they were all there. I've just turned it off, and they are still all there!
I don't know what that is about, but will mke a ponit of trying debug before posting next time.
Many thanks
jo
Actually Bob, it's gone again! Both with the debug on and off. Will recreate. It'll be something I did while tweaking.
thanks
Hi again. Just looking at the debug, on the bottms LIMIT 2..... I didn't set this! Can you advise where do I go to change this, if indeed that is the problem?
Array
(
[0] => SELECT `Extension`.`id` AS `Extension.id`, `Extension`.`name` AS `Extension.name` FROM `i528b_chronoengine_extensions` AS `Extension` WHERE `Extension`.`enabled` = '1' ORDER BY `Extension`.`ordering` ASC
[1] => SELECT `Group`.`id` AS `Group.id`, `Group`.`parent_id` AS `Group.parent_id`, `Group`.`lft` AS `Group.lft`, `Group`.`rgt` AS `Group.rgt`, `Group`.`title` AS `Group.title` FROM `i528b_usergroups` AS `Group` ORDER BY `Group`.`parent_id` ASC, `Group`.`lft`
[2] => DESCRIBE `i528b_chronoengine_connections`
[3] => DESCRIBE `i528b_chronoengine_connections`
[4] => 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 `i528b_chronoengine_connections` AS `Connection` WHERE `Connection`.`title` = 'scholarships' AND `Connection`.`published` = '1'
[5] => DESCRIBE `#_scholarships`
[6] => DESCRIBE `#_scholarships`
[7] => SELECT COUNT(*) AS `applications.count` FROM `#_scholarships` AS `applications`
[8] => SELECT `applications`.`id` AS `applications.id`, `applications`.`uniq_id` AS `applications.uniq_id`, `applications`.`user_id` AS `applications.user_id`, `applications`.`created` AS `applications.created`, `applications`.`modified` AS `applications.modified`, `applications`.`familyname` AS `applications.familyname`, `applications`.`givenname` AS `applications.givenname`, `applications`.`email` AS `applications.email`, `applications`.`phone` AS `applications.phone`, `applications`.`country` AS `applications.country`, `applications`.`address` AS `applications.address`, `applications`.`residency` AS `applications.residency`, `applications`.`commitment` AS `applications.commitment`, `applications`.`english` AS `applications.english`, `applications`.`recommendation` AS `applications.recommendation`, `applications`.`qualifications` AS `applications.qualifications`, `applications`.`button12` AS `applications.button12` FROM `#_scholarships` AS `applications` LIMIT 2
)
Many thanks
Jo
So, I found the Page limit field in Front Listing - Settings. It was empty.
To test it, I put a value of 10. So, 10 results show and the debug states LIMIT 10.
However, when I deleted it again, it is still showing 10, both listed and in the debug.
Please also note, at no time did I enter the value 2. And the Limt field was empty before I tested it with 10.
Many thanks for any help
Jo
Hi Jo,
I can only guess that something else is setting the limit. Do you have anything else on the page that might interfere? If you add &tmpl=component to the URL does the problem still occur?
Bob