View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
03973Bug reportsStatisticspublic2009-12-11 12:16
ReporterMazi Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.87RC4 
Fixed in Version1.87RC5 
Summary03973: MS SQL fails when watching statistics (sample survey)
Description

When using the attached sample survey, chosing admin statistics with settings include=all records, "show summary of al available fields"=yes, "show graphs"=no the script breaks showing error message:
SELECT count(*) FROM [lime_survey_29846] WHERE [29846X31X3151_SPD] IS NULL OR [29846X31X3151_SPD] = '' OR [29846X31X3151_SPD] = ' '
[Microsoft][ODBC SQL Server Driver][SQL Server]Die Datentypen text und varchar sind im equal to-Operator inkompatibel.

TagsNo tags attached.
Attached Files
stats_sample_survey.csv (14,973 bytes)   
# LimeSurvey Survey Dump
# DBVersion 141
# This is a dumped survey from the LimeSurvey Script
# http://www.limesurvey.org/
# Do not change this header!

#
# SURVEYS TABLE
#
"sid","owner_id","admin","active","startdate","expires","adminemail","private","faxto","format","template","language","additional_languages","datestamp","usecookie","notification","allowregister","allowsave","autonumber_start","autoredirect","allowprev","printanswers","ipaddr","refurl","datecreated","listpublic","publicstatistics","publicgraphs","htmlemail","tokenanswerspersistence","assessments","usecaptcha","usetokens","bounce_email","attributedescriptions","emailresponseto","tokenlength"
"29846","1","Administratorname","Y","","","admin@localhost","Y","000-00000000","G","default","en","","Y","N","0","N","Y","4","N","Y","Y","N","N","2008-04-21 00:00:00.000","N","N","N","N","N","Y","N","N","admin@localhost","","","15"

#
# GROUPS TABLE
#
"gid","sid","group_name","group_order","description","language"
"31","29846","Array Questions","0","This is a group with the different array questions.","en"
"32","29846","Text Questions","4","","en"
"33","29846","Mask Questions","1","This is the group description.","en"
"34","29846","Single Choice Questions","3","","en"
"35","29846","Multiple Choice Questions","2","This group consist only of Multiple Choice questions.","en"

