View Issue Details

IDProjectCategoryView StatusLast Update
14996Bug reports[All Projects] Theme editorpublic2020-03-06 00:52
ReporterDenisChenu Assigned Toc_schmitz  
Status closedResolutionfixed 
Product Version3.17.x 
Target VersionFixed in Version3.22.7 
Summary14996: MSSQL issue when try to move to 2nd page of theme list : The multi-part identifier "t.template_name" could not be bound.

When move to 2nd page of theme list : receive a 500 error.
Seems because MSSQL error maybe [t].[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




2019-06-19 15:21


CDbException.html (45,593 bytes)


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
2020-03-06 00:52 c_schmitz Assigned To => c_schmitz
2020-03-06 00:52 c_schmitz Status new => closed
2020-03-06 00:52 c_schmitz Resolution open => fixed
2020-03-06 00:52 c_schmitz Fixed in Version => 3.22.7