Dependency Graph

Dependency Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

This bug affects 1 person(s).
 10
IDProjectCategoryView StatusLast Update
19426Bug reportsDatabase designpublic2024-04-16 13:55
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status resolvedResolutionfixed 
Product Version5.6.x 
Summary19426: 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 * FROMlime_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.

TagsNo tags attached.
Attached Files
Bug heat10
Complete LimeSurvey version number (& build)6.4.6
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmariadb
Server OS (if known)not relevant
Webserver software & version (if known)not relevant
PHP Versionnot relevant

Relationships

related to 19371 resolvedlajosarpad Survey list page extremely slow when having alot of surveys and inheritance is used for 'List publicly' 

Activities

DenisChenu

DenisChenu

2024-02-15 16:40

developer   ~79523

master : https://github.com/LimeSurvey/LimeSurvey/pull/3741

DenisChenu

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

DenisChenu

2024-02-26 09:35

developer   ~79623

For 5X

LimeBot

LimeBot

2024-02-26 13:49

administrator   ~79636

Fixed in Release 6.4.9+240226

DenisChenu

DenisChenu

2024-03-07 11:25

developer   ~79752

5.X https://github.com/LimeSurvey/LimeSurvey/pull/3785

DenisChenu

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

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

lajosarpad

2024-04-03 20:20

developer   ~79871

Approved the PR

DenisChenu

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

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

Related Changesets

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

Issue History

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