#
# QUESTIONS TABLE
#
"qid","sid","gid","type","title","question","preg","help","other","mandatory","lid","lid1","question_order","language"
"307","29846","31","A","A","Type A - Array 5 Point Choice Question","","","N","N","0","0","0","en"
"308","29846","31","B","B","Type B - Array 10 point choice Question","","This is the help text for this question. ","N","N","0","0","1","en"
"309","29846","31","C","C","Type C - Array Yes/No/Uncertain Question","","","N","N","0","0","2","en"
"310","29846","31","E","E","Type E - Array Increase/Same/Decrease Question","","This is the questions help text.","N","N","0","0","3","en"
"311","29846","31","F","F","Type F - Array using Flexible Labels question","","This is a array using a flexible label set. Flexible labels sets can be created with as many answer as you like to. We created only one for this survey that will be re-used over and over.","N","N","12","0","4","en"
"312","29846","31","H","H","Type H - Array Flexible Labels by Column question","","This is the same question type as before just the orientation has changed","N","N","12","0","6","en"
"313","29846","31","F","Semantic","Semantic Differential Question Type<br />","","This question type is a modification of Array (flexible labels).<br />","N","N","13","0","7","en"
"314","29846","31","1","DualScale","Array (Flexible Labels) dual scale (radio)<br />","","","N","N","14","14","8","en"
"315","29846","31",":",":","Array (Multi Flexi) (Numbers) - Allows a table of dropdowns containing number selections set by question attributes.<br />","","","N","N","15","0","10","en"
"316","29846","31",";",";","Array (Multi Flexi) (Text) - Allows a table of text inputs<br />","","","N","N","15","0","11","en"
"317","29846","31","1","DualScale","Array (Flexible Labels) dual scale (dropdown)<br />","","","N","N","14","14","9","en"
"318","29846","31",":",":","Array (Multi Flexi) (Numbers - checkbox) - Allows a table of dropdowns containing number selections set by question attributes.<br />","","","N","N","15","0","12","en"
"319","29846","31","F","F","Type F - Array using Flexible Labels question (answerwidth = 50)<br />","","This is a array using a flexible label set. Flexible labels sets can be created with as many answer as you like to. We created only one for this survey that will be re-used over and over.","N","N","12","0","5","en"
"320","29846","32","Q","Q","Type Q - Multiple Short Text Question","","This is a Multiple Short Text Question","N","N","0","0","0","en"
"321","29846","32","T","T","Type T - Long Text Question?","","Helptext","N","N","0","0","4","en"
"322","29846","32","S","S","Type S - Short Free Text?","","helptext","N","N","0","0","3","en"
"323","29846","32","U","U","Type U - Huge Free text?","","Helptext","N","N","0","0","5","en"
"324","29846","32","Q","Q","Type Q - Multiple Short Text Question (with suffix and prefix)<br />","","This is a Multiple Short Text Question","N","N","0","0","1","en"
"325","29846","32","Q","Q","Type Q - Multiple Short Text Question (long &quot;answers&quot;)<br />","","This is a Multiple Short Text Question","N","N","0","0","2","en"
"326","29846","33","X","X","Type X - Boilerplate question","","This is the boilerplate question type. It's not so much a question but a simple text display.","N","Y","0","0","9","en"
"327","29846","33","G","G","Type G - Gender question?","","This is a standard question aksing for the participiant's sex.","N","N","0","0","2","en"
"328","29846","33","N","N","Type N - Numerical Input Question","","","N","Y","0","0","3","en"
"329","29846","33","R","R","Type R - Ranking Question","","","N","N","0","0","8","en"
"330","29846","33","Y","Y","Type Y - Yes/No Question","","","N","N","0","0","10","en"
"331","29846","33","D","D","Type D - Date question?","","Helptext","N","N","0","0","0","en"
"332","29846","33","K","K","Multiple Numerical Input<br />","","","N","N","0","0","4","en"
"333","29846","33","K","K","Multiple Numerical Input (slider layout)<br />","","You can slide the button along.<br />","N","Y","0","0","7","en"
"334","29846","33","D","D","Type D - Date question? (dropdown dates)<br />","","Helptext","N","N","0","0","1","en"
"335","29846","33","K","K","Multiple Numerical Input (equals 10)<br />","","add numbers to the boxes above<br />","N","N","0","0","6","en"
"336","29846","33","K","K","Multiple Numerical Input (with prefix and suffix)<br />","","","N","N","0","0","5","en"
"337","29846","34","Z","Z","Type Z - List Flexible Labels (Radio)","","This question is reusing the same label set as some of the array questions.","N","N","12","0","5","en"
"338","29846","34","W","W","Type W - List Flexible Labels Dropdown question type","","This question is reusing the same label set as some of the array questions.","N","N","12","0","4","en"
"339","29846","34","O","O","Type O - List with Comment Question","","","N","N","0","0","3","en"
"340","29846","34","L","L","Type L - List Radio qeustion","","","Y","N","0","0","2","en"
"341","29846","34","5","5","Type 5 - 5 point choice","","Help2","N","N","0","0","1","en"
"342","29846","34","!","!","Type ! - List Dropdown Question","","","Y","N","0","0","0","en"
"343","29846","35","P","P","Type P - Multiple Options Question with Comments ","","This is a Multiple Options Question with the ability to comment it.","Y","N","0","0","1","en"
"344","29846","35","M","M","Type M - Multiple Options Question","","This is a type M multiple Options questions.","Y","N","0","0","0","en"

