View Issue Details

IDProjectCategoryView StatusLast Update
14996Bug reports[All Projects] Theme editorpublic2019-06-19 15:21
ReporterDenisChenu Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version3.17.x 
Target VersionFixed in Version 
Summary14996: MSSQL issue when try to move to 2nd page of theme list : The multi-part identifier "t.template_name" could not be bound.
Description

When move to 2nd page of theme list : receive a 500 error.
Seems because MSSQL error maybe [t].[template_name] = [template.name] ?

Steps To Reproduce

Find a MSSQL server
Add more than 10 theme
Try to move to 2nd page

TagsNo tags attached.
Complete LimeSurvey version number (& build)3.17.5 github
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database & DB-VersionMS SQL Server 2012
Server OS (if known)windows
Webserver software & version (if known)IIS
PHP VersionPHP7

Activities

DenisChenu

DenisChenu

2019-06-19 15:21

developer  

CDbException.html (45,593 bytes)
DenisChenu

DenisChenu

2019-06-19 15:21

developer   ~52463

Oh no …

ORDER BY t.template_name) as [__inner__] ORDER BY t.template_name DESC) as [__outer__] ORDER BY t.template_name ASC ????

Issue History

Date Modified Username Field Change
2019-06-19 15:21 DenisChenu New Issue
2019-06-19 15:21 DenisChenu File Added: CDbException.html
2019-06-19 15:21 DenisChenu Note Added: 52463