View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
08089Bug reportsSurvey participants (Tokens)public2013-08-08 15:592013-09-26 23:56
Reporterrandom1 Assigned Tomdekker  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary08089: Faulty token table definition
Description

This probably only affects upgraded installations.

There are two new database fields for tokens in version 2.xx (participant_id and blacklisted), that do allow NULL values. (token_helper.php)

In Tokens_dynamic.php, function checkColumns, they are defined as NOT NULL.

After an upgrade from version 1.9.2, the tokens_xx tables are missing the participant_id and blacklisted columns.

The checkColumns function later adds those columns as not null, leading to a database error when trying to access a survey's tokens, generate dummy tokens, etc.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)Version 2.00+ Build 130802
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgresql, DBVersion 164
Server OS (if known)Linux
Webserver software & version (if known)Apache 2.2
PHP Version5.4.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

mdekker

mdekker

2013-09-03 10:10

reporter   ~26134

Thanks for reporting
mdekker

mdekker

2013-09-03 10:49

reporter   ~26135

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

mdekker

2013-09-03 11:55

reporter   ~26138

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

Related Changesets

LimeSurvey: master c8f090e1

2013-09-03 10:48

mdekker


Details Diff		 Fixed 08089: Faulty token table definition Affected Issues
08089
mod - application/models/Tokens_dynamic.php Diff File

LimeSurvey: 2.05 42b59879

2013-09-03 11:55

mdekker


Details Diff		 Fixed 08089: Faulty token table definition Affected Issues
08089
mod - application/models/TokenDynamic.php Diff File

Issue History

Date Modified Username Field Change
2013-08-08 15:59 random1 New Issue
2013-09-03 10:10 mdekker Assigned To => mdekker
2013-09-03 10:10 mdekker Status new => assigned
2013-09-03 10:10 mdekker Note Added: 26134
2013-09-03 10:49 mdekker Changeset attached => LimeSurvey master c8f090e1
2013-09-03 10:49 mdekker Note Added: 26135
2013-09-03 10:49 mdekker Resolution open => fixed
2013-09-03 11:55 mdekker Changeset attached => LimeSurvey 2.05 42b59879
2013-09-03 11:55 mdekker Note Added: 26138
2013-09-26 23:56 c_schmitz Status assigned => closed
2013-09-26 23:56 c_schmitz Fixed in Version => 2.00+
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)