View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
11258Bug reportsAccessibilitypublic2016-05-25 09:582016-06-02 19:35
Reporterdtosun Assigned ToLouisGac 
PriorityurgentSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.50.x 
Summary11258: Survey list search box does not work
Description

When i try to search survey in survey list page, there is error.

Steps To Reproduce

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'defaultlanguage.surveyls_title' in 'where clause'

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)160506
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL
Server OS (if known)CentOS
Webserver software & version (if known)-
PHP Version-

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2016-05-25 10:02

administrator   ~38837

Please update to the latest build and report if you still have the issue.
patrizi

patrizi

2016-05-31 11:12

reporter   ~39046

I've the same problem even with updated version of LimeSurvey (2.50+ Build 160529)

from page: /index.php?r=admin/survey/sa/listsurveys
searching a SID by Search Box the result is (for me change the column):

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'correct_relation_defaultlanguage.surveyls_title' in 'where clause'

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.
patrizi

patrizi

2016-05-31 11:16

reporter   ~39047

Really the problem occur searching anything if I've logged in as simple user (not admin).
c_schmitz

c_schmitz

2016-05-31 11:21

administrator   ~39048

I can reproduce.
LouisGac

LouisGac

2016-06-02 15:31

developer   ~39088

https://github.com/LimeSurvey/LimeSurvey/commit/c79fe57846c8b58dd93b3108d51f6a9a19b55b4c
c_schmitz

c_schmitz

2016-06-02 19:35

administrator   ~39098

Version 2.50 Build 150602 released

Issue History

Date Modified Username Field Change
2016-05-25 09:58 dtosun New Issue
2016-05-25 10:02 c_schmitz Note Added: 38837
2016-05-25 10:02 c_schmitz Assigned To => c_schmitz
2016-05-25 10:02 c_schmitz Status new => feedback
2016-05-31 11:12 patrizi Note Added: 39046
2016-05-31 11:16 patrizi Note Added: 39047
2016-05-31 11:20 c_schmitz Priority none => urgent
2016-05-31 11:21 c_schmitz Note Added: 39048
2016-05-31 11:21 c_schmitz Assigned To c_schmitz =>
2016-05-31 11:21 c_schmitz Status feedback => new
2016-06-02 15:31 LouisGac Note Added: 39088
2016-06-02 15:31 LouisGac Status new => resolved
2016-06-02 15:31 LouisGac Resolution open => fixed
2016-06-02 15:31 LouisGac Assigned To => LouisGac
2016-06-02 19:35 c_schmitz Note Added: 39098
2016-06-02 19:35 c_schmitz Status resolved => closed