View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
05579Bug reportsSurvey takingpublic2012-02-01 23:26
Reporterbnosie Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version1.91+ 
Summary05579: Receive error when submitting surveys
Description

When trying to take a survey, get the following error:
Invalid object name 'tokens_23974'.:SELECT * FROM [tokens_23974] WHERE token=' '
The survey was not activated in closed-access mode, and does not have a tokens table. This happens with any survey created.

Steps To Reproduce

Create a survey, activate it, choose "No Thanks" for Closed-access mode. Try to run the survey, and when you submit, it gives the error.

Additional Information

Using driver MSSQL_N

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)11343
I will donate to the project if issue is resolvedNo
BrowserFirefox & Internet Explorer
Database type & versionMSSQL 2008 SP2
Server OS (if known)CentOS 5.2
Webserver software & version (if known)Apache 2.2.3
PHP Version5.2.16
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

bnosie

bnosie

2011-11-14 16:08

reporter   ~16664

I've found that you have to specifically set Anonymized Answers to Yes on the Tokens tab if you use Open Access mode. Otherwise you get the above error.

c_schmitz

c_schmitz

2011-11-15 16:19

administrator   ~16683

I can't reproduce. mssql_n is an experimental driver and will no longer be support. Try switching to mssqlnative or mssql instead and report if the issue persists.

c_schmitz

c_schmitz

2012-01-23 16:04

administrator   ~16909

Any feedback?

c_schmitz

c_schmitz

2012-02-01 23:26

administrator   ~17152

No feedback.

Issue History

Date Modified Username Field Change
2011-11-14 15:46 bnosie New Issue
2011-11-14 16:08 bnosie Note Added: 16664
2011-11-14 18:29 c_schmitz Assigned To => c_schmitz
2011-11-14 18:29 c_schmitz Status new => assigned
2011-11-15 16:19 c_schmitz Note Added: 16683
2011-11-15 16:19 c_schmitz Status assigned => feedback
2012-01-23 16:04 c_schmitz Note Added: 16909
2012-02-01 23:26 c_schmitz Note Added: 17152
2012-02-01 23:26 c_schmitz Status feedback => closed
2012-02-01 23:26 c_schmitz Resolution open => unable to reproduce