View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
10110Bug reportsResponse browsingpublic2016-01-08 15:36
Reporterwingman123 Assigned Toollehar  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.50.x 
Fixed in Version2.50.x 
Summary10110: Lime2.5RC5 Unable to load "List Questions" view with Postgres as DB
Description

In Lime 2.5 RC5 I am unable to load the "listquestions" view of a survey with Postgres as the DB. Upon clicking the "List Questions" on the left menu bar in the admin interface, I receive the following error:

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """"
LINE 1: ...) WHERE t.sid='284337' AND t.language='en' AND parent_qid=""
^
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Thank you.

It appears to be related to double quotes being used instead of single, for the empty string parent_qid but I could be mistaken.

Additionally, I receive the same error upon saving a Question Group

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: zero-length delimited identifier at or near """"
LINE 1: ...nguage ) WHERE t.sid=0 AND t.language=NULL AND parent_qid=""
^
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.
Thank you.

However the Question group saves fine, its just the error pops up upon save.

Thanks

Steps To Reproduce
  • Install LimeSurvey 2.5RC5 or latest 2.5 commit f09c0ac selecting Postgres as the database
  • Create a Survey in admin view
  • Add a question group, hit the save button (error should appear)
  • Go back to survey view, there should now be a new group. Add a question to this group if you wish or not.
  • Click "List Questions" on the left side menu bar. (error should appear)
TagsNo tags attached.
Attached Files
Bug heat2
Complete LimeSurvey version number (& build)2.5RC5 or 2.5 branch f09c0ac
I will donate to the project if issue is resolvedNo
BrowserChrome, Firefox
Database type & versionPostgres 9.4.4
Server OS (if known)Mac OSX 10.11
Webserver software & version (if known)Apache/2.4.16
PHP VersionPHP 5.5.29

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2016-01-08 15:36

administrator   ~34203

Version 2.5RC6 released

Issue History

Date Modified Username Field Change
2015-12-10 21:03 wingman123 New Issue
2015-12-10 21:03 wingman123 File Added: Screen Shot 2015-12-10 at 2.47.33 PM.png
2015-12-11 12:36 DenisChenu Assigned To => LouisGac
2015-12-11 12:36 DenisChenu Status new => assigned
2015-12-11 12:36 DenisChenu Product Version 2.06+ => 2.5
2015-12-21 17:07 LouisGac Assigned To LouisGac => ollehar
2015-12-21 17:26 ollehar Status assigned => resolved
2015-12-21 17:26 ollehar Fixed in Version => 2.5
2015-12-21 17:26 ollehar Resolution open => fixed
2016-01-08 15:36 c_schmitz Note Added: 34203
2016-01-08 15:36 c_schmitz Status resolved => closed