In general we do not support the restoration of old survey or token tables from previous versions. They are completely unlinked from the system and in general are not updated.

Ich verstehe das dies auf alte Survey/Token-Tabellen zutrifft welche zum Zeitpunkt des Updates 1.90->2.00 bereits deaktiviert waren (old_tokens_xxxx).

Die hier angesprochenen Surveys/Tokens waren aber noch AKTIV, die Umfragen sind lediglich ausgelaufen (expired). Sollte in dem Fall bei einem Update nicht die Token Tabelle auf den neusten Stand angehoben werden?

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

@rom: you can try to replace your tokens.php with the one from the changeset or edit the file manually.

please report back if this fixed your problem

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

Feel free to reopen if the problem still exists after this fix

@mdekker: I replaced the tokens and the survey_links file, and did not get the SQL Error again. (4 tries)

But still getting the same result as before: The tokens table is empty afterwards. I attached a video file for better explanation. Also, please note: That error DOES NOT occur if I manually delete every token (since you guys removed the "empty token table" option) and replace them with dummy entries.

The entries in the video are not dummy entries, they are the old ones. I just replaced the real names with a "test" string.

it looks like the tokens are there, but not showing because of some illegal join condition. I will check on that. In the meantime, can you verify for me that in the table the records are present using a tool like phpmyadmin or similar?

I tried again but am not able to reproduce when i delete the extra fields from the token table i can get the sql error you had but that is fixed now and the missing fields are created. Following that I always see the right numbers and the tokens.

Maybe something else has changed that fixed this from happening. There has been one other commit to the tokens.php file.
Could you download the lastest tokens.php and replace it?

I updated my tokens.php file to the one from 24.11.2012

Still the same issue. Checked with phpmyadmin, and the table is there, and has content.

But I finally got it: I digged through the content of the token tables as the problem did not occur with dummy entries, and just figured out the differences between the dummy entries and my old ones.

Once I set the "completed" field from a single entry to a date - e.g. "2011-11-01 10:20" instead of "N", the whole table is not displayed in the backend. I guess this will help you a lot.

Thanks, will have a look later! Are the fields in the old table empty or NULL?

No, the old table also is set to a Timestamp like "2011-11-01 10:20" in the completed column. Maybe the Token Management uses some other SQL commands to display the Token Table once the survey is deactivated as opposed to when it is activated or expired.

That could even make a bit of sense from a specific point of view, as a deactivated suvey may not contain tokens with a completed status, instead it should only contain incomplete tokens.

Your survey is deactivated... got that after reading a thousand times and breaking my head why it works for me ;-) I'm fixing it right now. Thank you for being precise and persistent, finally we got it! Will commit the fix soon.

Thanks for fixing it (& the warm words ;))

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

Feel free to reopen if the issue still exists. (is not in release 121127)

LimeSurvey 2.0+ build 121204 released.