View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04347 | Bug reports | Other | public | 2010-05-18 10:54 | 2010-05-21 19:05 |
Reporter | Assigned To | machaven | |||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.90b | ||||
Summary | 04347: 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 | ||||
Steps To Reproduce | for reproduction you can use my Export/Import File. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 10 | ||||
Complete LimeSurvey version number (& build) | 8708 | ||||
I will donate to the project if issue is resolved | |||||
Browser | |||||
Database type & version | MySQL 5 | ||||
Server OS (if known) | Linux | ||||
Webserver software & version (if known) | Apache2 | ||||
PHP Version | 5.2.12 | ||||
Can you attach the whole survey aswell? |
|
I get the same database error on a questions with a dual scale array. I also run 1.90b. |
|
Baardmeester, you are also invited to share your survey for testing :-) |
|
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. |
|
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 ;). |
|
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. |
|
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 |
|
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. |
|
Fixed in SVN |
|
1.90 beta3 release |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2010-05-18 10:54 |
|
New Issue | |
2010-05-18 10:54 |
|
Status | new => assigned |
2010-05-18 10:54 |
|
Assigned To | => user372 |
2010-05-18 10:54 |
|
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 |
|
Note Added: 11871 | |
2010-05-19 14:17 | Mazi | Note Added: 11872 | |
2010-05-19 14:56 |
|
Note Added: 11873 | |
2010-05-19 14:59 |
|
File Added: limesurvey_survey_35717.lss | |
2010-05-19 15:10 |
|
Note Added: 11874 | |
2010-05-19 15:13 |
|
File Added: limesurvey_survey_29975.lss | |
2010-05-19 15:18 |
|
Note Edited: 11874 | |
2010-05-19 15:55 |
|
Note Added: 11876 | |
2010-05-19 19:58 |
|
Note Added: 11877 | |
2010-05-19 19:58 |
|
Status | feedback => assigned |
2010-05-19 19:58 |
|
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 |
|
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 |