View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
06368Bug reportsSurvey participants (Tokens)public2012-07-25 03:26
Reporterjcleeland Assigned Tojcleeland  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Fixed in Version2.00+ 
Summary06368: Some older tokens tables don't have all required fields - lists, exports & searches fail
Description

Although the upgrade process is supposed to upgrade tokens tables, some of mine weren't upgraded resulting in errors. Similarly if old tokens tables were reactivated they didn't always have the participants_id field, or the validfrom and validuntil fields

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)201207
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL
Server OS (if known)Windows
Webserver software & version (if known)ApacheII
PHP Version5

Users monitoring this issue

There are no users monitoring this issue.

Activities

jcleeland

jcleeland

2012-07-22 13:38

reporter   ~19911

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

jcleeland

jcleeland

2012-07-25 03:25

reporter   ~19954

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

jcleeland

jcleeland

2012-07-25 03:26

reporter   ~19955

20120725

Related Changesets

LimeSurvey: Yii 383e06f6

2012-07-22 04:38:28

jcleeland

Details Diff
Fixed issue 06368 Some older tokens tables don't have all required fields - lists, exports & searches fail - system checks for existence of fields and creates them if needed (would love confirmation from postgres db that this works ok for them) Affected Issues
06368
mod - application/controllers/admin/tokens.php Diff File
mod - application/models/Tokens_dynamic.php Diff File
mod - scripts/admin/tokens.js Diff File

LimeSurvey: Yii c2897ab4

2012-07-24 17:07:44

jcleeland

Details Diff
Fixed issue 06368 - Some older tokens tables don't have all required fields. Fixed issue, deals with Yii's shortocmings handling varchar fields for different db's. Affected Issues
06368
mod - application/helpers/update/updatedb_helper.php Diff File
mod - application/models/Tokens_dynamic.php Diff File

LimeSurvey: Yii 618c326f

2012-07-24 18:25:28

jcleeland

Details Diff
Fixed issue 06368 missing variable after creating function Affected Issues
06368
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-07-22 13:33 jcleeland New Issue
2012-07-22 13:33 jcleeland Status new => assigned
2012-07-22 13:33 jcleeland Assigned To => jcleeland
2012-07-22 13:38 jcleeland Changeset attached => LimeSurvey Yii 383e06f6
2012-07-22 13:38 jcleeland Note Added: 19911
2012-07-22 13:38 jcleeland Resolution open => fixed
2012-07-25 03:25 jcleeland Changeset attached => LimeSurvey Yii c2897ab4
2012-07-25 03:25 jcleeland Changeset attached => LimeSurvey Yii 618c326f
2012-07-25 03:25 jcleeland Note Added: 19954
2012-07-25 03:26 jcleeland Note Added: 19955
2012-07-25 03:26 jcleeland Status assigned => closed
2012-07-25 03:26 jcleeland Fixed in Version => 2.00+
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)