View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
20241Bug reportsSurvey participants (Tokens)public2025-08-27 11:20
Reporterasshank Assigned To 
PrioritynoneSeverityblock 
Status newResolutionopen 
Product Version6.6.x 
Summary20241: Tokenmanagement failes on serveral issues (after 6.15.3+250708)
Description

Token-usage not stable since 6.15.3!

Nummerous issues are posted concering the usage of tokens.

This is truly a serious bug. Partial fixes are made but still the management of tokens is not correct. (compared to 6.15.3 and before).

In upcoming release 6.15.8+250825 issue 20235 is partly addressed.

Open issues:

  • Not able to restore old_token tables when reactivating (closed) surveys
    Thus: Token table always empty after reactivating

  • New tables occurred in our database, (e.g lime_oldquestions[sid]_[datetime])
    what is the usage of this tables?

  • New field [access_mode] in table [lime_surveys]
    This new field is causing confusing, as it is not working correctly and not well documented.

See also:
https://bugs.limesurvey.org/view.php?id=20235
https://bugs.limesurvey.org/view.php?id=20230
https://bugs.limesurvey.org/view.php?id=20193
https://bugs.limesurvey.org/view.php?id=20186
https://bugs.limesurvey.org/view.php?id=20183
https://bugs.limesurvey.org/view.php?id=20179
and
https://github.com/LimeSurvey/LimeSurvey/pull/4300

Steps To Reproduce

Steps to reproduce

Make a survey

Activate survey in closed mode

An empty token table is ready to be filled

Add/make a token

Use survey, type token and Submit survey

Deactivate survey

Activate survey again en choose Closed mode

Expected result

A form with options to restore old token tables
See attachment (taken from version 6.15.3+250708)
Choose restore: old tokens are restored

Actual result

An empty token table is ready to be filled
A lime_oldquestions[sid]_[datetime] is created

TagsNo tags attached.
Attached Files
Bug heat4
Complete LimeSurvey version number (& build)6.15.8+250825
I will donate to the project if issue is resolvedNo
BrowserEdge
Database type & versionmariabdb 10
Server OS (if known)CentOS 7
Webserver software & version (if known)apache
PHP Version8.2

Users monitoring this issue

franz007

Activities

zufolo441

zufolo441

2025-08-25 17:38

reporter   ~83318

Hi, I confirm this bug.
I have to manually drop empty table lime_tokens_xxxxxx to make it appear restore tokens dialog. Alternatively, I drop table and manually rename lime_old_tokensxxxxx$timestamp

Issue History

Date Modified Username Field Change
2025-08-25 17:07 asshank New Issue
2025-08-25 17:07 asshank File Added: Schermafbeelding 2025-08-25 112534.png
2025-08-25 17:38 zufolo441 Note Added: 83318
2025-08-25 17:38 zufolo441 Bug heat 0 => 2
2025-08-27 11:20 franz007 Issue Monitored: franz007
2025-08-27 11:20 franz007 Bug heat 2 => 4