Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Display responses - empty

  • d90
  • d90's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 6 months ago - 8 years 6 months ago #124001 by d90
Display responses - empty was created by d90
I have created a few surveys and verified the answers are in the survey db. When I go to 'Display Responses' the view there is blank. I'm assuming its just a sql query of the table here, so for good measure I can confirm I'm able to list and view token entries just fine.

I'm using MS SQL Server 2008r2,
limesurvey 2.06+ on ubuntu server.
Apache/2.4.7 (Ubuntu)
PHP 5.5.9-1ubuntu4.11 (cli)
Last edit: 8 years 6 months ago by d90.
The topic has been locked.
More
8 years 6 months ago #124011 by rola
Replied by rola on topic Display responses - empty
it could be a database collation issue .

there might be a collation conflict between the token column in tokens table and the one in responses table.
The topic has been locked.
  • d90
  • d90's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 6 months ago #124034 by d90
Replied by d90 on topic Display responses - empty
Do you have any info on how to diagnose and resolve it?
The topic has been locked.
  • d90
  • d90's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 6 months ago #124102 by d90
Replied by d90 on topic Display responses - empty
I went ahead and right clicked each nvarchar column and looked at the properties. I then manually changed the token column's collation in the tokens table to match all the others.
The topic has been locked.
More
8 years 6 months ago #124104 by jelo
Replied by jelo on topic Display responses - empty
And the result? Fixed or not fixed?

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
  • d90
  • d90's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 6 months ago #124105 by d90
Replied by d90 on topic Display responses - empty
Sorry, yes it is fixed now.
The topic has been locked.
More
8 years 6 months ago #124649 by rola
Replied by rola on topic Display responses - empty
just to confirm ....

can you please tell which collation you are using for your database ??

do you face same issue with each survey you create ??
The topic has been locked.
  • d90
  • d90's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
8 years 6 months ago #124765 by d90
Replied by d90 on topic Display responses - empty
sorry for the late response. American holiday weekend.
My db uses SQL_Latin1_General_CP1_CI_AS collation
The issue does in fact manifest on all surveys. It seems the survey token table, token column collation defaults to SQL_Latin1_General_CP1_CS_AS causing the mismatch. All other nvarchar columns have the correct collation.
The topic has been locked.
More
8 years 6 months ago #124824 by rola
Replied by rola on topic Display responses - empty
Exactly same issue .... I am using 2.6+ build 150629, SQL server 2012
I am not sure if this problem has been resolved in a later release
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose