View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
06865Bug reportsInstallationpublic2012-11-13 16:38
Reporterspitfire_pt Assigned Toc_schmitz  
PriorityimmediateSeverityblock 
Status closedResolutionunable to reproduce 
Summary06865: unable to open survey after version update from 1.90 to 1.92+ Build 120919
Description

Stange because i have several active surveys on the same macchine and only one is giving this error when i try to run it on the browser to answer.

Unknown column 'lime_survey_53946.token' in 'where clause':SELECT id,submitdate,lastpage FROM lime_survey_53946 WHERE lime_survey_53946.token='286b2ghkt2cnuq7' order by id desc

also when i try to view the responses

Couldn't get response data
SELECT count(*) FROM lime_survey_53946 LEFT JOIN lime_tokens_53946 ON lime_survey_53946.token = lime_tokens_53946.token
Unknown column 'lime_survey_53946.token' in 'on clause'

also when i try to list the token list
Could not find token!
Unknown column 'token' in 'where clause'

really dont understant whats the problem and how to fix it

Steps To Reproduce

i exported the survey, modified the ID, imported as a new servey and it works.

but this doesnt let me recover the responses i had on the original survey.

TagsNo tags attached.
Attached Files
Bug heat2
Complete LimeSurvey version number (& build)120919
I will donate to the project if issue is resolvedNo
BrowserALL
Database type & version155.5
Server OS (if known)Windows Server 2003 Standard Edition Service Pack 2
Webserver software & version (if known)CGI/FastCGI
PHP Version5.3.9
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-11-13 16:38

administrator   ~22116

Edit the surveys table and set anynomized for that particular survey to 'Y'.

This is most probably because someone edited the database directly because there was never a bug like this in the past.

Anyway, since we do not provide patches for 1.92 anymore I will close the issue. For further questions please use the forums instead, thank you.

Issue History

Date Modified Username Field Change
2012-11-13 15:40 spitfire_pt New Issue
2012-11-13 15:40 spitfire_pt File Added: limesurvey_survey_53946.lss
2012-11-13 16:38 c_schmitz Note Added: 22116
2012-11-13 16:38 c_schmitz Status new => closed
2012-11-13 16:38 c_schmitz Assigned To => c_schmitz
2012-11-13 16:38 c_schmitz Resolution open => unable to reproduce