19426: Survey listing : multiple call of user table - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

19426	Bug reports	Database design	public	2024-02-15 15:25	2024-04-22 11:52

Reporter	DenisChenu	Assigned To	DenisChenu
Priority	none	Severity	minor
Status	closed	Resolution	fixed
Product Version	5.6.x

Summary	19426: Survey listing : multiple call of user table
Description	On /index.php?r=admin i have 43 time the same request `system.db.CDbCommand.query(SELECT * FROM`lime_users`t WHERE `t`.`uid`=1 LIMIT 1)`
Steps To Reproduce	Steps to reproduce Activate debugsql Show /index.php?r=surveyAdministration/listsurveys search user in sql log Expected result have less than 5 request Actual result 43 request 24 in index (29 survey activated ?) Near same in 5 and 6.
Tags	No tags attached.
Attached Files	Capture d’écran du 2024-02-15 15-20-11.png (128,837 bytes)

Bug heat	10
Complete LimeSurvey version number (& build)	6.4.6
I will donate to the project if issue is resolved	No
Browser	not relevant
Database type & version	mariadb
Server OS (if known)	not relevant
Webserver software & version (if known)	not relevant
PHP Version	not relevant

User List	JanE

DenisChenu 2024-02-15 16:40 developer ~79523	master : https://github.com/LimeSurvey/LimeSurvey/pull/3741

DenisChenu 2024-02-23 11:31 developer ~79606	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=36125

DenisChenu 2024-02-26 09:35 developer ~79623	For 5X

LimeBot 2024-02-26 13:49 administrator ~79636	Fixed in Release 6.4.9+240226

DenisChenu 2024-03-07 11:25 developer ~79752	5.X https://github.com/LimeSurvey/LimeSurvey/pull/3785

DenisChenu 2024-03-07 12:03 developer ~79753	18 survey in survey listing : avoid 35 call of system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1) (single user)

gabrieljenik 2024-04-02 21:24 manager ~79868	@lajosarpad I have already approved the 5x branch. Still, as the ticket is on you, please, go ahead and add your won review.

lajosarpad 2024-04-03 20:20 developer ~79871	Approved the PR

DenisChenu 2024-04-16 13:55 developer ~79930	Fix committed to 5.x branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=36270

DenisChenu 2024-04-16 13:55 developer ~79931	Fix committed to 5.x branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=36269

LimeBot 2024-04-22 11:52 administrator ~79959	Fixed in Release 5.6.60+240423

LimeSurvey: master 6dfaa3cf 2024-02-23 10:34:46 DenisChenu Committer: GitHub Details Diff	Fixed issue 19426: Survey listing : multiple call of same user (03741)	Affected Issues 19426
	mod - application/models/Survey.php	Diff File
	mod - application/models/SurveysGroupsettings.php	Diff File
LimeSurvey: 5.x 49b0ede6 2024-04-16 13:51:44 DenisChenu Committer: GitHub Details Diff	Fixed issue 19426: Survey listing - multiple call of same user (#3785)	Affected Issues 19426
	mod - application/models/Survey.php	Diff File
	mod - application/models/SurveysGroupsettings.php	Diff File
LimeSurvey: 5.x 49b0ede6 2024-04-16 13:51:44 DenisChenu Committer: GitHub Details Diff	Fixed issue 19426: Survey listing - multiple call of same user (#3785)	Affected Issues 19426
	mod - application/models/Survey.php	Diff File
	mod - application/models/SurveysGroupsettings.php	Diff File

Date Modified	Username	Field	Change
2024-02-15 15:25	DenisChenu	New Issue
2024-02-15 15:25	DenisChenu	File Added: Capture d’écran du 2024-02-15 15-20-11.png
2024-02-15 15:25	DenisChenu	Assigned To	=> DenisChenu
2024-02-15 15:25	DenisChenu	Status	new => assigned
2024-02-15 16:00	DenisChenu	Summary	18473: Survey listing : multiple call of user table => Survey listing : multiple call of user table
2024-02-15 16:40	DenisChenu	Assigned To	DenisChenu => c_schmitz
2024-02-15 16:40	DenisChenu	Status	assigned => ready for code review
2024-02-15 16:40	DenisChenu	Note Added: 79523
2024-02-15 16:40	DenisChenu	Bug heat	0 => 2
2024-02-15 16:44	DenisChenu	Relationship added	related to 19371
2024-02-23 10:35	c_schmitz	Status	ready for code review => resolved
2024-02-23 10:35	c_schmitz	Resolution	open => fixed
2024-02-23 11:31	DenisChenu	Changeset attached	=> LimeSurvey master 6dfaa3cf
2024-02-23 11:31	DenisChenu	Note Added: 79606
2024-02-23 11:31	DenisChenu	Assigned To	c_schmitz => DenisChenu
2024-02-26 09:35	DenisChenu	Status	resolved => assigned
2024-02-26 09:35	DenisChenu	Note Added: 79623
2024-02-26 13:49	LimeBot	Note Added: 79636
2024-02-26 13:49	LimeBot	Status	assigned => closed
2024-02-26 13:49	LimeBot	Bug heat	2 => 4
2024-03-07 11:25	DenisChenu	Status	closed => feedback
2024-03-07 11:25	DenisChenu	Resolution	fixed => reopened
2024-03-07 11:25	DenisChenu	Note Added: 79752
2024-03-07 11:25	DenisChenu	Status	feedback => ready for code review
2024-03-07 12:03	DenisChenu	Note Added: 79753
2024-03-07 12:03	DenisChenu	Assigned To	DenisChenu => c_schmitz
2024-03-07 12:05	DenisChenu	Assigned To	c_schmitz => lajosarpad
2024-03-23 11:18	JanE	Issue Monitored: JanE
2024-03-23 11:18	JanE	Bug heat	4 => 6
2024-04-02 21:24	gabrieljenik	Note Added: 79868
2024-04-02 21:24	gabrieljenik	Bug heat	6 => 8
2024-04-03 20:20	lajosarpad	Note Added: 79871
2024-04-03 20:20	lajosarpad	Bug heat	8 => 10
2024-04-16 13:52	tibor.pacalat	Assigned To	lajosarpad => DenisChenu
2024-04-16 13:52	tibor.pacalat	Status	ready for code review => resolved
2024-04-16 13:52	tibor.pacalat	Resolution	reopened => fixed
2024-04-16 13:55	DenisChenu	Changeset attached	=> LimeSurvey 5.x 49b0ede6
2024-04-16 13:55	DenisChenu	Changeset attached	=> LimeSurvey 5.x 49b0ede6
2024-04-16 13:55	DenisChenu	Note Added: 79930
2024-04-16 13:55	DenisChenu	Note Added: 79931
2024-04-22 11:52	LimeBot	Note Added: 79959
2024-04-22 11:52	LimeBot	Status	resolved => closed

View Issue Details

Steps to reproduce

Expected result

Actual result

Relationships

Users monitoring this issue

Activities

Related Changesets

Issue History