View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
08809Bug reportsSurvey takingpublic2014-03-04 21:352014-03-20 14:52
Reportermarkg Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.05+ 
Summary08809: Cannot View Questions
Description

When attempting to view a survey, either with the survey link, the green gear icon, or when actually taking a survey, questions are not viewable. We copied over our database from Limesurvey 1.92+ and then tied that into a new install of 2.05+. We are running Red Had Enterprise Linux and Microsoft SQL Server. The important thing to note is that surveys from our old version (1.92+) work properly and show us the questions, but surveys created in the new version do not show questions. We have tried looking at the survey logic pages, and all of those look fine. This gets reproduced even in the smallest surveys.

Steps To Reproduce

1) Create a survey
2) Add questions
3) Click the green gear "preview" button

Additional Information

I have attached two .lss files - the survey id of 459374 is a copy of a survey created in Limesurvey 1.92+ - this WORKS and displays questions properly. The other .lss file was created in 2.05+ and does not work correctly - questions do not show up.

TagsNo tags attached.
Attached Files
limesurvey_survey_764419.lss (12,690 bytes)
limesurvey_survey_459374.lss (46,453 bytes)
Bug heat6
Complete LimeSurvey version number (& build)140302
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionMicrosoft SQL Server 2008
Server OS (if known)Red Had Enterprise Linux
Webserver software & version (if known)Apache 2.2.15
PHP Version5.3.8
Git branch / Pull Request URL

Users monitoring this issue

markg

Activities

c_schmitz

c_schmitz

2014-03-05 09:01

administrator   ~29096

It looks like there is a space in group relevance which makes the entire group non-relevant. The underlying problem is that your FreeTDS returns spaces on empty fields because of a misconfiguration. You can fix this problem by forcing the FreeTDS protocol version to 7.0. See http://www.php.net/manual/de/ref.pdo-dblib.connection.php#112146
c_schmitz

c_schmitz

2014-03-17 13:14

administrator   ~29278

2.05+ Build 140317 released
markg

markg

2014-03-17 13:53

reporter   ~29289

I am using version 7.0 in freetds.conf. However, it still does not fix this issue. To fix it, we created the Lime database from scratch (instead of upgrading) with a Windows machine running Limesurvey. Then we did a clean unzip of the Lime code on our Linux server and pointed it at the Lime database created by the windows machine. The problem had to do with the way the database user is permissioned - it creates it correctly in Windows, but in Linux something goes wrong with the database permissions on the user. Also, the documentation doesn't say what permissions to give the Lime db user.

Thanks!
markg

markg

2014-03-17 15:11

reporter   ~29290

You just re closed it without answering my question. Reopening.
c_schmitz

c_schmitz

2014-03-17 15:12

administrator   ~29291

What question?
markg

markg

2014-03-17 15:13

reporter   ~29292

I am using version 7.0 in freetds.conf. However, it still does not fix this issue. To fix it, we created the Lime database from scratch (instead of upgrading) with a Windows machine running Limesurvey. Then we did a clean unzip of the Lime code on our Linux server and pointed it at the Lime database created by the windows machine. The problem had to do with the way the database user is permissioned - it creates it correctly in Windows, but in Linux something goes wrong with the database permissions on the user. Also, the documentation doesn't say what permissions to give the Lime db user.

Thanks!
c_schmitz

c_schmitz

2014-03-17 15:15

administrator   ~29293

I don't see any question. This is not a forum.
markg

markg

2014-03-17 15:16

reporter   ~29294

I'm reporting that the bug is still not fixed, despite me forcing FreeTDS to 7.0.
c_schmitz

c_schmitz

2014-03-17 15:20

administrator   ~29295

LimeSurvey does not create any database users so I don't see how is that a LimeSurvey issue.
c_schmitz

c_schmitz

2014-03-20 14:52

administrator   ~29464

2.05+ Build 140320 released

Issue History

Date Modified Username Field Change
2014-03-04 21:35 markg New Issue
2014-03-04 21:36 markg File Added: limesurvey_survey_764419.lss
2014-03-04 21:36 markg File Added: limesurvey_survey_459374.lss
2014-03-04 21:36 markg Issue Monitored: markg
2014-03-05 00:15 c_schmitz Priority immediate => normal
2014-03-05 07:42 c_schmitz Assigned To => c_schmitz
2014-03-05 07:42 c_schmitz Status new => assigned
2014-03-05 09:01 c_schmitz Note Added: 29096
2014-03-05 09:01 c_schmitz Status assigned => resolved
2014-03-05 09:01 c_schmitz Resolution open => no change required
2014-03-17 13:14 c_schmitz Note Added: 29278
2014-03-17 13:14 c_schmitz Status resolved => closed
2014-03-17 13:53 markg Note Added: 29289
2014-03-17 13:53 markg Status closed => feedback
2014-03-17 13:53 markg Resolution no change required => reopened
2014-03-17 15:06 c_schmitz Status feedback => closed
2014-03-17 15:06 c_schmitz Resolution reopened => fixed
2014-03-17 15:11 markg Note Added: 29290
2014-03-17 15:11 markg Status closed => feedback
2014-03-17 15:11 markg Resolution fixed => reopened
2014-03-17 15:12 c_schmitz Note Added: 29291
2014-03-17 15:13 markg Note Added: 29292
2014-03-17 15:13 markg Status feedback => assigned
2014-03-17 15:15 c_schmitz Note Added: 29293
2014-03-17 15:16 markg Note Added: 29294
2014-03-17 15:20 c_schmitz Note Added: 29295
2014-03-17 15:30 c_schmitz Status assigned => feedback
2014-03-17 17:26 c_schmitz Status feedback => resolved
2014-03-17 17:26 c_schmitz Resolution reopened => fixed
2014-03-20 14:52 c_schmitz Note Added: 29464
2014-03-20 14:52 c_schmitz Status resolved => closed
2021-09-08 16:41 guest Bug heat 4 => 6