#
# ANSWERS TABLE
#
"qid","code","answer","default_value","sortorder","assessment_value","language"
"307","A1","FBI","N","0","0","en"
"307","A2","CIA","N","1","0","en"
"307","A3","G5","N","2","0","en"
"307","A4","NASA","N","3","0","en"
"308","B1","Darth Vader","N","0","0","en"
"308","B2","Luke Skywalker","N","1","0","en"
"308","B3","Princess Leia","N","2","0","en"
"308","B4","Jabba the Hut","N","3","0","en"
"309","C1","I am blonde","N","0","0","en"
"309","C2","I am blue","N","1","0","en"
"309","C3","I am pissed","N","2","0","en"
"309","C4","I am drunk","N","3","0","en"
"310","E1","Pain","N","0","0","en"
"310","E2","Pleasure","N","1","0","en"
"310","E3","Luck","N","2","0","en"
"310","E4","Happiness","N","3","0","en"
"311","F1","Deannan Troi","N","0","0","en"
"311","F2","Wesley Crusher","N","1","0","en"
"311","F3","Jean-Luc Picard","N","2","0","en"
"311","F4","Seven of  Nine","N","3","0","en"
"312","H1","Deannan Troi","N","0","0","en"
"312","H2","Wesley Crusher","N","1","0","en"
"312","H3","Data","N","2","0","en"
"312","H4","Jean-Luc Picard","N","3","0","en"
"313","1","sweet|bitter","N","1","1","en"
"313","2","fair|unfair","N","2","2","en"
"313","3","warm|cold","N","3","3","en"
"313","4","beautiful|ugly","N","4","4","en"
"313","5","meaningful|meaningless","N","5","5","en"
"313","6","bright|dark","N","6","6","en"
"314","1","television program","N","1","1","en"
"314","2","radio program","N","2","2","en"
"314","3","cinema program","N","3","3","en"
"315","1","Google","N","1","1","en"
"315","2","Yahoo","N","2","2","en"
"315","3","Microsoft Search","N","3","3","en"
"316","1","Google","N","1","1","en"
"316","2","Yahoo","N","2","2","en"
"316","3","Microsoft Search","N","3","3","en"
"317","1","television program","N","1","1","en"
"317","2","radio program","N","2","2","en"
"317","3","cinema program","N","3","3","en"
"318","1","Google","N","1","1","en"
"318","2","Yahoo","N","2","2","en"
"318","3","Microsoft Search","N","3","3","en"
"319","F1","Deannan Troi","N","0","0","en"
"319","F2","Wesley Crusher","N","1","0","en"
"319","F3","Jean-Luc Picard","N","2","0","en"
"319","F4","Seven of  Nine","N","3","0","en"
"320","Q1","blue","N","0","0","en"
"320","Q2","red","N","1","0","en"
"320","Q3","green","N","2","0","en"
"324","Q1","blue","N","0","0","en"
"324","Q2","red","N","1","0","en"
"324","Q3","green","N","2","0","en"
"325","Q1","blue is the colour of the sky. the sky is very high. the sky is also very big","N","0","0","en"
"325","Q2","red is the colour of blood. blood is very useful. blood is a very nice color","N","1","0","en"
"325","Q3","green is the color of trees. I like trees. I especially like climbing them with a rope and harness.","N","2","0","en"
"329","R1","Red","N","0","0","en"
"329","R2","Green","N","1","0","en"
"329","R3","Blue","N","2","0","en"
"332","1","Apples","N","1","1","en"
"332","2","Oranges","N","2","2","en"
"332","3","Bananas","N","3","3","en"
"333","1","Apples","N","1","1","en"
"333","2","Oranges","N","2","2","en"
"333","3","Bananas","N","3","3","en"
"335","1","Apples","N","1","1","en"
"335","2","Oranges","N","2","2","en"
"335","3","Bananas","N","3","3","en"
"336","1","Apples","N","1","1","en"
"336","2","Oranges","N","2","2","en"
"336","3","Bananas","N","3","3","en"
"339","O1","Red","N","0","0","en"
"339","O2","Green","N","1","0","en"
"339","O3","Blue","N","2","0","en"
"340","L1"," Green","N","0","0","en"
"340","L2","Red","N","1","0","en"
"340","L3","Blue","N","2","0","en"
"342","EC1","Green","N","0","0","en"
"342","EC2","Red","N","1","0","en"
"342","EC3","Blue","N","2","0","en"
"343","P1","I am glad","N","0","0","en"
"343","P2","I don't care","N","1","0","en"
"343","P3","I am unhappy","N","2","0","en"
"344","M1","Yes","N","0","0","en"
"344","M2","No","N","1","0","en"
"344","M3","Maybe","N","2","0","en"

#
# CONDITIONS TABLE
#
"cid","qid","scenario","cqid","cfieldname","method","value"
"201","328","1","327","29846X33X327","==","M"

#
# LABELSETS TABLE
#
"lid","label_name","languages"
"12","Test Labelset","en"
"13","-2_to_+2","en"
"14","1_to_5","en"
"15","Search Engine Criteria","en"

#
# LABELS TABLE
#
"lid","code","title","sortorder","language","assessment_value"
"12","TL1","6 - Like it very much","0","en","0"
"12","TL2","5","1","en","0"
"12","TL3","4","2","en","0"
"12","TL4","3","3","en","0"
"12","TL5","2","4","en","0"
"12","TL6","1 - Dont like it at all","5","en","0"
"13","1","-2","1","en","1"
"13","2","-1","2","en","2"
"13","3","0","3","en","3"
"13","4","1","4","en","4"
"13","5","2","5","en","5"
"14","1","1","1","en","1"
"14","2","2","2","en","2"
"14","3","3","3","en","3"
"14","4","4","4","en","4"
"14","5","5","5","en","5"
"15","SPD","Speed","1","en","0"
"15","DSN","Design","2","en","0"
"15","ACC","Accuracy","3","en","0"

