View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|12218||Bug reports||Central participant database||public||2017-03-21 18:38||2021-08-31 08:40|
|Summary||12218: Error when selecting display 2500 rows per page|
|Description||After updating to the latest version (2.64.1+170310) every time someone selects 2500 or more from the rows per page drop down menu in the Central Participant Database we get this error message: (see attached image)|
I haven't been able to go back to the previous version because I don't see it posted anymore (https://www.limesurvey.org/downloads/category/24-archived-releases) They used to be listed in the old version of the page, but in this new version I can't find them.
I'm also getting the same error on the site that we use with GitHub.
Apparently LS is asking to increase the memory size. Currently we allocated 256MB. I thought the required was 128MBs.
|Additional Information||Our Central Participant Database has 1350 participants. When sending surveys out, the survey admins select 2500 in order to filter the participants by attributes. If filtering by attribute is done before loading all 1350 participants (by selecting the 2500 option) then the filtering is lost. Say, we filter by one attribute, we get 500 participants displayed across 50 pages (since the default is to show 10 per page) then we select to display 1000 participants per page, then the attribute that we filtered the participants is lost . . .|
|Tags||No tags attached.|
|Complete LimeSurvey version number (& build)||2.64.1+170310|
|I will donate to the project if issue is resolved|
|Database type & version|
|Server OS (if known)|
|Webserver software & version (if known)|
Error_debug.PNG (282,549 bytes)
|Hello. The issue is still happening. Any fixes? We allocated 512MB to the site and still we're getting that memory error.|
|If I remove all participants from the CPDB and re-add them, the issue seems to go away. However the values for the column "Active Surveys" are lost. Maybe the query that's loading that column is too heavy for the site? It does take about 1 minute to load the 1500 records that show up when we select to display 2500 rows per page.|
In the last comment, the issue seems to go away because all the records from the survey_links table are gone when you delete all the participants from the CPDB. Currently we have 144k+ records in said table.
Also checking the DB debug code, whenever you select how many records you want to display in the CPDB page, the following query is executed:
FROM survey_links cas
WHERE cas.participant_id = t.participant_id) AS countActiveSurveys,
t.participant_id, t.participant_id AS id
FROM `participants` `t`
LEFT JOIN participant_shares AS shares ON t.participant_id = shares.participant_id
AND (shares.share_uid = 1 OR shares.share_uid = -1)
ORDER BY t.lastname ASC LIMIT 100
The obvious outcome of the query is 100 records. I've been trying to find where in the code this query resides to get rid of the LIMIT 100 and display all the records. I think is in the /limesurvey/application/models/Participant.php file. but I haven't been able to find the code yet.
Is it possible to have this fixed?
This should already be fixed in recent versions.
Can you please check if this issue still exists in the latest version of LimeSurvey and let us know?
we have asked for feedback on this issue. Because we did not get an answer we assume that the issue is resolved.
However, should you be able to reproduce the issue using the latest version, please feel free to re-open the issue and give us exact details on how to reproduce it.
Thank you and best regards,
|2017-03-21 18:38||haubel||New Issue|
|2017-03-21 18:38||haubel||File Added: Error.PNG|
|2017-03-21 18:38||haubel||File Added: Error_debug.PNG|
|2017-03-21 18:49||DenisChenu||Relationship added||related to 11891|
|2017-07-24 23:27||haubel||Note Added: 44209|
|2017-07-25 22:01||haubel||Note Added: 44240|
|2017-07-28 18:47||haubel||Note Added: 44266|
|2021-03-07 21:29||c_schmitz||Project||Feature requests => Bug reports|
|2021-03-07 21:29||c_schmitz||Assigned To||=> c_schmitz|
|2021-03-07 21:29||c_schmitz||Status||new => feedback|
|2021-03-07 21:29||c_schmitz||Complete LimeSurvey version number (& build)||=> 2.64.1+170310|
|2021-03-07 21:29||c_schmitz||Note Added: 62828|
|2021-08-31 08:40||c_schmitz||Status||feedback => closed|
|2021-08-31 08:40||c_schmitz||Resolution||open => fixed|
|2021-08-31 08:40||c_schmitz||Note Added: 66204|