View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
09877Bug reportsSurvey takingpublic2015-09-09 12:052015-09-30 11:01
Reporterriqcles Assigned ToDenisChenu  
PriorityhighSeverityblock 
Status closedResolutionfixed 
Product Version2.06+ 
Fixed in Version2.06+ 
Summary09877: Management of attributes of a deactivated and then reactivated survey - SQL error
Description

I get an error which I can not determine the origin.
Users have created questionnaires there are several months (V2.00, V2.05 and V2.06).
Adding attributes in the invitations were used for testing in the questions and prefill answers.

Once the questionnaire has been disabled then duplicated as a model for a new questionnaire.

The problem is in the re-creation of the invitation table, a SQL error occurs.

I added the survey.

I managed to break the deadlock by changing the content of .lss file:
I deleted the text that was in the tags that included the word "attributedescription" and "attributecaption".

I wanted to try on the limesurvey demo server, but automatic connection (prefilled login and password) does not.

In the screenshot 2, there is a integration with an empty field type caracter varying, 255 suspicious ...

Steps To Reproduce

import survey
see captures

TagsNo tags attached.
Attached Files
2015_09_07_Limesurvey_attributs_ko_1.png (14,283 bytes)   
2015_09_07_Limesurvey_attributs_ko_1.png (14,283 bytes)   
2015_09_07_Limesurvey_attributs_ko_2.png (20,478 bytes)   
2015_09_07_Limesurvey_attributs_ko_2.png (20,478 bytes)   
Pour_communaute_token_create_error.lss (17,945 bytes)
Bug heat6
Complete LimeSurvey version number (& build)Build 150831
I will donate to the project if issue is resolvedNo
BrowserFirefox 31
Database type & versionPostgreSQL 9.1
Server OS (if known)Centos 6.5
Webserver software & version (if known)Apache 2.2
PHP Version5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2015-09-10 10:22

developer   ~33084

This lss file is the first lss or not ?

Because attributedescriptions is really buggy after import.

If yes : please send the not updated lss file
DenisChenu

DenisChenu

2015-09-10 10:35

developer   ~33085

The lss file is buggy:
<attributedescriptions><![CDATA[{"":{"description":"\"attribute_1\":{\"description\":\"IDENTIFIANT\",\"mandatory\":\"Y\",\"show_register\":\"Y\",\"cpdbmap\":\"\"},\"attribute_2\":{\"description\":\"NOM_ETABLISSEMENT\",\"mandatory\":\"Y\",\"show_register\":\"Y\",\"cpdbmap\":\"\"},\"attribute_3\":{\"description\":\"COORDONNEES\",\"mandatory\":\"Y\",\"show_register\":\"Y\",\"cpdbmap\":\"\"},\"attribute_4\":{\"description\":\"MAIL\",\"mandatory\":\"Y\",\"show_register\":\"Y\",\"cpdbmap\":\"\"}}","mandatory":"N","show_register":"N","cpdbmap":""},"attribute_1":{"description":"attribute_1","mandatory":"N","show_register":"N","cpdbmap":""},"attribute_2":{"description":"attribute_2","mandatory":"N","show_register":"N","cpdbmap":""},"attribute_3":{"description":"attribute_3","mandatory":"N","show_register":"N","cpdbmap":""},"attribute_4":{"description":"attribute_4","mandatory":"N","show_register":"N","cpdbmap":""}}]]></attributedescriptions>

Need to know if it's own updated or not ?
DenisChenu

DenisChenu

2015-09-10 10:54

developer   ~33086

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=15881
DenisChenu

DenisChenu

2015-09-10 11:00

developer   ~33087

Fix committed to develop branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=15882
riqcles

riqcles

2015-09-10 14:57

reporter   ~33088

The lss file is the first.
DenisChenu

DenisChenu

2015-09-10 18:32

developer   ~33089

I copy an existing survey with attribute : No broken attributedescription ...

Surely a bug in an old version when import .... Close this one : actually it work.
c_schmitz

c_schmitz

2015-09-30 11:01

administrator   ~33225

Version 2.06+ Build 150930 released

Related Changesets

LimeSurvey: master 6a570df5

2015-09-10 08:54:21

DenisChenu

Details Diff 		Fixed issue 09877: Possible issue with activation of token with malformed attributedescriptions
Fixed issue : [security] Control CRSF when create token table		 Affected Issues
09877
mod - application/controllers/admin/tokens.php Diff File
mod - application/models/Survey.php Diff File
mod - application/models/Token.php Diff File
mod - application/views/admin/token/tokenwarning.php Diff File

LimeSurvey: develop c5d12acb

2015-09-10 09:00:02

DenisChenu

Details Diff 		Fixed issue 09877: Possible issue with activation of token with malformed attributedescriptions Affected Issues
09877
mod - application/models/Survey.php Diff File
mod - application/models/Token.php Diff File

Issue History

Date Modified Username Field Change
2015-09-09 12:05 riqcles New Issue
2015-09-09 12:05 riqcles File Added: 2015_09_07_Limesurvey_attributs_ko_1.png
2015-09-09 12:06 riqcles File Added: 2015_09_07_Limesurvey_attributs_ko_2.png
2015-09-09 12:06 riqcles File Added: Pour_communaute_token_create_error.lss
2015-09-09 16:23 DenisChenu Assigned To => DenisChenu
2015-09-09 16:23 DenisChenu Status new => confirmed
2015-09-10 10:22 DenisChenu Note Added: 33084
2015-09-10 10:35 DenisChenu Note Added: 33085
2015-09-10 10:35 DenisChenu Status confirmed => feedback
2015-09-10 10:54 DenisChenu Changeset attached => LimeSurvey master 6a570df5
2015-09-10 10:54 DenisChenu Note Added: 33086
2015-09-10 10:54 DenisChenu Resolution open => fixed
2015-09-10 11:00 DenisChenu Changeset attached => LimeSurvey develop c5d12acb
2015-09-10 11:00 DenisChenu Note Added: 33087
2015-09-10 14:57 riqcles Note Added: 33088
2015-09-10 14:57 riqcles Status feedback => assigned
2015-09-10 18:32 DenisChenu Note Added: 33089
2015-09-10 18:32 DenisChenu Status assigned => resolved
2015-09-10 18:32 DenisChenu Fixed in Version => 2.06+
2015-09-30 11:01 c_schmitz Note Added: 33225
2015-09-30 11:01 c_schmitz Status resolved => closed