#
# QUESTION_ATTRIBUTES TABLE
#
"qaid","qid","attribute","value"
"231","314","answer_width","50"
"232","314","dualscale_headerA","satisfaction"
"233","314","dualscale_headerB","importance"
"234","315","multiflexible_max","20"
"235","315","multiflexible_step","2"
"236","315","multiflexible_min","10"
"237","317","answer_width","50"
"238","333","equals_num_value","10"
"239","333","slider_layout","1"
"240","334","dropdown_dates","1"
"241","335","equals_num_value","10"
"242","317","dualscale_headerA","satisfaction"
"243","317","dualscale_headerB","importance"
"244","317","use_dropdown","true"
"245","318","multiflexible_max","20"
"246","318","multiflexible_step","2"
"247","318","multiflexible_min","10"
"248","318","multiflexible_checkbox","1"
"249","319","answer_width","50"
"250","336","prefix","prefix"
"251","324","suffix","suffix"
"252","324","prefix","prefix"
"253","336","suffix","suffix"

#
# ASSESSMENTS TABLE
#

#
# SURVEYS_LANGUAGESETTINGS TABLE
#
"surveyls_survey_id","surveyls_language","surveyls_title","surveyls_description","surveyls_welcometext","surveyls_endtext","surveyls_url","surveyls_urldescription","surveyls_email_invite_subj","surveyls_email_invite","surveyls_email_remind_subj","surveyls_email_remind","surveyls_email_register_subj","surveyls_email_register","surveyls_email_confirm_subj","surveyls_email_confirm","surveyls_dateformat"
"29846","en","Sample Survey for v1.8 (all questions plus most options)","This is a sample survey showing all the question types you can use in LimeSurvey version 1.80.<br />\nIt also shows some of the options available for each question.<br />","This is the welcome text for the survey!<br />\nYou can can edit it in the survey properties.","","","","Invitation to participate in survey","Dear {FIRSTNAME},\n\nYou have been invited to participate in a survey.\n\nThe survey is titled:\n&quot;{SURVEYNAME}&quot;\n\n&quot;{SURVEYDESCRIPTION}&quot;\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}","Reminder to participate in survey","Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n&quot;{SURVEYNAME}&quot;\n\n&quot;{SURVEYDESCRIPTION}&quot;\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}","Survey Registration Confirmation","Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.","Confirmation of completed survey","Dear {FIRSTNAME},\n\nThis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}","1"

#
# QUOTA TABLE
#

#
# QUOTA_MEMBERS TABLE
#

#
# QUOTA_LANGUAGESETTINGS TABLE
#

stats_sample_survey.csv (14,973 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)8088
I will donate to the project if issue is resolved
BrowserFirefox 3
Database type & versionMS SQL Server 2005
Server OS (if known)Win XP Sp 3
Webserver software & version (if known)Apache 2.2
PHP Version5.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2009-12-11 11:39

administrator   ~10539

Fixed in rev. 8412

It would be great if you can pin it down to a certain question type next time.

Issue History

Date Modified Username Field Change
2009-12-08 19:03 Mazi New Issue
2009-12-08 19:03 Mazi Status new => assigned
2009-12-08 19:03 Mazi Assigned To => user372
2009-12-08 19:03 Mazi File Added: stats_sample_survey.csv
2009-12-08 19:03 Mazi LimeSurvey build number => 8088
2009-12-08 19:03 Mazi Browser => Firefox 3
2009-12-08 19:03 Mazi Database & DB-Version => MS SQL Server 2005
2009-12-08 19:03 Mazi Operating System (Server) => Win XP Sp 3
2009-12-08 19:03 Mazi Webserver => Apache 2.2
2009-12-08 19:03 Mazi PHP Version => 5.2
2009-12-09 06:43 user372 Assigned To user372 => c_schmitz
2009-12-11 11:39 c_schmitz Note Added: 10539
2009-12-11 11:39 c_schmitz Status assigned => resolved
2009-12-11 11:39 c_schmitz Fixed in Version => 1.87RC5
2009-12-11 11:39 c_schmitz Resolution open => fixed
2009-12-11 12:16 c_schmitz Status resolved => closed