View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 10807 | Bug reports | Survey editing | public | 2016-03-21 16:57 | 2016-05-10 16:39 |
| Reporter | rittmannsd87 | Assigned To | ollehar | ||
| Priority | none | Severity | minor | ||
| Status | closed | Resolution | unable to reproduce | ||
| Fixed in Version | 2.50.x | ||||
| Summary | 10807: failure to activate survey | ||||
| Description | Trying to activate the survey, the homepage tells me: Survey table could not be created Database error! | ||||
| Tags | No tags attached. | ||||
| Attached Files | error message.htm (67,083 bytes)
<!DOCTYPE html>
<html dir="ltr" lang="en"><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<!-- Assets load -->
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/font-awesome-43-debugmode.css">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/bootstrap.css" media="screen">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/yiistrap.css" media="screen">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/lime-admin.css">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/fonts.css">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/statistics.css">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/bootstrap-switch.css">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/jcarousel.css">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/lime-admin-misc.css">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/attributeMap.css">
<link rel="stylesheet" type="text/css" href="error%20message-Dateien/attributeMapToken.css">
<script type="text/javascript" src="error%20message-Dateien/jquery-1.js"></script>
<script type="text/javascript" src="error%20message-Dateien/jquery-ui-1.js"></script>
<script type="text/javascript" src="error%20message-Dateien/jquery_002.js"></script>
<script type="text/javascript" src="error%20message-Dateien/admin_core.js"></script>
<script type="text/javascript" src="error%20message-Dateien/notify.js"></script>
<script type="text/javascript" src="error%20message-Dateien/save.js"></script>
<script type="text/javascript" src="error%20message-Dateien/panelclickable.js"></script>
<script type="text/javascript" src="error%20message-Dateien/panelsanimation.js"></script>
<script type="text/javascript" src="error%20message-Dateien/sidemenu.js"></script>
<script type="text/javascript" src="error%20message-Dateien/bootstrap-switch.js"></script>
<script type="text/javascript" src="error%20message-Dateien/jquery.js"></script>
<script type="text/javascript" src="error%20message-Dateien/jcarousel.js"></script>
<script type="text/javascript" src="error%20message-Dateien/script.js"></script>
<script type="text/javascript">
/*<![CDATA[*/
LS.data = {"baseUrl":"http:\/\/homepage.univie.ac.at\/doris.rittmannsberger\/limesurvey","showScriptName":true,"urlFormat":"path","adminImageUrl":"http:\/\/homepage.univie.ac.at\/doris.rittmannsberger\/limesurvey\/styles\/Sea_Green\/images\/\/14\/","csrfToken":"a364c94a3bd7277dae79b5c902d89ec86664cb94","language":"en","replacementFields":{"path":"\/doris.rittmannsberger\/limesurvey\/index.php\/admin\/limereplacementfields\/sa\/index"}};
$.ajaxSetup({data: {YII_CSRF_TOKEN: LS.data.csrfToken}});
/*]]>*/
</script>
<title>PTSD in ID Delphi</title>
<link rel="shortcut icon" href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/styles/favicon.ico" type="image/x-icon">
<link rel="icon" href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/styles/favicon.ico" type="image/x-icon">
</head>
<body>
<script type="text/javascript">
var frameSrc = "/login";
var userdateformat='dd.mm.yy';
var userlanguage='en';
</script>
<!-- admin menu bar -->
<nav class="navbar">
<div class="navbar-header">
<button class="navbar-toggle limebutton" type="button" data-toggle="collapse" data-target="#small-screens-menus">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/index">
PTSD in ID Delphi </a>
</div>
<!-- Only on xs screens -->
<div class="collapse navbar-collapse pull-left hidden-sm hidden-md hidden-lg" id="small-screens-menus">
<ul class="nav navbar-nav hidden-sm hidden-md hidden-lg">
<li><br><br></li>
<!-- active surveys -->
<!-- List surveys -->
<li>
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/listsurveys">
List surveys </a>
</li>
<!-- Logout -->
<li>
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/authentication/sa/logout">
Logout </a>
</li>
</ul>
</div>
<div class="collapse navbar-collapse js-navbar-collapse pull-right">
<ul class="nav navbar-nav navbar-right">
<!-- Configuration menu -->
<!-- Configuration -->
<li class="dropdown mega-dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown">
<span class="icon-settings"></span>
Configuration <span class="caret"></span>
</a>
<ul class="dropdown-menu mega-dropdown-menu" id="mainmenu-dropdown">
<!-- System overview -->
<li class="col-sm-3">
<!-- System overview -->
<div class="box" id="systemoverview">
<div class="box-icon">
<span class="glyphicon glyphicon-info-sign" id="info-header"></span>
</div>
<div class="info">
<h5 class="text-center">System overview</h5>
<dl class="dl-horizontal">
<dt class="text-info">Users</dt>
<dd>6</dd>
<dt class="text-info">Surveys</dt>
<dd>2</dd>
<dt class="text-info">Active surveys</dt>
<dd>0</dd>
<dt class="text-info">Active tokens tables</dt>
<dd>0</dd>
<dt class="text-info">ComfortUpdate key</dt>
<dd>Activated</dd>
</dl>
</div>
</div>
</li>
<!-- Expression Manager -->
<li class="col-sm-3">
<ul>
<!-- Expression Manager -->
<li class="dropdown-header">
<span class="icon-expression"></span>
Expression Manager </li>
<!-- Expression Manager Descriptions -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/expressions">
Expression Manager descriptions </a>
</li>
<!--Available Functions -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/expressions/sa/functions">
Available functions </a>
</li>
<!--Unit Tests of Expressions Within Strings -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/expressions/sa/strings_with_expressions">
Unit tests of expressions within strings </a>
</li>
<!-- Unit Test Dynamic Relevance Processing -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/expressions/sa/relevance">
Unit test dynamic relevance processing </a>
</li>
<!-- Preview Conversion of Conditions to Relevance -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/expressions/sa/conditions2relevance">
Preview conversion of conditions to relevance </a>
</li>
<!-- Bulk Convert Conditions to Relevance -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/expressions/sa/upgrade_conditions2relevance">
Bulk convert conditions to relevance </a>
</li>
<!-- Test Navigation -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/expressions/sa/navigation_test">
Test navigation </a>
</li>
<!-- Show Survey logic file -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/expressions/sa/survey_logic_file">
Show survey logic file </a>
</li>
</ul>
</li>
<!-- Advanced -->
<li class="col-sm-2">
<ul>
<!-- Advanced -->
<li class="dropdown-header">
<span class="icon-tools"></span>
Advanced </li>
<!-- Check Data Integrity -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/checkintegrity">
Check data integrity </a>
</li>
<!-- Backup Entire Database -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/dumpdb">
Backup entire database </a>
</li>
<!-- Plugin manager -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/pluginmanager/sa/index">
Plugin manager </a>
</li>
</ul>
</li>
<!-- Users -->
<li class="col-sm-2">
<!-- Users -->
<ul>
<!-- Users -->
<li class="dropdown-header">
<span class="icon-user"></span>
Users </li>
<!-- Manage survey administrators -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/user/sa/index">
Manage survey administrators </a>
</li>
<!-- Create/edit user groups -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/usergroups/sa/index">
Create/edit user groups </a>
</li>
<!-- Central participant database/panel -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/participants/sa/displayParticipants">
Central participant database/panel </a>
</li>
</ul>
</li>
<!-- Settings -->
<li class="col-sm-2">
<ul>
<!-- Settings -->
<li class="dropdown-header">
<span class="icon-global"></span>
Settings </li>
<!-- Home page settings -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/homepagesettings">
Home page settings </a>
</li>
<!-- Global settings -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/globalsettings">
Global settings </a>
</li>
<!-- Edit label sets -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/labels/sa/view">
Edit label sets </a>
</li>
<!-- Template Editor -->
<li class="dropdown-item">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/templates/sa/view">
Template editor </a>
</li>
</ul>
</li>
</ul>
</li>
<!-- Surveys menus -->
<li class="dropdown-split-left">
<a style="" href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/listsurveys">
Surveys </a>
</li>
<li class="dropdown dropdown-split-right">
<a style="padding-left: 5px;padding-right: 5px;" href="#" class="dropdown-toggle" data-toggle="dropdown">
<span style="margin-left: 0px;" class="caret"></span>
</a>
<ul class="dropdown-menu" role="menu">
<!-- Create a new survey -->
<li>
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/newsurvey">
Create a new survey </a>
</li>
<!-- Import a survey -->
<li>
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/newsurvey/tab/import">
Import a survey </a>
</li>
<!-- Import a survey -->
<li>
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/newsurvey/tab/copy">
Copy a survey </a>
</li>
<li class="divider"></li>
<!-- List surveys -->
<li>
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/listsurveys">
List surveys </a>
</li>
</ul>
</li>
<!-- user menu -->
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false">rittmannsd87 <span class="caret"></span></a>
<ul class="dropdown-menu" role="menu">
<!-- Edit your personal preferences -->
<li>
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/user/sa/personalsettings">Edit your personal preferences</a>
</li>
<li class="divider"></li>
<!-- Logout -->
<li>
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/authentication/sa/logout">
Logout </a>
</li>
</ul>
</li>
<!-- active surveys -->
<li class="">
<a href="#notifications">
<span class=" label update-small-notification hidden">1</span>
<i class="nav-icon fa fa-bullhorn"></i>
</a>
<!-- NOTIFICATIONS -->
<ul class="dropdown-menu update-small-notification hidden" role="menu">
<li class="hidden-xs notifications-list " id="main-navbar-notifications">
<strong>A new update is available. </strong> <a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/update">Click here to use ComfortUpdate.</a>
</li>
</ul> <!-- / .dropdown-menu -->
</li>
</ul>
</div><!-- /.nav-collapse -->
</nav>
<div class="menubar surveymanagerbar">
<div class="row container-fluid">
<div class="col-xs-12 col-md-12">
<h3 id="survey_title"><a href="">Dummy Delphi(ID:597566)</a></h3>
</div>
</div>
</div>
<div class="container-fluid" id="in_survey_common"><div class="row">
<div class="col-lg-12" id="update-container">
<div class="alert alert-warning alert-dismissible alert-security-update" role="alert" id="update-alert" data-url-notification-state="/doris.rittmannsberger/limesurvey/index.php/admin/update/sa/notificationstate">
<button type="button" class="close limebutton" data-dismiss="alert" aria-label="Close"><span>×</span></button>
<strong>Security Update !</strong> a security update is available. <a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/update">Click here to use ComfortUpdate.</a>
</div>
</div>
<div id="notif-container" class="col-lg-12 content-right" style="z-index: 10100">
</div>
<!-- State when page is loaded : for JavaScript-->
<input id="close-side-bar" type="hidden">
<!-- To handle correctly the side menu positioning -->
<div class="absolute-wrapper hidden-xs" style="z-index: 100; opacity: 0.5; left: -250px;"> </div>
<!-- sideMenu -->
<div class="side-menu hidden-xs" id="sideMenu" style="z-index: 101; opacity: 0.5; left: -250px;">
<nav class="navbar navbar-default hidden-xs" role="navigation">
<!-- Header : General -->
<div class="navbar-header hidden-xs">
<div class="brand-wrapper hidden-xs">
<!-- Hamburger for futur mobile design-->
<button type="button" class="navbar-toggle hidden-xs limebutton">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<div class="row no-gutter">
<!-- Brand -->
<div class="col-sm-7">
<div class="brand-name-wrapper hidden-xs">
<a class="navbar-brand toggleside showside" href="#">
General </a>
</div>
</div>
<!-- chevrons to stretch the side menu -->
<div class="col-sm-5">
<a class="btn btn-default hide-button hidden-xs pull-right closed" id="chevronStretch">
<span class="glyphicon glyphicon-chevron-right"></span>
</a>
<a class="btn btn-default hide-button hidden-xs pull-right closed" id="chevronClose">
<span class="glyphicon glyphicon-chevron-left"></span>
</a>
</div>
</div>
</div>
</div>
<!-- Main Menu -->
<div class="side-menu-container hidden-xs">
<ul style="opacity: 0;" class="nav navbar-nav sidemenuscontainer hidden-xs">
<!-- Link to survey summary-->
<li class="toWhite ">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/view/surveyid/597566">
<span class="glyphicon glyphicon-info-sign"></span>
Survey </a>
</li>
<!-- Question & Groups-->
<li style="opacity: 1; top: 0px;" class="panel panel-default dropdownlvl1" id="dropdown">
<a data-toggle="collapse" id="questions-groups-collapse" href="#dropdown-lvl1">
<span class="glyphicon glyphicon-folder-open"></span> Questions and groups: <span class="caret"></span>
</a>
<!-- Question Explorer -->
<div id="dropdown-lvl1" class="panel-collapse collapse in">
<div class="panel-body">
<ul class="nav navbar-nav dropdown-first-level">
<!-- Explorer -->
<!-- State when page is loaded : for JavaScript-->
<li style="opacity: 1; top: 0px;" class="panel panel-default" id="explorer">
<a data-toggle="collapse" id="explorer-collapse" href="#explorer-lvl1">
<span class="glyphicon glyphicon-folder-open"></span> Questions explorer <span class="caret"></span>
</a>
<div id="explorer-lvl1" class="panel-collapse collapse">
<div class="panel-body">
<ul class="nav navbar-nav dropdown-first-level" id="explorer-container">
<!-- Groups and questions-->
<li style="opacity: 1; top: 0px;" class="panel panel-default dropdownstyle" id="questionexplorer-group-container">
<div class="row ">
<div class="col-sm-8">
<!-- add group -->
<a data-original-title="Add a group" class="btn btn-link" data-toggle="tooltip" data-placement="bottom" title="" href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/questiongroups/sa/add/surveyid/597566">
<span class="glyphicon glyphicon-plus-sign"></span>
Add group </a>
</div>
</div>
<!-- Group -->
<div class="row explorer-group-title">
<div class="col-sm-8">
<a href="#" data-question-group-id="19" class="explorer-group">
<span id="caret-19" class="fa fa-caret-right caret-explorer-group"></span> Dummy Delphi 2 </a>
</div>
<div class="col-sm-3" id="questions-container-19">
<!-- add question to this group -->
<a data-original-title="Add a question to this group" data-toggle="tooltip" data-placement="top" title="" class="" href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/questions/sa/newquestion/surveyid/597566/gid/19">
<span class="glyphicon glyphicon-plus-sign"></span>
</a>
</div>
</div>
<!-- Questions -->
<div class="row" id="questions-group-19" style="display: none;">
<div class="col-sm-12">
<!-- Active question -->
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/questions/sa/view/surveyid/597566/gid/19/qid/518" class="question-link">
<span class="question-collapse-title">
<span class="glyphicon glyphicon-list"></span>
<strong>
DD03 </strong>
<br>
<em>
ölkjölkj
</em>
</span>
</a>
<!-- Active question -->
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/questions/sa/view/surveyid/597566/gid/19/qid/519" class="question-link">
<span class="question-collapse-title">
<span class="glyphicon glyphicon-list"></span>
<strong>
DD04 </strong>
<br>
<em>
ölkjö
ayxc </em>
</span>
</a>
</div>
</div>
<!-- Group -->
<div class="row explorer-group-title">
<div class="col-sm-8">
<a href="#" data-question-group-id="18" class="explorer-group">
<span id="caret-18" class="fa fa-caret-right caret-explorer-group"></span> Dummy Delphi 1 </a>
</div>
<div class="col-sm-3" id="questions-container-18">
<!-- add question to this group -->
<a data-original-title="Add a question to this group" data-toggle="tooltip" data-placement="top" title="" class="" href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/questions/sa/newquestion/surveyid/597566/gid/18">
<span class="glyphicon glyphicon-plus-sign"></span>
</a>
</div>
</div>
<!-- Questions -->
<div class="row" id="questions-group-18" style="display: none;">
<div class="col-sm-12">
<!-- Active question -->
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/questions/sa/view/surveyid/597566/gid/18/qid/516" class="question-link">
<span class="question-collapse-title">
<span class="glyphicon glyphicon-list"></span>
<strong>
DD01 </strong>
<br>
<em>
Is this
Delphi thing working?
</em>
</span>
</a>
<!-- Active question -->
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/questions/sa/view/surveyid/597566/gid/18/qid/517" class="question-link">
<span class="question-collapse-title">
<span class="glyphicon glyphicon-list"></span>
<strong>
DD02 </strong>
<br>
<em>
....kjölk j </em>
</span>
</a>
</div>
</div>
</li>
</ul>
</div>
</div></li>
<!-- List Groups -->
<li class="toWhite ">
<!-- admin/survey/sa/view/surveyid/838454 listquestiongroups($iSurveyID)-->
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/listquestiongroups/surveyid/597566">
<span class="glyphicon glyphicon-list"></span>
List question groups </a>
</li>
<!-- List Questions -->
<li class="toWhite ">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/listquestions/surveyid/597566">
<span class="glyphicon glyphicon-list"></span>
List questions </a>
</li>
<!-- Organize questions -->
<li>
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/organize/surveyid/597566">
<span class="icon-organize"></span>
Reorder question
groups / questions </a>
</li>
</ul>
</div>
</div>
</li>
<!-- Token -->
<li id="tokensidemenu" class="toWhite ">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/tokens/sa/index/surveyid/597566">
<span class="glyphicon glyphicon-user"></span>
Token management </a>
</li>
<!-- Survey List -->
<li class="toWhite">
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/listsurveys" class="">
<span class="glyphicon glyphicon-step-backward"></span>
Return to survey list </a>
</li>
</ul>
</div><!-- /.navbar-collapse -->
</nav>
</div>
<br>
<div class="messagebox ui-corner-all">
<div class="alert alert-success" role="alert">Timings table could not be created.</div>
<strong class="text-warning">Database error!!
<pre>'CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: \'utf8mb4\'. The SQL statement executed was: CREATE TABLE `lime_survey_597566` (
`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`token` varchar(35) ,
`submitdate` datetime,
`lastpage` int(11),
`startlanguage` varchar(20) NOT NULL,
`startdate` datetime NOT NULL,
`datestamp` datetime NOT NULL,
`refurl` text,
`597566X18X516` varchar(1) ,
`597566X18X517` text,
`597566X19X518` varchar(1) ,
`597566X19X519` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci'</pre>
<a href="http://homepage.univie.ac.at/doris.rittmannsberger/limesurvey/index.php/admin/survey/sa/view/surveyid/597566">Main admin screen</a>
</strong><br></div></div>
<!-- Footer -->
<footer class="footer">
<div class="container-fluid">
<div class="row">
<!-- Link to manual -->
<div class="col-xs-6 col-md-4 col-lg-1 ">
<a href="http://manual.limesurvey.org/" onclick='function go(ev) { ev.preventDefault(); var win = window.open("http://manual.limesurvey.org", "_blank"); win.focus(); }; go(event);'>
<span class="glyphicon glyphicon-info-sign" id="info-footer"></span>
</a>
</div>
<!-- Support / Donate -->
<div class="col-xs-6 col-md-4 col-lg-5 text-right">
<a href="http://donate.limesurvey.org/">
<img alt="Support this project: Donate to LimeSurvey" title="Support this project: Donate to LimeSurvey!" src="error%20message-Dateien/donate.png">
</a>
</div>
<!-- Lime survey website -->
<div class="col-xs-6 col-md-4 col-lg-6 text-right">
<a title="Visit our website!" href="http://www.limesurvey.org/" target="_blank">LimeSurvey</a><br>Version 2.50+ Build 160219 </div>
</div>
</div>
</footer>
<script type="text/javascript" src="error%20message-Dateien/bootstrap.js"></script>
<script type="text/javascript">
/*<![CDATA[*/
jQuery('body').popover({'selector':'a[rel=popover]'});
jQuery('body').tooltip({'selector':'a[rel=tooltip]'});
/*]]>*/
</script>
<table class="yiiLog" style="border-spacing:1px;font:11px Verdana, Arial, Helvetica, sans-serif;background:#EEEEEE;color:#666666;" cellpadding="2" width="100%">
<tbody><tr>
<th style="background:black;color:white;" colspan="6">
Profiling Summary Report
(Time: 0.09445s,
Memory: 7,294KB)
</th>
</tr>
<tr style="background-color: #ccc;">
<th>Procedure</th>
<th>Count</th>
<th>Total (s)</th>
<th>Avg. (s)</th>
<th>Min. (s)</th>
<th>Max. (s)</th>
</tr>
<tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW TABLES)</td>
<td align="center">1</td>
<td align="center">0.00700</td>
<td align="center">0.00700</td>
<td align="center">0.00700</td>
<td align="center">0.00700</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.execute(UPDATE `lime_surveys` SET
`template`=:yp0, `language`=:yp1, `sid`=:yp2, `owner_id`=:yp3,
`admin`=:yp4, `active`=:yp5, `expires`=:yp6, `startdate`=:yp7,
`adminemail`=:yp8, `anonymized`=:yp9, `faxto`=:yp10,
`savetimings`=:yp11, `additional_languages`=:yp12, `datestamp`=:yp13,
`usecookie`=:yp14, `allowregister`=:yp15, `allowsave`=:yp16,
`autonumber_start`=:yp17, `autoredirect`=:yp18, `allowprev`=:yp19,
`printanswers`=:yp20, `ipaddr`=:yp21, `refurl`=:yp22,
`datecreated`=:yp23, `publicstatistics`=:yp24, `publicgraphs`=:yp25,
`listpublic`=:yp26, `htmlemail`=:yp27, `sendconfirmation`=:yp28,
`tokenanswerspersistence`=:yp29, `assessments`=:yp30,
`usecaptcha`=:yp31, `usetokens`=:yp32, `bounce_email`=:yp33,
`attributedescriptions`=:yp34, `emailresponseto`=:yp35,
`emailnotificationto`=:yp36, `tokenlength`=:yp37,
`showxquestions`=:yp38, `showgroupinfo`=:yp39, `shownoanswer`=:yp40,
`showqnumcode`=:yp41, `bouncetime`=:yp42, `bounceprocessing`=:yp43,
`bounceaccounttype`=:yp44, `bounceaccounthost`=:yp45,
`bounceaccountpass`=:yp46, `bounceaccountencryption`=:yp47,
`bounceaccountuser`=:yp48, `showwelcome`=:yp49, `showprogress`=:yp50,
`questionindex`=:yp51, `navigationdelay`=:yp52, `nokeyboard`=:yp53,
`alloweditaftercompletion`=:yp54, `googleanalyticsstyle`=:yp55,
`googleanalyticsapikey`=:yp56, `format`=:yp57 WHERE
`lime_surveys`.`sid`=597566. Bound with :yp0='default', :yp1='en',
:yp2=597566, :yp3=1, :yp4='Doris Rittmannsberger', :yp5='N', :yp6=NULL,
:yp7=NULL, :yp8='doris.rittmannsberger@univie.ac.at', :yp9='N',
:yp10='', :yp11='N', :yp12='', :yp13='Y', :yp14='N', :yp15='N',
:yp16='Y', :yp17=0, :yp18='N', :yp19='N', :yp20='N', :yp21='N',
:yp22='Y', :yp23='2016-03-21', :yp24='N', :yp25='N', :yp26='N',
:yp27='N', :yp28='Y', :yp29='N', :yp30='N', :yp31='N', :yp32='N',
:yp33='doris.rittmannsberger@univie.ac.at', :yp34=NULL, :yp35='',
:yp36='', :yp37=15, :yp38='Y', :yp39='B', :yp40='Y', :yp41='X',
:yp42=NULL, :yp43='N', :yp44=NULL, :yp45=NULL, :yp46=NULL, :yp47=NULL,
:yp48=NULL, :yp49='Y', :yp50='Y', :yp51=0, :yp52=0, :yp53='N',
:yp54='N', :yp55=NULL, :yp56=NULL, :yp57='G')</td>
<td align="center">1</td>
<td align="center">0.00419</td>
<td align="center">0.00419</td>
<td align="center">0.00419</td>
<td align="center">0.00419</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`)</td>
<td align="center">1</td>
<td align="center">0.00222</td>
<td align="center">0.00222</td>
<td align="center">0.00222</td>
<td align="center">0.00222</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_questions`)</td>
<td align="center">1</td>
<td align="center">0.00163</td>
<td align="center">0.00163</td>
<td align="center">0.00163</td>
<td align="center">0.00163</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`)</td>
<td align="center">1</td>
<td align="center">0.00152</td>
<td align="center">0.00152</td>
<td align="center">0.00152</td>
<td align="center">0.00152</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`)</td>
<td align="center">1</td>
<td align="center">0.00150</td>
<td align="center">0.00150</td>
<td align="center">0.00150</td>
<td align="center">0.00150</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_groups`)</td>
<td align="center">1</td>
<td align="center">0.00132</td>
<td align="center">0.00132</td>
<td align="center">0.00132</td>
<td align="center">0.00132</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT
`defaultlanguage`.`surveyls_survey_id` AS `t1_c0`,
`defaultlanguage`.`surveyls_language` AS `t1_c1`,
`defaultlanguage`.`surveyls_title` AS `t1_c2`,
`defaultlanguage`.`surveyls_description` AS `t1_c3`,
`defaultlanguage`.`surveyls_welcometext` AS `t1_c4`,
`defaultlanguage`.`surveyls_endtext` AS `t1_c5`,
`defaultlanguage`.`surveyls_url` AS `t1_c6`,
`defaultlanguage`.`surveyls_urldescription` AS `t1_c7`,
`defaultlanguage`.`surveyls_email_invite_subj` AS `t1_c8`,
`defaultlanguage`.`surveyls_email_invite` AS `t1_c9`,
`defaultlanguage`.`surveyls_email_remind_subj` AS `t1_c10`,
`defaultlanguage`.`surveyls_email_remind` AS `t1_c11`,
`defaultlanguage`.`surveyls_email_register_subj` AS `t1_c12`,
`defaultlanguage`.`surveyls_email_register` AS `t1_c13`,
`defaultlanguage`.`surveyls_email_confirm_subj` AS `t1_c14`,
`defaultlanguage`.`surveyls_email_confirm` AS `t1_c15`,
`defaultlanguage`.`surveyls_dateformat` AS `t1_c16`,
`defaultlanguage`.`surveyls_attributecaptions` AS `t1_c17`,
`defaultlanguage`.`email_admin_notification_subj` AS `t1_c18`,
`defaultlanguage`.`email_admin_notification` AS `t1_c19`,
`defaultlanguage`.`email_admin_responses_subj` AS `t1_c20`,
`defaultlanguage`.`email_admin_responses` AS `t1_c21`,
`defaultlanguage`.`surveyls_numberformat` AS `t1_c22`,
`defaultlanguage`.`attachments` AS `t1_c23` FROM
`lime_surveys_languagesettings` `defaultlanguage` WHERE
(`defaultlanguage`.`surveyls_language`=:ypl0) AND
(`defaultlanguage`.`surveyls_survey_id`=:ypl1). Bound with :ypl0='en',
:ypl1='597566')</td>
<td align="center">2</td>
<td align="center">0.00128</td>
<td align="center">0.00064</td>
<td align="center">0.00064</td>
<td align="center">0.00064</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`)</td>
<td align="center">1</td>
<td align="center">0.00127</td>
<td align="center">0.00127</td>
<td align="center">0.00127</td>
<td align="center">0.00127</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT `t`.`sid` AS `t0_c0`,
`t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`active` AS
`t0_c3`, `t`.`expires` AS `t0_c4`, `t`.`startdate` AS `t0_c5`,
`t`.`adminemail` AS `t0_c6`, `t`.`anonymized` AS `t0_c7`, `t`.`faxto` AS
`t0_c8`, `t`.`format` AS `t0_c9`, `t`.`savetimings` AS `t0_c10`,
`t`.`template` AS `t0_c11`, `t`.`language` AS `t0_c12`,
`t`.`additional_languages` AS `t0_c13`, `t`.`datestamp` AS `t0_c14`,
`t`.`usecookie` AS `t0_c15`, `t`.`allowregister` AS `t0_c16`,
`t`.`allowsave` AS `t0_c17`, `t`.`autonumber_start` AS `t0_c18`,
`t`.`autoredirect` AS `t0_c19`, `t`.`allowprev` AS `t0_c20`,
`t`.`printanswers` AS `t0_c21`, `t`.`ipaddr` AS `t0_c22`, `t`.`refurl`
AS `t0_c23`, `t`.`datecreated` AS `t0_c24`, `t`.`publicstatistics` AS
`t0_c25`, `t`.`publicgraphs` AS `t0_c26`, `t`.`listpublic` AS `t0_c27`,
`t`.`htmlemail` AS `t0_c28`, `t`.`sendconfirmation` AS `t0_c29`,
`t`.`tokenanswerspersistence` AS `t0_c30`, `t`.`assessments` AS
`t0_c31`, `t`.`usecaptcha` AS `t0_c32`, `t`.`usetokens` AS `t0_c33`,
`t`.`bounce_email` AS `t0_c34`, `t`.`attributedescriptions` AS `t0_c35`,
`t`.`emailresponseto` AS `t0_c36`, `t`.`emailnotificationto` AS
`t0_c37`, `t`.`tokenlength` AS `t0_c38`, `t`.`showxquestions` AS
`t0_c39`, `t`.`showgroupinfo` AS `t0_c40`, `t`.`shownoanswer` AS
`t0_c41`, `t`.`showqnumcode` AS `t0_c42`, `t`.`bouncetime` AS `t0_c43`,
`t`.`bounceprocessing` AS `t0_c44`, `t`.`bounceaccounttype` AS `t0_c45`,
`t`.`bounceaccounthost` AS `t0_c46`, `t`.`bounceaccountpass` AS
`t0_c47`, `t`.`bounceaccountencryption` AS `t0_c48`,
`t`.`bounceaccountuser` AS `t0_c49`, `t`.`showwelcome` AS `t0_c50`,
`t`.`showprogress` AS `t0_c51`, `t`.`questionindex` AS `t0_c52`,
`t`.`navigationdelay` AS `t0_c53`, `t`.`nokeyboard` AS `t0_c54`,
`t`.`alloweditaftercompletion` AS `t0_c55`, `t`.`googleanalyticsstyle`
AS `t0_c56`, `t`.`googleanalyticsapikey` AS `t0_c57`,
`languagesettings`.`surveyls_survey_id` AS `t1_c0`,
`languagesettings`.`surveyls_language` AS `t1_c1`,
`languagesettings`.`surveyls_title` AS `t1_c2`,
`languagesettings`.`surveyls_description` AS `t1_c3`,
`languagesettings`.`surveyls_welcometext` AS `t1_c4`,
`languagesettings`.`surveyls_endtext` AS `t1_c5`,
`languagesettings`.`surveyls_url` AS `t1_c6`,
`languagesettings`.`surveyls_urldescription` AS `t1_c7`,
`languagesettings`.`surveyls_email_invite_subj` AS `t1_c8`,
`languagesettings`.`surveyls_email_invite` AS `t1_c9`,
`languagesettings`.`surveyls_email_remind_subj` AS `t1_c10`,
`languagesettings`.`surveyls_email_remind` AS `t1_c11`,
`languagesettings`.`surveyls_email_register_subj` AS `t1_c12`,
`languagesettings`.`surveyls_email_register` AS `t1_c13`,
`languagesettings`.`surveyls_email_confirm_subj` AS `t1_c14`,
`languagesettings`.`surveyls_email_confirm` AS `t1_c15`,
`languagesettings`.`surveyls_dateformat` AS `t1_c16`,
`languagesettings`.`surveyls_attributecaptions` AS `t1_c17`,
`languagesettings`.`email_admin_notification_subj` AS `t1_c18`,
`languagesettings`.`email_admin_notification` AS `t1_c19`,
`languagesettings`.`email_admin_responses_subj` AS `t1_c20`,
`languagesettings`.`email_admin_responses` AS `t1_c21`,
`languagesettings`.`surveyls_numberformat` AS `t1_c22`,
`languagesettings`.`attachments` AS `t1_c23` FROM `lime_surveys` `t`
LEFT OUTER JOIN `lime_surveys_languagesettings` `languagesettings` ON
(`languagesettings`.`surveyls_survey_id`=`t`.`sid`) WHERE (sid =
:surveyid) AND (surveyls_language=language). Bound with
:surveyid=597566)</td>
<td align="center">1</td>
<td align="center">0.00121</td>
<td align="center">0.00121</td>
<td align="center">0.00121</td>
<td align="center">0.00121</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=:yp0 LIMIT 1. Bound with :yp0=597566)</td>
<td align="center">2</td>
<td align="center">0.00113</td>
<td align="center">0.00057</td>
<td align="center">0.00048</td>
<td align="center">0.00065</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`)</td>
<td align="center">1</td>
<td align="center">0.00110</td>
<td align="center">0.00110</td>
<td align="center">0.00110</td>
<td align="center">0.00110</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=597566 LIMIT 1)</td>
<td align="center">2</td>
<td align="center">0.00103</td>
<td align="center">0.00051</td>
<td align="center">0.00050</td>
<td align="center">0.00052</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`)</td>
<td align="center">1</td>
<td align="center">0.00097</td>
<td align="center">0.00097</td>
<td align="center">0.00097</td>
<td align="center">0.00097</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`)</td>
<td align="center">1</td>
<td align="center">0.00093</td>
<td align="center">0.00093</td>
<td align="center">0.00093</td>
<td align="center">0.00093</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`)</td>
<td align="center">1</td>
<td align="center">0.00070</td>
<td align="center">0.00070</td>
<td align="center">0.00070</td>
<td align="center">0.00070</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`)</td>
<td align="center">1</td>
<td align="center">0.00067</td>
<td align="center">0.00067</td>
<td align="center">0.00067</td>
<td align="center">0.00067</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT `t`.`surveyls_survey_id` AS
`t0_c0`, `t`.`surveyls_language` AS `t0_c1`, `t`.`surveyls_title` AS
`t0_c2`, `t`.`surveyls_description` AS `t0_c3`,
`t`.`surveyls_welcometext` AS `t0_c4`, `t`.`surveyls_endtext` AS
`t0_c5`, `t`.`surveyls_url` AS `t0_c6`, `t`.`surveyls_urldescription` AS
`t0_c7`, `t`.`surveyls_email_invite_subj` AS `t0_c8`,
`t`.`surveyls_email_invite` AS `t0_c9`, `t`.`surveyls_email_remind_subj`
AS `t0_c10`, `t`.`surveyls_email_remind` AS `t0_c11`,
`t`.`surveyls_email_register_subj` AS `t0_c12`,
`t`.`surveyls_email_register` AS `t0_c13`,
`t`.`surveyls_email_confirm_subj` AS `t0_c14`,
`t`.`surveyls_email_confirm` AS `t0_c15`, `t`.`surveyls_dateformat` AS
`t0_c16`, `t`.`surveyls_attributecaptions` AS `t0_c17`,
`t`.`email_admin_notification_subj` AS `t0_c18`,
`t`.`email_admin_notification` AS `t0_c19`,
`t`.`email_admin_responses_subj` AS `t0_c20`,
`t`.`email_admin_responses` AS `t0_c21`, `t`.`surveyls_numberformat` AS
`t0_c22`, `t`.`attachments` AS `t0_c23`, `survey`.`sid` AS `t1_c0`,
`survey`.`owner_id` AS `t1_c1`, `survey`.`admin` AS `t1_c2`,
`survey`.`active` AS `t1_c3`, `survey`.`expires` AS `t1_c4`,
`survey`.`startdate` AS `t1_c5`, `survey`.`adminemail` AS `t1_c6`,
`survey`.`anonymized` AS `t1_c7`, `survey`.`faxto` AS `t1_c8`,
`survey`.`format` AS `t1_c9`, `survey`.`savetimings` AS `t1_c10`,
`survey`.`template` AS `t1_c11`, `survey`.`language` AS `t1_c12`,
`survey`.`additional_languages` AS `t1_c13`, `survey`.`datestamp` AS
`t1_c14`, `survey`.`usecookie` AS `t1_c15`, `survey`.`allowregister` AS
`t1_c16`, `survey`.`allowsave` AS `t1_c17`, `survey`.`autonumber_start`
AS `t1_c18`, `survey`.`autoredirect` AS `t1_c19`, `survey`.`allowprev`
AS `t1_c20`, `survey`.`printanswers` AS `t1_c21`, `survey`.`ipaddr` AS
`t1_c22`, `survey`.`refurl` AS `t1_c23`, `survey`.`datecreated` AS
`t1_c24`, `survey`.`publicstatistics` AS `t1_c25`,
`survey`.`publicgraphs` AS `t1_c26`, `survey`.`listpublic` AS `t1_c27`,
`survey`.`htmlemail` AS `t1_c28`, `survey`.`sendconfirmation` AS
`t1_c29`, `survey`.`tokenanswerspersistence` AS `t1_c30`,
`survey`.`assessments` AS `t1_c31`, `survey`.`usecaptcha` AS `t1_c32`,
`survey`.`usetokens` AS `t1_c33`, `survey`.`bounce_email` AS `t1_c34`,
`survey`.`attributedescriptions` AS `t1_c35`, `survey`.`emailresponseto`
AS `t1_c36`, `survey`.`emailnotificationto` AS `t1_c37`,
`survey`.`tokenlength` AS `t1_c38`, `survey`.`showxquestions` AS
`t1_c39`, `survey`.`showgroupinfo` AS `t1_c40`, `survey`.`shownoanswer`
AS `t1_c41`, `survey`.`showqnumcode` AS `t1_c42`, `survey`.`bouncetime`
AS `t1_c43`, `survey`.`bounceprocessing` AS `t1_c44`,
`survey`.`bounceaccounttype` AS `t1_c45`, `survey`.`bounceaccounthost`
AS `t1_c46`, `survey`.`bounceaccountpass` AS `t1_c47`,
`survey`.`bounceaccountencryption` AS `t1_c48`,
`survey`.`bounceaccountuser` AS `t1_c49`, `survey`.`showwelcome` AS
`t1_c50`, `survey`.`showprogress` AS `t1_c51`, `survey`.`questionindex`
AS `t1_c52`, `survey`.`navigationdelay` AS `t1_c53`,
`survey`.`nokeyboard` AS `t1_c54`, `survey`.`alloweditaftercompletion`
AS `t1_c55`, `survey`.`googleanalyticsstyle` AS `t1_c56`,
`survey`.`googleanalyticsapikey` AS `t1_c57` FROM
`lime_surveys_languagesettings` `t` LEFT OUTER JOIN `lime_surveys`
`survey` ON (t.surveyls_survey_id = survey.sid) WHERE
(`t`.`surveyls_survey_id`=597566 AND `t`.`surveyls_language`='en'))</td>
<td align="center">1</td>
<td align="center">0.00067</td>
<td align="center">0.00067</td>
<td align="center">0.00067</td>
<td align="center">0.00067</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_groups` `t` WHERE
`t`.`sid`=:yp0 AND `t`.`language`=:yp1. Bound with :yp0=597566,
:yp1='en')</td>
<td align="center">1</td>
<td align="center">0.00066</td>
<td align="center">0.00066</td>
<td align="center">0.00066</td>
<td align="center">0.00066</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT `t`.`sid` AS `t0_c0`,
`t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`active` AS
`t0_c3`, `t`.`expires` AS `t0_c4`, `t`.`startdate` AS `t0_c5`,
`t`.`adminemail` AS `t0_c6`, `t`.`anonymized` AS `t0_c7`, `t`.`faxto` AS
`t0_c8`, `t`.`format` AS `t0_c9`, `t`.`savetimings` AS `t0_c10`,
`t`.`template` AS `t0_c11`, `t`.`language` AS `t0_c12`,
`t`.`additional_languages` AS `t0_c13`, `t`.`datestamp` AS `t0_c14`,
`t`.`usecookie` AS `t0_c15`, `t`.`allowregister` AS `t0_c16`,
`t`.`allowsave` AS `t0_c17`, `t`.`autonumber_start` AS `t0_c18`,
`t`.`autoredirect` AS `t0_c19`, `t`.`allowprev` AS `t0_c20`,
`t`.`printanswers` AS `t0_c21`, `t`.`ipaddr` AS `t0_c22`, `t`.`refurl`
AS `t0_c23`, `t`.`datecreated` AS `t0_c24`, `t`.`publicstatistics` AS
`t0_c25`, `t`.`publicgraphs` AS `t0_c26`, `t`.`listpublic` AS `t0_c27`,
`t`.`htmlemail` AS `t0_c28`, `t`.`sendconfirmation` AS `t0_c29`,
`t`.`tokenanswerspersistence` AS `t0_c30`, `t`.`assessments` AS
`t0_c31`, `t`.`usecaptcha` AS `t0_c32`, `t`.`usetokens` AS `t0_c33`,
`t`.`bounce_email` AS `t0_c34`, `t`.`attributedescriptions` AS `t0_c35`,
`t`.`emailresponseto` AS `t0_c36`, `t`.`emailnotificationto` AS
`t0_c37`, `t`.`tokenlength` AS `t0_c38`, `t`.`showxquestions` AS
`t0_c39`, `t`.`showgroupinfo` AS `t0_c40`, `t`.`shownoanswer` AS
`t0_c41`, `t`.`showqnumcode` AS `t0_c42`, `t`.`bouncetime` AS `t0_c43`,
`t`.`bounceprocessing` AS `t0_c44`, `t`.`bounceaccounttype` AS `t0_c45`,
`t`.`bounceaccounthost` AS `t0_c46`, `t`.`bounceaccountpass` AS
`t0_c47`, `t`.`bounceaccountencryption` AS `t0_c48`,
`t`.`bounceaccountuser` AS `t0_c49`, `t`.`showwelcome` AS `t0_c50`,
`t`.`showprogress` AS `t0_c51`, `t`.`questionindex` AS `t0_c52`,
`t`.`navigationdelay` AS `t0_c53`, `t`.`nokeyboard` AS `t0_c54`,
`t`.`alloweditaftercompletion` AS `t0_c55`, `t`.`googleanalyticsstyle`
AS `t0_c56`, `t`.`googleanalyticsapikey` AS `t0_c57`,
`languagesettings`.`surveyls_survey_id` AS `t1_c0`,
`languagesettings`.`surveyls_language` AS `t1_c1`,
`languagesettings`.`surveyls_title` AS `t1_c2`,
`languagesettings`.`surveyls_description` AS `t1_c3`,
`languagesettings`.`surveyls_welcometext` AS `t1_c4`,
`languagesettings`.`surveyls_endtext` AS `t1_c5`,
`languagesettings`.`surveyls_url` AS `t1_c6`,
`languagesettings`.`surveyls_urldescription` AS `t1_c7`,
`languagesettings`.`surveyls_email_invite_subj` AS `t1_c8`,
`languagesettings`.`surveyls_email_invite` AS `t1_c9`,
`languagesettings`.`surveyls_email_remind_subj` AS `t1_c10`,
`languagesettings`.`surveyls_email_remind` AS `t1_c11`,
`languagesettings`.`surveyls_email_register_subj` AS `t1_c12`,
`languagesettings`.`surveyls_email_register` AS `t1_c13`,
`languagesettings`.`surveyls_email_confirm_subj` AS `t1_c14`,
`languagesettings`.`surveyls_email_confirm` AS `t1_c15`,
`languagesettings`.`surveyls_dateformat` AS `t1_c16`,
`languagesettings`.`surveyls_attributecaptions` AS `t1_c17`,
`languagesettings`.`email_admin_notification_subj` AS `t1_c18`,
`languagesettings`.`email_admin_notification` AS `t1_c19`,
`languagesettings`.`email_admin_responses_subj` AS `t1_c20`,
`languagesettings`.`email_admin_responses` AS `t1_c21`,
`languagesettings`.`surveyls_numberformat` AS `t1_c22`,
`languagesettings`.`attachments` AS `t1_c23` FROM `lime_surveys` `t`
LEFT OUTER JOIN `lime_surveys_languagesettings` `languagesettings` ON
(`languagesettings`.`surveyls_survey_id`=`t`.`sid`) WHERE (sid =
:surveyid) AND (surveyls_language=language). Bound with
:surveyid='597566')</td>
<td align="center">1</td>
<td align="center">0.00064</td>
<td align="center">0.00064</td>
<td align="center">0.00064</td>
<td align="center">0.00064</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`)</td>
<td align="center">1</td>
<td align="center">0.00064</td>
<td align="center">0.00064</td>
<td align="center">0.00064</td>
<td align="center">0.00064</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM lime_questions as
questions, lime_groups as groups WHERE questions.gid=groups.gid AND
questions.sid=597566 AND questions.language='en' AND
questions.parent_qid=0 AND groups.language='en' ORDER BY group_order,
question_order)</td>
<td align="center">1</td>
<td align="center">0.00063</td>
<td align="center">0.00063</td>
<td align="center">0.00063</td>
<td align="center">0.00063</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`)</td>
<td align="center">1</td>
<td align="center">0.00054</td>
<td align="center">0.00054</td>
<td align="center">0.00054</td>
<td align="center">0.00054</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_groups`)</td>
<td align="center">1</td>
<td align="center">0.00050</td>
<td align="center">0.00050</td>
<td align="center">0.00050</td>
<td align="center">0.00050</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_surveys` `t`)</td>
<td align="center">1</td>
<td align="center">0.00050</td>
<td align="center">0.00050</td>
<td align="center">0.00050</td>
<td align="center">0.00050</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_surveys` `t` WHERE active = 'Y')</td>
<td align="center">1</td>
<td align="center">0.00048</td>
<td align="center">0.00048</td>
<td align="center">0.00048</td>
<td align="center">0.00048</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t`
WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY
question_order ASC. Bound with :yp0=597566, :yp1='18', :yp2='en')</td>
<td align="center">1</td>
<td align="center">0.00048</td>
<td align="center">0.00048</td>
<td align="center">0.00048</td>
<td align="center">0.00048</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id,
a.specialtype, a.defaultvalue FROM lime_defaultvalues as a,
lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND
a.language = 'en' AND b.same_default=0 AND b.sid = 597566)</td>
<td align="center">1</td>
<td align="center">0.00047</td>
<td align="center">0.00047</td>
<td align="center">0.00047</td>
<td align="center">0.00047</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT COUNT(*) FROM `lime_users` `t`)</td>
<td align="center">1</td>
<td align="center">0.00044</td>
<td align="center">0.00044</td>
<td align="center">0.00044</td>
<td align="center">0.00044</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`)</td>
<td align="center">1</td>
<td align="center">0.00043</td>
<td align="center">0.00043</td>
<td align="center">0.00043</td>
<td align="center">0.00043</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`)</td>
<td align="center">1</td>
<td align="center">0.00043</td>
<td align="center">0.00043</td>
<td align="center">0.00043</td>
<td align="center">0.00043</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_permissions` `t`
WHERE `t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND
`t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1,
:yp3='superadmin')</td>
<td align="center">1</td>
<td align="center">0.00042</td>
<td align="center">0.00042</td>
<td align="center">0.00042</td>
<td align="center">0.00042</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.execute(CREATE TABLE `lime_survey_597566` (
`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`token` varchar(35) ,
`submitdate` datetime,
`lastpage` int(11),
`startlanguage` varchar(20) NOT NULL,
`startdate` datetime NOT NULL,
`datestamp` datetime NOT NULL,
`refurl` text,
`597566X18X516` varchar(1) ,
`597566X18X517` text,
`597566X19X518` varchar(1) ,
`597566X19X519` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci)</td>
<td align="center">1</td>
<td align="center">0.00042</td>
<td align="center">0.00042</td>
<td align="center">0.00042</td>
<td align="center">0.00042</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1)</td>
<td align="center">1</td>
<td align="center">0.00040</td>
<td align="center">0.00040</td>
<td align="center">0.00040</td>
<td align="center">0.00040</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t`
WHERE `t`.`sid`=:yp0 AND `t`.`gid`=:yp1 AND `t`.`language`=:yp2 ORDER BY
question_order ASC. Bound with :yp0=597566, :yp1='19', :yp2='en')</td>
<td align="center">1</td>
<td align="center">0.00040</td>
<td align="center">0.00040</td>
<td align="center">0.00040</td>
<td align="center">0.00040</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`)</td>
<td align="center">1</td>
<td align="center">0.00038</td>
<td align="center">0.00038</td>
<td align="center">0.00038</td>
<td align="center">0.00038</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_questions`)</td>
<td align="center">1</td>
<td align="center">0.00037</td>
<td align="center">0.00037</td>
<td align="center">0.00037</td>
<td align="center">0.00037</td>
</tr> <tr style="background:#F5F5F5">
<td>system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id,
a.specialtype, a.defaultvalue FROM lime_defaultvalues as a,
lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND
a.language = 'en' AND b.same_default=1 AND b.sid = 597566)</td>
<td align="center">1</td>
<td align="center">0.00036</td>
<td align="center">0.00036</td>
<td align="center">0.00036</td>
<td align="center">0.00036</td>
</tr> <tr style="background:#FFFFFF">
<td>system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`)</td>
<td align="center">1</td>
<td align="center">0.00036</td>
<td align="center">0.00036</td>
<td align="center">0.00036</td>
<td align="center">0.00036</td>
</tr></tbody></table>
<!-- end of profiling summary --></div><div aria-labelledby="ui-id-2" aria-describedby="ui-id-1" role="dialog" tabindex="-1" style="display: none; position: relative;" class="ui-dialog ui-widget ui-widget-content ui-corner-all ui-front ui-draggable ui-resizable"><div class="ui-dialog-titlebar ui-widget-header ui-corner-all ui-helper-clearfix"><span class="ui-dialog-title" id="ui-id-2"> </span><button class="ui-dialog-titlebar-close"></button></div><div class="ui-dialog-content ui-widget-content" id="ui-id-1"><iframe id="dialog" allowfullscreen=""></iframe></div><div style="z-index: 90;" class="ui-resizable-handle ui-resizable-n"></div><div style="z-index: 90;" class="ui-resizable-handle ui-resizable-e"></div><div style="z-index: 90;" class="ui-resizable-handle ui-resizable-s"></div><div style="z-index: 90;" class="ui-resizable-handle ui-resizable-w"></div><div style="z-index: 90;" class="ui-resizable-handle ui-resizable-se ui-icon ui-icon-gripsmall-diagonal-se"></div><div style="z-index: 90;" class="ui-resizable-handle ui-resizable-sw"></div><div style="z-index: 90;" class="ui-resizable-handle ui-resizable-ne"></div><div style="z-index: 90;" class="ui-resizable-handle ui-resizable-nw"></div></div></body></html>
<!-- start profiling summary --> | ||||
| Bug heat | 8 | ||||
| Complete LimeSurvey version number (& build) | 250plus | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Mozilla Firefox | ||||
| Database type & version | 5.1.73 | ||||
| Server OS (if known) | Linux | ||||
| Webserver software & version (if known) | Apache/2.2.15 (CentOS) | ||||
| PHP Version | 5.5.32 | ||||
 |
The survey response table could not be created. Usually this is caused by having too many (sub-)questions in your survey. Please try removing questions from your survey. |
 |
rittmannsd87, you only had 2 questions in this survey, is that correct? Please attach your survey to the bug report. You can also enable debug=2 in config.php and send us the error message when you activate the survey. |
 |
Yes, that is correct. I enabled debug = 2 and attatched the homepage of the error message above as a file |
|
|
Please see the requirements for LimeSurvey MySQL: MySQL 5.5.3 or later |
|
|
Did upgrading the database solve the problem? |
|
|
Closed due to missing feedback. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-03-21 16:57 | rittmannsd87 | New Issue | |
| 2016-03-21 16:57 | rittmannsd87 | Status | new => assigned |
| 2016-03-21 16:57 | rittmannsd87 | Assigned To | => c_schmitz |
| 2016-03-21 16:57 | rittmannsd87 | File Added: bugreport.JPG | |
| 2016-03-21 16:58 | rittmannsd87 | Issue Monitored: rittmannsd87 | |
| 2016-03-21 17:09 | c_schmitz | Note Added: 36687 | |
| 2016-03-21 17:09 | c_schmitz | Status | assigned => resolved |
| 2016-03-21 17:09 | c_schmitz | Fixed in Version | => 2.5 |
| 2016-03-21 17:09 | c_schmitz | Resolution | open => fixed |
| 2016-03-24 12:52 | ollehar | Assigned To | c_schmitz => |
| 2016-03-24 12:52 | ollehar | Note Added: 36780 | |
| 2016-03-24 12:52 | ollehar | Status | resolved => feedback |
| 2016-03-24 12:52 | ollehar | Resolution | fixed => reopened |
| 2016-03-24 12:59 | rittmannsd87 | File Added: error message.htm | |
| 2016-03-24 13:00 | rittmannsd87 | Note Added: 36781 | |
| 2016-03-24 13:00 | rittmannsd87 | Status | feedback => new |
| 2016-03-24 13:27 | ollehar | Note Added: 36782 | |
| 2016-03-29 13:07 | ollehar | Note Added: 36820 | |
| 2016-03-29 13:07 | ollehar | Assigned To | => ollehar |
| 2016-03-29 13:07 | ollehar | Status | new => feedback |
| 2016-05-10 16:05 | DenisChenu | Category | LimeSurvey Website => Survey design |
| 2016-05-10 16:39 | c_schmitz | Note Added: 38284 | |
| 2016-05-10 16:39 | c_schmitz | Status | feedback => closed |
| 2016-05-10 16:39 | c_schmitz | Resolution | reopened => unable to reproduce |
| 2019-11-01 17:25 | c_schmitz | Category | Survey design => Survey editing |
| 2021-08-03 04:56 | guest | Bug heat | 6 => 8 |
