View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
05720Bug reportsSurvey participants (Tokens)public2012-01-30 11:412012-03-14 21:08
Reporteruser11071Assigned Toc_schmitz  
PriorityurgentSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00a1 
Fixed in Version2.00a2 
Summary05720: Automatic token generating don't work
Description

In methode Tokens_Dynamic::selectEmptyTokens and Tokens_Dynamic::updateToken the table can not be found. The method bindParameter seems to bind false and an exception occurs.

i.e.:

return Yii::app()->db->createCommand("SELECT tid FROM :tablename WHERE token IS NULL OR token=''")->bindParam(":tablename", $this->tableName(), PDO::PARAM_STR)->queryAll();

Found in r12139 of /application/models/Tokens_Dynamic.php

Steps To Reproduce

Try to generate random token for users with empty tokens in table

Additional Information

This solves the problem for me.
return Yii::app()->db->createCommand("SELECT tid FROM " . $this->tableName() . " WHERE token IS NULL OR token=''")->queryAll();

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)2
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMysql
Server OS (if known)mac os x
Webserver software & version (if known)apache
PHP Version5.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-01-30 18:04

administrator   ~17061

Thank you!
c_schmitz

c_schmitz

2012-03-11 16:32

administrator   ~17863

2.00alpha 2 Build 120212 released

Related Changesets

LimeSurvey: Yii a32018ea

2012-01-30 09:05:00

c_schmitz

Details Diff 		Fixed issue 05720: Automatic token generation not working
Fixed issue: Not being able to login in Postgres

git-svn-id: file:///Users/Shitiz/Downloads/lssvn/source/limesurvey_yii@12253 b72ed6b6-b9f8-46b5-92b4-906544132732		 Affected Issues
05720
mod - application/controllers/InstallerController.php Diff File
mod - application/core/UserIdentity.php Diff File
mod - application/models/Tokens_dynamic.php Diff File

Issue History

Date Modified Username Field Change
2012-01-30 11:41 user11071 New Issue
2012-01-30 18:04 c_schmitz Note Added: 17061
2012-01-30 18:04 c_schmitz Status new => resolved
2012-01-30 18:04 c_schmitz Fixed in Version => 2.00a2
2012-01-30 18:04 c_schmitz Resolution open => fixed
2012-01-30 18:04 c_schmitz Assigned To => c_schmitz
2012-03-11 16:32 c_schmitz Note Added: 17863
2012-03-11 16:32 c_schmitz Status resolved => closed
2012-03-14 21:08 c_schmitz Changeset attached => Import 2012-03-09 13:30:34 Yii a32018ea
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)