View Issue Details

This bug affects 1 person(s).
 10
IDProjectCategoryView StatusLast Update
04347Bug reportsOtherpublic2010-05-21 19:05
Reporteruser8162Assigned Tomachaven  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.90b 
Summary04347: Survey Crash by usage of Array Dual Scale
Description

My Survey crashed ... "Unknown column 'q.lid' in 'where clause':SELECT q.qid FROM lime_labels l, lime_questions q WHERE l.lid = q.lid AND q.qid=5 AND l.language='de' AND q.language='de'..." by usage of Array Dual Scale!

best regards
ralf

Steps To Reproduce

for reproduction you can use my Export/Import File.

TagsNo tags attached.
Attached Files
Bug heat10
Complete LimeSurvey version number (& build)8708
I will donate to the project if issue is resolved
Browser
Database type & versionMySQL 5
Server OS (if known)Linux
Webserver software & version (if known)Apache2
PHP Version5.2.12

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2010-05-18 17:30

updater   ~11849

Can you attach the whole survey aswell?

user8187

2010-05-19 14:03

  ~11871

I get the same database error on a questions with a dual scale array. I also run 1.90b.

Mazi

Mazi

2010-05-19 14:17

updater   ~11872

Baardmeester, you are also invited to share your survey for testing :-)

user8187

2010-05-19 14:56

  ~11873

Hi Mazi, every survey with dual scale arrays gives this error. I will upload one for you, but I don't think the problem is the surveys(but I can be wrong). I tried to fix this problem myself. Since it is a database error I run the query in the mysql database and it produced the same error. Following on that I search the table questions for a field called lid, but only found qid. So I taught it maybe had been a typing error in the query of the code.

Since I'm not familiar with your code i searched through your code for queries with q.lid. The files qanda.php and lsrc.helper.php had queries with q.lid(and q.lid1) in the code. So I replaced q.lid(and q.lid1) for q.qid like in the database. Now I don't get the database error anymore. But now when I fill in the questions on a page with a dual scale array I get the following message.

'One or more mandatory questions have not been answered. You cannot proceed until these have been completed'

Maybe this is because I also chanced q.lid1 to q.qid, but if I don't replace it or chance it to q.qid1 it gives an database error on q.lid1/q.qid1.

user8187

2010-05-19 15:10

  ~11874

Last edited: 2010-05-19 15:18

Oke, I just uploaded a test survey. I used to test the problem, but now when I test it suddenly works with the test survey I uploaded. I don't get:

'One or more mandatory questions have not been answered. You cannot proceed until these have been completed'

anymore. On other surveys I still get it. I uploaded another test survey where I still get the error. Maybe the error has like you expected something to do with the surveys. It may have to do something with when I copy text to a question and I save it a bit of code gets posted in the database. When I later edit it I can remove it. For the working survey I just typed text and I think it didn't do this. I'm just guessing. You know your code better than me ;).

user8187

2010-05-19 15:55

  ~11876

That thing i said about copied text and typed text doesn't have anything to do with it. Because I made a new survey without copying text from word to try something and I got that message again.

user8162

2010-05-19 19:58

  ~11877

I have no clue ... it works fine with a less less structured survey; but here is my survey attached...

Do you added support for trible scale on limesurvey 1.9?

Thank you and best regards from Hamburg
Ralf E.

user8187

2010-05-20 11:19

  ~11886

The difference between the survey was that one working was optional and the one not working was mandatory. Logical of course with that kind of the error message. But why I get this error is a mystery to me. Setting the question to optional is my workaround now. The only concern I have is if this would give problems for the answers. I don't know if the variable of q.lid/qid that is read out is used in the query for submitting the answers? Also I got errors on some pages that read out data in the admin. That there isn't a lime_questions.lid collumn. So it may be that the field in the database table is wrong. I would like to hear Mazi's thoughts on this.

machaven

machaven

2010-05-20 12:15

reporter   ~11887

Fixed in SVN

lemeur

lemeur

2010-05-21 19:05

developer   ~11916

1.90 beta3 release

Issue History

Date Modified Username Field Change
2010-05-18 10:54 user8162 New Issue
2010-05-18 10:54 user8162 Status new => assigned
2010-05-18 10:54 user8162 Assigned To => user372
2010-05-18 10:54 user8162 File Added: limesurvey_question_5.lsq
2010-05-18 17:29 Mazi Assigned To user372 => Mazi
2010-05-18 17:30 Mazi Note Added: 11849
2010-05-18 17:30 Mazi Status assigned => feedback
2010-05-19 14:03 user8187 Note Added: 11871
2010-05-19 14:17 Mazi Note Added: 11872
2010-05-19 14:56 user8187 Note Added: 11873
2010-05-19 14:59 user8187 File Added: limesurvey_survey_35717.lss
2010-05-19 15:10 user8187 Note Added: 11874
2010-05-19 15:13 user8187 File Added: limesurvey_survey_29975.lss
2010-05-19 15:18 user8187 Note Edited: 11874
2010-05-19 15:55 user8187 Note Added: 11876
2010-05-19 19:58 user8162 Note Added: 11877
2010-05-19 19:58 user8162 Status feedback => assigned
2010-05-19 19:58 user8162 File Added: limesurvey_survey_22598.lss
2010-05-19 20:14 Mazi Assigned To Mazi => lemeur
2010-05-19 20:32 machaven Assigned To lemeur => machaven
2010-05-20 11:19 user8187 Note Added: 11886
2010-05-20 12:15 machaven Note Added: 11887
2010-05-20 12:15 machaven Status assigned => resolved
2010-05-20 12:15 machaven Resolution open => fixed
2010-05-21 19:05 lemeur Note Added: 11916
2010-05-21 19:05 lemeur Status resolved => closed