View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
15733Bug reportsSurvey participants (Tokens)public2020-03-10 18:27
ReporterDenisChenu Assigned Tocdorin  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version3.21.5 
Summary15733: Survey administrator can receive invalid mail about error
Description

With specific survey settings and survey : Administrator can receive invalid error

Steps To Reproduce

Import included survey, check email :)
Check data already done
Launch TEST token survey

Additional Information

Need token persistance + allow reload + hidden equation question
Here : must check without the decimal ? Maybe set to NULL is an error ?

TagsNo tags attached.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build)3.21.5 githun
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmariadb
Server OS (if known)fedora/linux and debian/linx
Webserver software & version (if known)apache
PHP Versionphp7.3 and php7.0

Relationships

related to 15973 closedDenisChenu Invalid submitflaied received 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2020-01-17 11:52

developer   ~55343

Think this issue is major if you have a lot of user with email about error.

DenisChenu

DenisChenu

2020-01-17 16:07

developer   ~55364

Currently : there are no error show for user (AddWarning didn't work so good ;) . Only email was sent.
debug 2 or 0 : same things

DenisChenu

DenisChenu

2020-01-17 16:54

developer   ~55365

Checked : only an Equation

The reponse attributes are

    1 => array
    (
        'id' => '5'
        'token' => 'TEST'
        'submitdate' => '1980-01-01 00:00:00'
        'lastpage' => '1'
        'startlanguage' => 'en'
        'seed' => '867823954'
        '958824X1333X24056' => 'aaaa'
        '958824X1333X24061' => '1'
        '958824X1334X24057' => ''
    )

The value to update

    2 => array
    (
        'lastpage' => 1
        '958824X1333X24061' => '1'
    )
DenisChenu

DenisChenu

2020-01-17 16:57

developer   ~55366

Manually adding a broken column : debug set to 2 + debugsql

    (
        'lastpage' => 1
        '958824X1333X24061' => '1'
        'brokenattribute' => 'SQL broken'
    )

No error
SQL done :

system.db.CDbCommand.execute(UPDATE `lime_survey_958824` SET `lastpage`=:yp0, `958824X1333X24061`=:yp1 WHERE `lime_survey_958824`.`id`=5. Bound with :yp0=1, :yp1='1')
DenisChenu

DenisChenu

2020-01-17 17:15

developer   ~55367

https://github.com/LimeSurvey/LimeSurvey/pull/1371

This fix the issue … but … i like to be sure it's due to PDO system :)

ollehar

ollehar

2020-01-20 15:08

administrator   ~55385

Launch TEST token survey

What to do after this?

DenisChenu

DenisChenu

2020-01-20 15:11

developer   ~55386

You didn't receive an email ?
If not : update email adress

PS : for checking : i add a tracevar('bad submit') in expression manager https://github.com/LimeSurvey/LimeSurvey/pull/1371/files#diff-796aba4d06254b9caea9d461e4ea80c9L5585

DenisChenu

DenisChenu

2020-01-20 15:16

developer   ~55387

An error occurred saving a response to survey id Check admin warning - 434875

DATA TO BE ENTERED:
token: TEST
434875X1348X24275: aaaa
434875X1348X24277: 1
434875X1349X24276: 
434875X1348X24275: aaaa
434875X1348X24277: 1
434875X1349X24276: 

SQL CODE THAT FAILED:
Error on response update
lime_release_bot

lime_release_bot

2020-01-27 10:12

administrator   ~55473

Fixed in Release 3.21.6+200121

Issue History

Date Modified Username Field Change
2020-01-17 11:51 DenisChenu New Issue
2020-01-17 11:51 DenisChenu File Added: survey_archive_BadEmailWarning.lsa
2020-01-17 11:51 DenisChenu Assigned To => cdorin
2020-01-17 11:51 DenisChenu Status new => assigned
2020-01-17 11:52 DenisChenu Note Added: 55343
2020-01-17 16:07 DenisChenu Note Added: 55364
2020-01-17 16:54 DenisChenu Note Added: 55365
2020-01-17 16:57 DenisChenu File Added: Capture d’écran du 2020-01-17 16-57-35.png
2020-01-17 16:57 DenisChenu Note Added: 55366
2020-01-17 17:15 DenisChenu Note Added: 55367
2020-01-20 15:08 ollehar Note Added: 55385
2020-01-20 15:11 DenisChenu Note Added: 55386
2020-01-20 15:16 DenisChenu Note Added: 55387
2020-01-27 10:12 lime_release_bot Note Added: 55473
2020-01-27 10:12 lime_release_bot Status assigned => closed
2020-01-27 10:12 lime_release_bot Resolution open => fixed
2020-03-10 18:27 DenisChenu Relationship added related to 15973