View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
09724Bug reportsSurvey participants (Tokens)public2015-06-29 10:012015-06-29 11:11
ReporterWheuk Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.06+ 
Fixed in Version2.06+ 
Summary09724: Upgrade to 2.06+ removes email from tokens
Description

Upgraded my limesurvey installation according to https://manual.limesurvey.org/Upgrading_from_a_previous_version#The_quick_way_.28for_minor_version_changes.29 from 2.05+ (Build 140911) to 2.06+ (Build 150625). The database upgrade reported no errors.
However I could not send reminders any more and it turned out that all email adresses from the limetokens* tables where lost during the upgrade.

Additional Information

From the backup (replaced private data by XXX to protect the innocent):

INSERT INTO lime_tokens_477587 VALUES (2,NULL,'XXX','XXX','XXX@web.de','OK','XXX','de',NULL,'2012-12-16 14:43','N',0,'2012-12-16 18:47',0,NULL,NULL,NULL) ...

After upgrade:

echo "select * from lime_tokens_477587 where tid=2;" | mysql -B

Enter password:
tid participant_id firstname lastname email emailstatus token language blacklisted sent remindersent remindercount completed usesleft validfrom validuntil mpid
2 NULL XXX XXX OK XXX de NULL 2012-12-16 14:43 N 0 2012-12-16 18:47 0 NULL NULL NULL

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)150625
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL 5.5.43
Server OS (if known)Debian jessie
Webserver software & version (if known)Apache 2.4.10 with mod_fcgid
PHP Version5.6.9

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2015-06-29 10:16

administrator   ~32539

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=15520
c_schmitz

c_schmitz

2015-06-29 10:18

administrator   ~32540

Fix committed to develop branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=15521
c_schmitz

c_schmitz

2015-06-29 10:19

administrator   ~32541

Good catch - thank you!
c_schmitz

c_schmitz

2015-06-29 11:11

administrator   ~32542

Version 2.06+ Build 150629 released.

Related Changesets

LimeSurvey: master b191c6bd

2015-06-29 08:16:39

c_schmitz

Details Diff 		Fixed issue 09724: Lost token emails on upgrade Affected Issues
09724
mod - application/helpers/update/updatedb_helper.php Diff File

LimeSurvey: develop 162255ec

2015-06-29 08:18:23

c_schmitz

Details Diff 		Fixed issue 09724: Lost token emails on upgrade Affected Issues
09724
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2015-06-29 10:01 Wheuk New Issue
2015-06-29 10:16 c_schmitz Assigned To => c_schmitz
2015-06-29 10:16 c_schmitz Status new => assigned
2015-06-29 10:16 c_schmitz Changeset attached => LimeSurvey master b191c6bd
2015-06-29 10:16 c_schmitz Note Added: 32539
2015-06-29 10:16 c_schmitz Resolution open => fixed
2015-06-29 10:18 c_schmitz Changeset attached => LimeSurvey develop 162255ec
2015-06-29 10:18 c_schmitz Note Added: 32540
2015-06-29 10:18 c_schmitz Status assigned => resolved
2015-06-29 10:18 c_schmitz Fixed in Version => 2.06+
2015-06-29 10:19 c_schmitz Note Added: 32541
2015-06-29 11:11 c_schmitz Note Added: 32542
2015-06-29 11:11 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)