View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
06667Bug reportsAccessibilitypublic2012-10-08 14:512012-10-09 22:39
ReporterErik_Inn Assigned Toc_schmitz  
PriorityhighSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary06667: Users can not open/view survey via weblink or email invitation and can not use preview function
Description

When trying to preview a questionnaire or single question, the following error occurs:

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Column "lime_groups.group_order" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause

The same error occurs when users that have been invited by me (admin) click on the weblink in the invitation.

Steps To Reproduce

Option 1: Create a questionnaire and try to preview the questionnaire or one question of the questionnaire
Option 2: Create a questionnaire and send an email invitation. Ask the one you have invited to open the weblink in the invitation

Both of the above options result in the error described in the 'description' field

TagsNo tags attached.
Attached Files
Printscreen LimeSurvey bug 20121008.jpg (142,265 bytes)
Bug heat8
Complete LimeSurvey version number (& build)121006
I will donate to the project if issue is resolvedNo
BrowserMS Internet Explorer 9, Google Chrome 22.0.1229.79 m
Database type & versionMS SQL 2008
Server OS (if known)MS Windows Server 2008 service pack 2
Webserver software & version (if known)IIS 7
PHP Version5.3

Users monitoring this issue

reneneee

Activities

reneneee

reneneee

2012-10-08 20:35

reporter   ~21121

Last edited: 2012-10-08 20:36

I get exactly the same error as described above.

Limesurvey build number: 121006
Browser: FF15 and all others
Database & DB-Version: MySQL 5.1.63
Operating System (Server): Debian Squeeze (64bit)
Webserver software & version: Apache 2.0
PHP Version: 5.3.3

Error when following the above steps to reproduce: "Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2' at line 3"
chrismbb

chrismbb

2012-10-09 03:13

reporter   ~21122

I get this issue when clicking on the test link for a survey.
build: 121006
Browser Chrome, Firefox
Database: Microsoft SQL Server 2008 R2
Webserver software: IIS 7
PHP: 5.3.3

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Column "lime_groups.group_order" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.
reneneee

reneneee

2012-10-09 12:30

reporter   ~21123

I just researched a little further on this bug: The error only appears when someone different from the admin user is attempting to test the survey. The admin user can test the survey without problems.
chrismbb

chrismbb

2012-10-09 22:09

reporter   ~21137

For me the admin use cannot test the survey.
c_schmitz

c_schmitz

2012-10-09 22:39

administrator   ~21138

2.00+ Build 121009 released. Please update.

Issue History

Date Modified Username Field Change
2012-10-08 14:51 Erik_Inn New Issue
2012-10-08 14:51 Erik_Inn File Added: Printscreen LimeSurvey bug 20121008.jpg
2012-10-08 20:29 reneneee Issue Monitored: reneneee
2012-10-08 20:35 reneneee Note Added: 21121
2012-10-08 20:36 reneneee Note Edited: 21121
2012-10-09 03:13 chrismbb Note Added: 21122
2012-10-09 10:36 Mazi Assigned To => c_schmitz
2012-10-09 10:36 Mazi Status new => assigned
2012-10-09 10:36 Mazi Severity minor => partial_block
2012-10-09 12:30 reneneee Note Added: 21123
2012-10-09 22:09 chrismbb Note Added: 21137
2012-10-09 22:27 c_schmitz Status assigned => resolved
2012-10-09 22:27 c_schmitz Fixed in Version => 2.00+
2012-10-09 22:27 c_schmitz Resolution open => fixed
2012-10-09 22:39 c_schmitz Note Added: 21138
2012-10-09 22:39 c_schmitz Status resolved => closed
2021-08-05 14:17 guest Bug heat 6 => 8