View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 0
IDProjectCategoryView StatusDate SubmittedLast Update
11310Bug reportsSurvey editingpublic2016-06-01 04:402016-06-01 09:04
Reporterradhwaw Assigned Toc_schmitz  
PrioritynoneSeveritycrash 
Status closedResolutionduplicate 
Product Version2.50.x 
Summary11310: List Questions Pagination Error/Break Cannot Display Question
Description

When we try to click a certain page (pagination) of the list questions in a survey, the application shows error and we cannot see list of questions in the 2nd, 3rd, 4th page and so on. The Error is as follows:
Error 500: <h1>PHP Error [500]</h1>
<p>CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'group_order'.</p>

Steps To Reproduce

1) Access to the survey setting page
2) Click List Questions
3) Try to click certain page, or next page, or last page on the list questions
4) Shows Error

Additional Information

On my survey, I have 54 Questions and 5 Groups (maybe that helps).

TagsNo tags attached.
Attached Files
error_pagination.png (88,727 bytes)   
error_pagination.png (88,727 bytes)   
Bug heat0
Complete LimeSurvey version number (& build)160529
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome
Database type & versionMS SQL Server
Server OS (if known)Windows 7
Webserver software & version (if known)Apache 2.2.21
PHP Version5.3.8

Relationships

Relationship GraphDependency Graph
duplicate of 11283 closedLouisGac pagination in Questions in this survey causes a SQL error (MSSQL) 

Users monitoring this issue

There are no users monitoring this issue.

Activities

Issue History

Date Modified Username Field Change
2016-06-01 04:40 radhwaw New Issue
2016-06-01 04:40 radhwaw File Added: error_pagination.png
2016-06-01 09:04 c_schmitz Relationship added duplicate of 11283
2016-06-01 09:04 c_schmitz Status new => closed
2016-06-01 09:04 c_schmitz Assigned To => c_schmitz
2016-06-01 09:04 c_schmitz Resolution open => duplicate
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing