View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
09020Bug reportsOtherpublic2014-05-05 20:52
ReporterVibha Assigned ToMazi  
PrioritynormalSeveritypartial_block 
Status closedResolutionno change required 
Product Version2.05+ 
Summary09020: Not able to see tables which stores survey response
Description

I have created many survey and also responded to those surveys, but in database i am not able to find any table which holds survey response, i saw survey table users, and question etc table. but not able to find survey respond. Please suggest what naming convention limesurvey follows to store survey respond in database.

Steps To Reproduce

I have created many survey and also responded to those surveys, but in database i am not able to find any table which holds survey response, i saw survey table users, and question etc table. but not able to find survey respond. Please suggest what naming convention limesurvey follows to store survey respond in database.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)Version 2.05+ Build 140414
I will donate to the project if issue is resolvedNo
BrowserAny Browser tried on mozilla, IE , Chrome
Database type & versionmicrosoft sql SERVER 2008 R2
Server OS (if known)Red hat linux - Linux version 2.6.18-238.el5
Webserver software & version (if known)Apache/2.2.3
PHP VersionPHP 5.3.3
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2014-05-05 20:52

updater   ~29959

Once a survey is activated Limesurvey creates a table named "<prefix>survey<surveyID>", e.g. "lime_survey_123456" at which all responses are stored.

-> Ticket closed, no bug.

Issue History

Date Modified Username Field Change
2014-05-05 14:23 Vibha New Issue
2014-05-05 20:52 Mazi Note Added: 29959
2014-05-05 20:52 Mazi Assigned To => Mazi
2014-05-05 20:52 Mazi Status new => assigned
2014-05-05 20:52 Mazi Status assigned => closed
2014-05-05 20:52 Mazi Resolution open => no change required