View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
07673Bug reportsSurvey takingpublic2013-03-16 21:002013-03-17 15:40
Reporterdavid2013 Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07673: When Study Is Deactivated, Database Error Message Is Shown For Respondents Who Is Doing Survey
Description

When study is deactivated, the following database error message is shown for respondent who is try to complete the survey.

Here is error message:
Internal Server Error
The table "{{survey_391282_timings}}" for active record class "Survey_timings" cannot be found in the database.

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

However, when study is expired and respondent try to complete the survey, it will show a very friendly message saying "the survey is no longer available...".
I think respondent, in any circumstance, should not see the database error message. Can we show something similar message when study is deactivated? like the study is deactivated, please contact admin or something like that.

Steps To Reproduce
  1. Test any active survey. (keep this page open, do not close it)
  2. go to admin panel (use a new tab or different browser) to de-activated this survey.
  3. go back to survey testing, try to click the next button, the database error message will show.
TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)130311
I will donate to the project if issue is resolvedNo
BrowserAny browser
Database type & versionMYSQL 5.5.27
Server OS (if known)Window 7
Webserver software & version (if known)EasyPHP with APACHE 2.4.2 MYSQL 5.5.27 PHP 5.4.6
PHP VersionPHP 5.4.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2013-03-16 22:26

administrator   ~24708

This problem does not occur for normal participants because they will get a proper message. It only happens for admin users because they have the exception to preview a survey while it is not active.
The exit is now a bit cleaner for admins.
c_schmitz

c_schmitz

2013-03-16 22:27

administrator   ~24709

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

c_schmitz

2013-03-17 12:12

administrator   ~24713

New version released.
c_schmitz

c_schmitz

2013-03-17 15:40

administrator   ~24730

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

Related Changesets

LimeSurvey: master 9aed3e36

2013-03-16 22:27

c_schmitz


Details Diff		 Fixed issue 07673: When survey is deactivated during previewing a survey a system error message is shown for survey admins Affected Issues
07673
mod - application/helpers/expressions/em_manager_helper.php Diff File

LimeSurvey: 2.05 63dda19d

2013-03-16 22:27

c_schmitz


Details Diff		 Fixed issue 07673: When survey is deactivated during previewing a survey a system error message is shown for survey admins Affected Issues
07673
mod - application/helpers/expressions/em_manager_helper.php Diff File

Issue History

Date Modified Username Field Change
2013-03-16 21:00 david2013 New Issue
2013-03-16 21:14 c_schmitz Assigned To => c_schmitz
2013-03-16 21:14 c_schmitz Status new => assigned
2013-03-16 22:26 c_schmitz Note Added: 24708
2013-03-16 22:26 c_schmitz Status assigned => resolved
2013-03-16 22:26 c_schmitz Fixed in Version => 2.00+
2013-03-16 22:26 c_schmitz Resolution open => fixed
2013-03-16 22:27 c_schmitz Changeset attached => LimeSurvey master 9aed3e36
2013-03-16 22:27 c_schmitz Note Added: 24709
2013-03-17 12:12 c_schmitz Note Added: 24713
2013-03-17 12:12 c_schmitz Status resolved => closed
2013-03-17 15:40 c_schmitz Changeset attached => LimeSurvey 2.05 63dda19d
2013-03-17 15:40 c_schmitz Note Added: 24730