| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06318 | Bug reports | Expression Manager | public | 2012-07-11 16:58 | 2012-07-18 16:33 |
| Reporter | maan | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.92+ | ||||
| Fixed in Version | 1.92+ | ||||
| Summary | 06318: Validation the array question | ||||
| Description | I am trying to use em_sq_validation But even a very simple eq not working I downloaded the sample ls2_test_em_sq_validation sample for test and I am getting the same problem and here is the error : as you can see that the rest of the eq is not there original eq (sum(Test_A_1, Test_A_2, Test_A_3, Test_A_4, Test_A_5) <= 3) && | ||||
| Tags | No tags attached. | ||||
| Bug heat | 14 | ||||
| Complete LimeSurvey version number (& build) | 120704 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | mozilla , explorer , Safari | ||||
| Database type & version | Sql server 2008 | ||||
| Server OS (if known) | Windows 7 | ||||
| Webserver software & version (if known) | IIS7 | ||||
| PHP Version | 5.3.8 | ||||
 |
It is working fine for me with ./docs/demosurveys/ls2_test_em_sq_validation.lss using version 120711. Can you try version 120711? If it still doesn't work, please attach a copy of the actual survey you are using (if downloaded from the wiki, perhaps it got corrupted there). I'm attaching the survey that works for me. |
 |
Hi I did the following steps 1- install a fresh copy limesurvey version 120711 the result I got the same error I am using IIS7 with php version 5.3.8 and sql server 2008 R2 connection to it using mssqlnative driver what you think the problem is ? |
|
|
I still can't reproduce the problem. I'm using MySql, and don't have access to Sql Server. Perhaps the 'value' field is being truncated. In my lime_question_attributes table, the 'value' field is of type 'text'. In mssqlnative, it should be varchar(max). What is it in your database? Are you upgrading from a prior version, by any chance? Looks like database versions prior to 135 (which is pretty old) had a shorter varchar field for 'value'. |
|
|
hi no I am not upgrading (i am using a new database ) as you can see from the last attachments the value is stored correctly in the database plus when I am editing the question , It is there . the value truncated only when showing the logic file |
|
|
That's bizarre. Even if Test_A_3 is somehow being converted to using a Microsoft-specific underscore character, I still don't see why it would display that way. If I could reproduce the problem, I could debug it, but as it is, I'm at a loss. Does the survey run properly, or is it just a problem in Show Logic File? |
|
|
Unfortunately the problem is in both the the show logic file as well as the survey; it doesnt run well. Thanks for all your help. I really hope we sort this out. |
|
|
Can you try a fresh install using MySql to see if that makes a difference? |
|
|
Hi It is working with mysql . |
|
|
Carsten or Mazi - who can test / debug this on a SQL Server platform? |
|
|
Carsten has MS SQL installed, I only use MySQL. |
|
|
Any update ? |
 |
I can reproduce the issue on MSSQL, now let me find it :) |
|
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9014 |
|
|
Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9020 |
|
|
1.92+ version released. |
