View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
18547Bug reportsResponse browsingpublic2022-12-09 10:092023-06-19 16:43
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version3.28.x 
Summary18547: Response browsing on MSSQL server could go to 500 error
Description

SQL request can create 500 error when browse response

Steps To Reproduce

Steps to reproduce

Have a MS SQL server 15 (up to 11)
Create a big survey
Create lines with a lot of data
(but not more than 8094 (complex …))
Create more than 10 response
Navigate with nnext

Expected result

See next page

Actual result

500 error

TagsNo tags attached.
Attached Files
500 Internal Server Error.html (26,121 bytes)    


<!DOCTYPE html>
<html lang="en" dir="ltr" class="en dir-ltr  no-js " >

    <head>
        <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="viewport" content="width=device-width, initial-scale=1.0" />

        <meta name="viewport" content="width=device-width, initial-scale=1.0" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/ce77a0ef/jquery-ui.structure.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/1ddb3ca/css/font-awesome.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/9e12980e/bootstrap.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/9e12980e/yiistrap.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/93debb6f/css/bootstrap-switch.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/c033460d/css/bootstrap-datetimepicker.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/9c0b2355/roboto.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/9c0b2355/icomoon.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/3d1f3b46/build/lstutorial.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/df664ed3/build/adminbasics.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/6206c581/build.min/css/adminsidepanel.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/6d2346ca/css/lime-admin-colors.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/6d2346ca/css/statistics.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/8120f8da/css/select2.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/6e5b396f/select2-bootstrap.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/a48fa448/expressions.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/9c0b2355/noto.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/2d6cae14/survey.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/5747a15c/template-core.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/5747a15c/awesome-bootstrap-checkbox/awesome-bootstrap-checkbox.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/ed650976/css/ajaxify.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/ed650976/css/base.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/ed650976/css/errors.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/a105d03f/css/theme.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/a105d03f/css/custom.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/897c1383/browse.css" />
<script type='text/javascript'>window.debugState = {frontend : (0 === 1), backend : (0 === 1)};</script><script type="text/javascript" src="/tmp/assets/56ba56d4/jquery-3.5.1.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/56ba56d4/jquery-migrate-3.3.2.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/ce77a0ef/jquery-ui.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/df664ed3/build/adminbasics.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/6206c581/build.min/js/adminsidepanel.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/cf5abb80/js.cookie.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/9e12980e/bootstrap.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/9e12980e/plugins/bootstrapconfirm/bootstrapconfirm.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/63f93b67/moment-with-locales.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/c303cda3/build/lslog.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/ccfb9cae/min/pjax.combined.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/3aae877f/ckeditor.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/3aae877f/config.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/97809340/ckeditoradditions.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/6d2346ca/scripts/adapt.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/8120f8da/js/select2.full.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/8120f8da/js/i18n/en.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/ccfb9cae/pjax.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/2d6cae14/survey.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/5747a15c/template-core.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/ed650976/scripts/theme.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/ed650976/scripts/ajaxify.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/a105d03f/scripts/custom.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/49e32525/em_javascript.js" class="headScriptTag"></script>
<script type="text/javascript">
/*<![CDATA[*/

           LS.globalUserId = "1135";
/*]]>*/
</script>
<title>
                            500: Internal Server Error
                    </title>

                <meta name="generator" content="LimeSurvey http://www.limesurvey.org" />
                    <link rel="shortcut icon" href="/tmp/assets/e86135cf/favicon.ico" />
            </head>

    <body  class="oecd vanilla lang-en " marginwidth="0" marginheight="0" ><script type="text/javascript" src="/tmp/assets/93debb6f/js/bootstrap-switch.min.js"></script>
<script type="text/javascript" src="/tmp/assets/c033460d/js/bootstrap-datetimepicker.min.js"></script>
<script type="text/javascript" src="/tmp/assets/491bd867/listresponse.js"></script>
<script type="text/javascript" src="/tmp/assets/491bd867/tokens.js"></script>
<script type="text/javascript" src="/tmp/assets/6e34bc88/listActions.js"></script>
<script type="text/javascript">
/*<![CDATA[*/
LS.reloadAnyResponse = {"baseUrl":"\/index.php?r=survey\/index&sid=232399&newtest=Y&srid=","lang":{"launch":"Execute Survey"},"lsVersion":3.27}

    var gridId = 'responses-grid';

var LEMmode='group';
var LEMgseq=1;
ExprMgr_process_relevance_and_tailoring = function(evt_type,sgqa,type){
if (typeof LEM_initialized == 'undefined') {
LEM_initialized=true;
LEMsetTabIndexes();
}
if (evt_type == 'onchange' && (typeof last_sgqa !== 'undefined' && sgqa==last_sgqa) && (typeof last_evt_type !== 'undefined' && last_evt_type == 'TAB' && type != 'checkbox')) {
  last_evt_type='onchange';
  last_sgqa=sgqa;
  return;
}
last_evt_type = evt_type;
last_sgqa=sgqa;
  relChange737254=false;
  relChange725819=false;
  relChange722076=false;
  relChange722077=false;
  relChange722078=false;
  relChange722080=false;
  relChange738383=false;
  relChange722081=false;
  relChange722082=false;
  relChange722083=false;
  relChange737811=false;
  relChange741074=false;
  relChange741077=false;
  relChange737793=false;
  relChange744475=false;
  relChange737794=false;
  relChange741078=false;
  relChange737795=false;
  relChange737796=false;
  relChange737797=false;
  relChange737798=false;
  relChange737799=false;
  relChange737800=false;
  relChange727914=false;
  relChange727915=false;
  relChange722121=false;
  relChange727919=false;
  relChange727920=false;
  relChange727921=false;
  relChange722119=false;
  relChange722120=false;
  relChange741076=false;
  relChange737253=false;
  relChangeG1=false;
  LEMrel722076(sgqa);
  LEMrel722077(sgqa);
  LEMrel722078(sgqa);
  LEMrel722080(sgqa);
  LEMrel738383(sgqa);
  LEMrel722081(sgqa);
  LEMrel722082(sgqa);
  LEMrel722083(sgqa);
  LEMrel737811(sgqa);
  LEMrel741074(sgqa);
  LEMrel741077(sgqa);
  LEMrel737793(sgqa);
  LEMrel744475(sgqa);
  LEMrel737794(sgqa);
  LEMrel741078(sgqa);
  LEMrel737795(sgqa);
  LEMrel737796(sgqa);
  LEMrel737797(sgqa);
  LEMrel737798(sgqa);
  LEMrel737799(sgqa);
  LEMrel737800(sgqa);
  LEMrel727914(sgqa);
  LEMrel727915(sgqa);
  LEMrel722121(sgqa);
  LEMrel727919(sgqa);
  LEMrel727920(sgqa);
  LEMrel727921(sgqa);
  LEMrel722119(sgqa);
  LEMrel722120(sgqa);
  LEMrel741076(sgqa);

}
function LEMrel722076(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "N"))))
{
  $('#question722076').trigger('relevance:on');
  relChange722076=true;
  $('#relevance722076').val('1');
}
else {
  $('#question722076').trigger('relevance:off');
  if ($('#relevance722076').val()=='1') { relChange722076=true; }
  $('#relevance722076').val('0');
}
}

function LEMrel722077(sgqa){
  var UsesVars = ' java128766X28881X722076 java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X722076.NAOK')  == "Y") && (LEMval('128766X28881X725819.NAOK')  == "N"))))
{
  $('#question722077').trigger('relevance:on');
  relChange722077=true;
  $('#relevance722077').val('1');
}
else {
  $('#question722077').trigger('relevance:off');
  if ($('#relevance722077').val()=='1') { relChange722077=true; }
  $('#relevance722077').val('0');
}
}

function LEMrel722078(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question722078').trigger('relevance:on');
  if($('#question722078 div[id^="gmap_canvas"]').length > 0 || 
     $('#question722078 div[id^="map"]').length > 0)
  {
      resetMap(722078);
  }
  relChange722078=true;
  $('#relevance722078').val('1');
}
else {
  $('#question722078').trigger('relevance:off');
  if ($('#relevance722078').val()=='1') { relChange722078=true; }
  $('#relevance722078').val('0');
}
}

function LEMrel722080(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question722080').trigger('relevance:on');
  relChange722080=true;
  $('#relevance722080').val('1');
}
else {
  $('#question722080').trigger('relevance:off');
  if ($('#relevance722080').val()=='1') { relChange722080=true; }
  $('#relevance722080').val('0');
}
}

function LEMrel738383(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question738383').trigger('relevance:on');
  relChange738383=true;
  $('#relevance738383').val('1');
}
else {
  $('#question738383').trigger('relevance:off');
  if ($('#relevance738383').val()=='1') { relChange738383=true; }
  $('#relevance738383').val('0');
}
}

function LEMrel722081(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question722081').trigger('relevance:on');
  relChange722081=true;
  $('#relevance722081').val('1');
}
else {
  $('#question722081').trigger('relevance:off');
  if ($('#relevance722081').val()=='1') { relChange722081=true; }
  $('#relevance722081').val('0');
}
}

function LEMrel722082(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question722082').trigger('relevance:on');
  relChange722082=true;
  $('#relevance722082').val('1');
}
else {
  $('#question722082').trigger('relevance:off');
  if ($('#relevance722082').val()=='1') { relChange722082=true; }
  $('#relevance722082').val('0');
}
}

function LEMrel722083(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question722083').trigger('relevance:on');
  relChange722083=true;
  $('#relevance722083').val('1');
}
else {
  $('#question722083').trigger('relevance:off');
  if ($('#relevance722083').val()=='1') { relChange722083=true; }
  $('#relevance722083').val('0');
}
}

function LEMrel737811(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('NDSExistance.NAOK')  == "Y"))))
{
  $('#question737811').trigger('relevance:on');
  relChange737811=true;
  $('#relevance737811').val('1');
}
else {
  $('#question737811').trigger('relevance:off');
  if ($('#relevance737811').val()=='1') { relChange737811=true; }
  $('#relevance737811').val('0');
}
}

function LEMrel741074(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question741074').trigger('relevance:on');
  relChange741074=true;
  $('#relevance741074').val('1');
}
else {
  $('#question741074').trigger('relevance:off');
  if ($('#relevance741074').val()=='1') { relChange741074=true; }
  $('#relevance741074').val('0');
}
}

function LEMrel741077(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question741077').trigger('relevance:on');
  relChange741077=true;
  $('#relevance741077').val('1');
}
else {
  $('#question741077').trigger('relevance:off');
  if ($('#relevance741077').val()=='1') { relChange741077=true; }
  $('#relevance741077').val('0');
}
}

function LEMrel737793(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question737793').trigger('relevance:on');
  relChange737793=true;
  $('#relevance737793').val('1');
}
else {
  $('#question737793').trigger('relevance:off');
  if ($('#relevance737793').val()=='1') { relChange737793=true; }
  $('#relevance737793').val('0');
}
}

function LEMrel744475(sgqa){
  var UsesVars = ' java128766X28881X737793 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((LEMval('NDSBudget.NAOK')  == "B1" || LEMval('NDSBudget.NAOK')  == "B2"))
{
  $('#question744475').trigger('relevance:on');
  relChange744475=true;
  $('#relevance744475').val('1');
}
else {
  $('#question744475').trigger('relevance:off');
  if ($('#relevance744475').val()=='1') { relChange744475=true; }
  $('#relevance744475').val('0');
}
}

function LEMrel737794(sgqa){
  var UsesVars = ' java128766X28881X737793 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X737793.NAOK')  == "B1" || LEMval('128766X28881X737793.NAOK')  == "B2"))))
{
  $('#question737794').trigger('relevance:on');
  relChange737794=true;
  $('#relevance737794').val('1');
}
else {
  $('#question737794').trigger('relevance:off');
  if ($('#relevance737794').val()=='1') { relChange737794=true; }
  $('#relevance737794').val('0');
}
}

function LEMrel741078(sgqa){
  var UsesVars = ' java128766X28881X737793 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X737793.NAOK')  == "B1" || LEMval('128766X28881X737793.NAOK')  == "B2"))))
{
  $('#question741078').trigger('relevance:on');
  relChange741078=true;
  $('#relevance741078').val('1');
}
else {
  $('#question741078').trigger('relevance:off');
  if ($('#relevance741078').val()=='1') { relChange741078=true; }
  $('#relevance741078').val('0');
}
}

function LEMrel737795(sgqa){
  var UsesVars = ' java128766X28881X737793 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X737793.NAOK')  == "B3"))))
{
  $('#question737795').trigger('relevance:on');
  relChange737795=true;
  $('#relevance737795').val('1');
}
else {
  $('#question737795').trigger('relevance:off');
  if ($('#relevance737795').val()=='1') { relChange737795=true; }
  $('#relevance737795').val('0');
}
}

function LEMrel737796(sgqa){
  var UsesVars = ' java128766X28881X737793 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X737793.NAOK')  == "B1" || LEMval('128766X28881X737793.NAOK')  == "B2"))))
{
  $('#question737796').trigger('relevance:on');
  relChange737796=true;
  $('#relevance737796').val('1');
}
else {
  $('#question737796').trigger('relevance:off');
  if ($('#relevance737796').val()=='1') { relChange737796=true; }
  $('#relevance737796').val('0');
}
}

function LEMrel737797(sgqa){
  var UsesVars = ' java128766X28881X737796 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X737796.NAOK')  == "T2"))))
{
  $('#question737797').trigger('relevance:on');
  relChange737797=true;
  $('#relevance737797').val('1');
}
else {
  $('#question737797').trigger('relevance:off');
  if ($('#relevance737797').val()=='1') { relChange737797=true; }
  $('#relevance737797').val('0');
}
}

function LEMrel737798(sgqa){
  var UsesVars = ' java128766X28881X737793 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X737793.NAOK')  == "B1" || LEMval('128766X28881X737793.NAOK')  == "B2"))))
{
  $('#question737798').trigger('relevance:on');
  relChange737798=true;
  $('#relevance737798').val('1');
}
else {
  $('#question737798').trigger('relevance:off');
  if ($('#relevance737798').val()=='1') { relChange737798=true; }
  $('#relevance737798').val('0');
}
}

function LEMrel737799(sgqa){
  var UsesVars = ' java128766X28881X737798 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X737798.NAOK')  == "BA1"))))
{
  $('#question737799').trigger('relevance:on');
  relChange737799=true;
  $('#relevance737799').val('1');
}
else {
  $('#question737799').trigger('relevance:off');
  if ($('#relevance737799').val()=='1') { relChange737799=true; }
  $('#relevance737799').val('0');
}
}

function LEMrel737800(sgqa){
  var UsesVars = ' java128766X28881X737798 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X737798.NAOK')  == "BA2"))))
{
  $('#question737800').trigger('relevance:on');
  relChange737800=true;
  $('#relevance737800').val('1');
}
else {
  $('#question737800').trigger('relevance:off');
  if ($('#relevance737800').val()=='1') { relChange737800=true; }
  $('#relevance737800').val('0');
}
}

function LEMrel727914(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question727914').trigger('relevance:on');
  relChange727914=true;
  $('#relevance727914').val('1');
}
else {
  $('#question727914').trigger('relevance:off');
  if ($('#relevance727914').val()=='1') { relChange727914=true; }
  $('#relevance727914').val('0');
}
}

function LEMrel727915(sgqa){
  var UsesVars = ' java128766X28881X727914 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X727914.NAOK')  == "Y"))))
{
  $('#question727915').trigger('relevance:on');
  relChange727915=true;
  $('#relevance727915').val('1');
}
else {
  $('#question727915').trigger('relevance:off');
  if ($('#relevance727915').val()=='1') { relChange727915=true; }
  $('#relevance727915').val('0');
}
}

function LEMrel722121(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question722121').trigger('relevance:on');
  relChange722121=true;
  $('#relevance722121').val('1');
}
else {
  $('#question722121').trigger('relevance:off');
  if ($('#relevance722121').val()=='1') { relChange722121=true; }
  $('#relevance722121').val('0');
}
}

function LEMrel727919(sgqa){
  var UsesVars = ' java128766X28881X722121 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X722121.NAOK')  == "Y"))))
{
  $('#question727919').trigger('relevance:on');
  relChange727919=true;
  $('#relevance727919').val('1');
}
else {
  $('#question727919').trigger('relevance:off');
  if ($('#relevance727919').val()=='1') { relChange727919=true; }
  $('#relevance727919').val('0');
}
}

function LEMrel727920(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question727920').trigger('relevance:on');
  relChange727920=true;
  $('#relevance727920').val('1');
}
else {
  $('#question727920').trigger('relevance:off');
  if ($('#relevance727920').val()=='1') { relChange727920=true; }
  $('#relevance727920').val('0');
}
}

function LEMrel727921(sgqa){
  var UsesVars = ' java128766X28881X727920 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X727920.NAOK')  == "Y"))))
{
  $('#question727921').trigger('relevance:on');
  relChange727921=true;
  $('#relevance727921').val('1');
}
else {
  $('#question727921').trigger('relevance:off');
  if ($('#relevance727921').val()=='1') { relChange727921=true; }
  $('#relevance727921').val('0');
}
}

function LEMrel722119(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question722119').trigger('relevance:on');
  relChange722119=true;
  $('#relevance722119').val('1');
}
else {
  $('#question722119').trigger('relevance:off');
  if ($('#relevance722119').val()=='1') { relChange722119=true; }
  $('#relevance722119').val('0');
}
}

function LEMrel722120(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question722120').trigger('relevance:on');
  if($('#question722120 div[id^="gmap_canvas"]').length > 0 || 
     $('#question722120 div[id^="map"]').length > 0)
  {
      resetMap(722120);
  }
  relChange722120=true;
  $('#relevance722120').val('1');
}
else {
  $('#question722120').trigger('relevance:off');
  if ($('#relevance722120').val()=='1') { relChange722120=true; }
  $('#relevance722120').val('0');
}
}

function LEMrel741076(sgqa){
  var UsesVars = ' java128766X28881X725819 ';
  if (typeof sgqa !== 'undefined' && !LEMregexMatch('/ java' + sgqa + ' /', UsesVars)) {
  return;
 }

if ((((LEMval('128766X28881X725819.NAOK')  == "Y"))))
{
  $('#question741076').trigger('relevance:on');
  relChange741076=true;
  $('#relevance741076').val('1');
}
else {
  $('#question741076').trigger('relevance:off');
  if ($('#relevance741076').val()=='1') { relChange741076=true; }
  $('#relevance741076').val('0');
}
}
var LEMvarNameAttr = {
,
,
,
,
,
,
,
};

/*]]>*/
</script>

        <article id="block_error">
            <div>
                                    <h1>500: Internal Server Error</h1>
                                <h2>CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot create a row of size 8119 which is greater than the allowable maximum row size of 8094.</h2>
                <p>
                    An internal error occurred while the Web server was processing your request.
                </p>
                <p>
                                            Please contact OECD Surveys to report this problem.
                                    </p>
            </div>
        </article>
                    
<footer>
    <div class="row">
        <div class="copyright col-xs-12">
                        © Organisation for Economic Co-operation and Development
                    </div>
    </div>
</footer>

            <script type="text/javascript" src="/tmp/assets/3d1f3b46/build/lstutorial.min.js"></script>
<script type="text/javascript" src="/tmp/assets/a48fa448/expression.js"></script>
<script type="text/javascript" src="/tmp/assets/bd2349/browse_response.js"></script>
<script type="text/javascript">
/*<![CDATA[*/
jQuery('body').popover({'selector':'a\x5Brel\x3Dpopover\x5D'});
jQuery('body').tooltip({'selector':'a\x5Brel\x3Dtooltip\x5D'});

            try{ 
                triggerEmClassChange(); 
            } catch(e) {
                console.ls.warn('triggerEmClassChange could not be run. Is survey.js correctly loaded?');
            }

triggerEmRelevance();
jQuery(document).off('pjax:scriptcomplete.mainBottom').on('ready pjax:scriptcomplete.mainBottom', function() {
updateMandatoryErrorClass();
});
/*]]>*/
</script>
</body>
</html>
500 Internal Server Error.html (26,121 bytes)   
Capture d’écran du 2022-12-09 10-05-32.png (81,964 bytes)   
Capture d’écran du 2022-12-09 10-05-32.png (81,964 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)3.28.40
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionSQLServer (MS) 15.00.4261
Server OS (if known)windows
Webserver software & version (if known)IIS
PHP Version7.4.20

Relationships

Relationship GraphDependency Graph
related to 18102 closedDenisChenu Export Duplicate entries when export result 
related to 18420 closedDenisChenu Different behaviour on grid between MSSQL and MariaDB 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-12-09 10:12

developer   ~73043

The fix done for 5.X fix this issue (for some survey)
When export can be done : navigation can be OK.

What i found :

  • Sometimes : it happen for public user, but then data is not saved …
  • The VV export is always possible
  • But when CSV with long response is available : no reason to broke?

I send a PR today.
DenisChenu

DenisChenu

2022-12-15 16:10

developer   ~73141

https://github.com/yiisoft/yii/pull/4501
DenisChenu

DenisChenu

2023-04-19 18:23

developer   ~74552

Fixed now
DenisChenu

DenisChenu

2023-06-19 16:43

developer   ~75720

Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34854
DenisChenu

DenisChenu

2023-06-19 16:43

developer   ~75722

Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34855

Related Changesets

LimeSurvey: 3.x-LTS 71fb9849

2023-06-19 18:26

DenisChenu

Committer: GitHub


Details Diff		 Dev: Update to Yii 1.1.28 (#3208)

Dev: Update to Yii 1.1.28
Fixed issue 18547: Response browsing on MSSQL server could go to 500 error
Fixed issue 18420: Different behaviour on grid between MSSQL and MariaDB		 Affected Issues
18420, 18547
mod - framework/.htaccess Diff File
mod - framework/YiiBase.php Diff File
mod - framework/caching/CFileCache.php Diff File
mod - framework/caching/CRedisCache.php Diff File
mod - framework/cli/views/webapp/assets/git-gitignore Diff File
mod - framework/cli/views/webapp/hg-hgignore Diff File
mod - framework/cli/views/webapp/protected/.htaccess Diff File
mod - framework/cli/views/webapp/protected/runtime/git-gitignore Diff File
mod - framework/cli/views/webapp/protected/tests/WebTestCase.php Diff File
mod - framework/cli/views/webapp/protected/views/site/index.php Diff File
mod - framework/cli/views/webapp/protected/yiic Diff File
mod - framework/cli/views/webapp/protected/yiic.bat Diff File
mod - framework/cli/views/webapp/themes/classic/views/.htaccess Diff File
mod - framework/db/schema/CDbCriteria.php Diff File
mod - framework/db/schema/mssql/CMssqlCommandBuilder.php Diff File
mod - framework/db/schema/mssql/CMssqlPdoAdapter.php Diff File
mod - framework/db/schema/mssql/CMssqlSqlsrvPdoAdapter.php Diff File
mod - framework/db/schema/oci/COciSchema.php Diff File
mod - framework/db/schema/pgsql/CPgsqlSchema.php Diff File
mod - framework/i18n/CLocale.php Diff File
mod - framework/utils/CFormatter.php Diff File
mod - framework/validators/CDateValidator.php Diff File
mod - framework/validators/CStringValidator.php Diff File
mod - framework/vendors/TextHighlighter/Text/Highlighter.php Diff File
mod - framework/vendors/TextHighlighter/Text/Highlighter/Renderer.php Diff File
mod - framework/vendors/TextHighlighter/Text/README Diff File
mod - framework/vendors/TextHighlighter/Text/TODO Diff File
mod - framework/vendors/TextHighlighter/Text/abap.xml Diff File
mod - framework/vendors/TextHighlighter/Text/avrc.xml Diff File
mod - framework/vendors/TextHighlighter/Text/cpp.xml Diff File
mod - framework/vendors/TextHighlighter/Text/css.xml Diff File
mod - framework/vendors/TextHighlighter/Text/diff.xml Diff File
mod - framework/vendors/TextHighlighter/Text/dtd.xml Diff File
mod - framework/vendors/TextHighlighter/Text/generate Diff File
mod - framework/vendors/TextHighlighter/Text/generate.bat Diff File
mod - framework/vendors/TextHighlighter/Text/html.xml Diff File
mod - framework/vendors/TextHighlighter/Text/java.xml Diff File
mod - framework/vendors/TextHighlighter/Text/javascript.xml Diff File
mod - framework/vendors/TextHighlighter/Text/mysql.xml Diff File
mod - framework/vendors/TextHighlighter/Text/package.xml Diff File
mod - framework/vendors/TextHighlighter/Text/perl.xml Diff File
mod - framework/vendors/TextHighlighter/Text/php.xml Diff File
mod - framework/vendors/TextHighlighter/Text/python.xml Diff File
mod - framework/vendors/TextHighlighter/Text/ruby.xml Diff File
mod - framework/vendors/TextHighlighter/Text/sh.xml Diff File
mod - framework/vendors/TextHighlighter/Text/sql.xml Diff File
mod - framework/vendors/TextHighlighter/Text/vbscript.xml Diff File
mod - framework/vendors/TextHighlighter/Text/xml.xml Diff File
mod - framework/vendors/htmlpurifier/standalone/HTMLPurifier/ConfigSchema/schema/info.ini Diff File
rm - framework/vendors/htmlpurifier/standalone/HTMLPurifier/Language/classes/en-x-test.php Diff
rm - framework/vendors/htmlpurifier/standalone/HTMLPurifier/Language/messages/en-x-test.php Diff
rm - framework/vendors/htmlpurifier/standalone/HTMLPurifier/Language/messages/en-x-testmini.php Diff
rm - framework/vendors/jqueryui/MIT-LICENSE.txt Diff
mod - framework/web/CHttpRequest.php Diff File
mod - framework/web/auth/CWebUser.php Diff File
mod - framework/web/filters/CHttpCacheFilter.php Diff File
mod - framework/web/helpers/CHtml.php Diff File
rm - framework/web/js/source/jui/css/base/images/ui-bg_flat_0_aaaaaa_40x100.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_flat_75_ffffff_40x100.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_glass_55_fbf9ee_1x400.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_glass_65_ffffff_1x400.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_glass_75_dadada_1x400.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_glass_75_e6e6e6_1x400.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_glass_95_fef1ec_1x400.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_highlight-soft_75_cccccc_1x100.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-icons_222222_256x240.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-icons_2e83ff_256x240.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-icons_454545_256x240.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-icons_888888_256x240.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-icons_cd0a0a_256x240.png Diff
mod - framework/web/js/source/jui/css/smoothness/images/ui-bg_glass_55_fbf9ee_1x400.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-bg_glass_75_dadada_1x400.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-bg_glass_75_e6e6e6_1x400.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-bg_glass_95_fef1ec_1x400.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-bg_highlight-soft_75_cccccc_1x100.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-icons_222222_256x240.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-icons_2e83ff_256x240.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-icons_454545_256x240.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-icons_888888_256x240.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-icons_cd0a0a_256x240.png Diff File
mod - framework/web/widgets/CStarRating.php Diff File
mod - framework/web/widgets/captcha/SpicyRice.md Diff File
mod - framework/yiic Diff File
mod - framework/yiic.bat Diff File
mod - framework/yiilite.php Diff File

LimeSurvey: 3.x-LTS 71fb9849

2023-06-19 18:26

DenisChenu

Committer: GitHub


Details Diff		 Dev: Update to Yii 1.1.28 (#3208)

Dev: Update to Yii 1.1.28
Fixed issue 18547: Response browsing on MSSQL server could go to 500 error
Fixed issue 18420: Different behaviour on grid between MSSQL and MariaDB		 Affected Issues
18420, 18547
mod - framework/.htaccess Diff File
mod - framework/YiiBase.php Diff File
mod - framework/caching/CFileCache.php Diff File
mod - framework/caching/CRedisCache.php Diff File
mod - framework/cli/views/webapp/assets/git-gitignore Diff File
mod - framework/cli/views/webapp/hg-hgignore Diff File
mod - framework/cli/views/webapp/protected/.htaccess Diff File
mod - framework/cli/views/webapp/protected/runtime/git-gitignore Diff File
mod - framework/cli/views/webapp/protected/tests/WebTestCase.php Diff File
mod - framework/cli/views/webapp/protected/views/site/index.php Diff File
mod - framework/cli/views/webapp/protected/yiic Diff File
mod - framework/cli/views/webapp/protected/yiic.bat Diff File
mod - framework/cli/views/webapp/themes/classic/views/.htaccess Diff File
mod - framework/db/schema/CDbCriteria.php Diff File
mod - framework/db/schema/mssql/CMssqlCommandBuilder.php Diff File
mod - framework/db/schema/mssql/CMssqlPdoAdapter.php Diff File
mod - framework/db/schema/mssql/CMssqlSqlsrvPdoAdapter.php Diff File
mod - framework/db/schema/oci/COciSchema.php Diff File
mod - framework/db/schema/pgsql/CPgsqlSchema.php Diff File
mod - framework/i18n/CLocale.php Diff File
mod - framework/utils/CFormatter.php Diff File
mod - framework/validators/CDateValidator.php Diff File
mod - framework/validators/CStringValidator.php Diff File
mod - framework/vendors/TextHighlighter/Text/Highlighter.php Diff File
mod - framework/vendors/TextHighlighter/Text/Highlighter/Renderer.php Diff File
mod - framework/vendors/TextHighlighter/Text/README Diff File
mod - framework/vendors/TextHighlighter/Text/TODO Diff File
mod - framework/vendors/TextHighlighter/Text/abap.xml Diff File
mod - framework/vendors/TextHighlighter/Text/avrc.xml Diff File
mod - framework/vendors/TextHighlighter/Text/cpp.xml Diff File
mod - framework/vendors/TextHighlighter/Text/css.xml Diff File
mod - framework/vendors/TextHighlighter/Text/diff.xml Diff File
mod - framework/vendors/TextHighlighter/Text/dtd.xml Diff File
mod - framework/vendors/TextHighlighter/Text/generate Diff File
mod - framework/vendors/TextHighlighter/Text/generate.bat Diff File
mod - framework/vendors/TextHighlighter/Text/html.xml Diff File
mod - framework/vendors/TextHighlighter/Text/java.xml Diff File
mod - framework/vendors/TextHighlighter/Text/javascript.xml Diff File
mod - framework/vendors/TextHighlighter/Text/mysql.xml Diff File
mod - framework/vendors/TextHighlighter/Text/package.xml Diff File
mod - framework/vendors/TextHighlighter/Text/perl.xml Diff File
mod - framework/vendors/TextHighlighter/Text/php.xml Diff File
mod - framework/vendors/TextHighlighter/Text/python.xml Diff File
mod - framework/vendors/TextHighlighter/Text/ruby.xml Diff File
mod - framework/vendors/TextHighlighter/Text/sh.xml Diff File
mod - framework/vendors/TextHighlighter/Text/sql.xml Diff File
mod - framework/vendors/TextHighlighter/Text/vbscript.xml Diff File
mod - framework/vendors/TextHighlighter/Text/xml.xml Diff File
mod - framework/vendors/htmlpurifier/standalone/HTMLPurifier/ConfigSchema/schema/info.ini Diff File
rm - framework/vendors/htmlpurifier/standalone/HTMLPurifier/Language/classes/en-x-test.php Diff
rm - framework/vendors/htmlpurifier/standalone/HTMLPurifier/Language/messages/en-x-test.php Diff
rm - framework/vendors/htmlpurifier/standalone/HTMLPurifier/Language/messages/en-x-testmini.php Diff
rm - framework/vendors/jqueryui/MIT-LICENSE.txt Diff
mod - framework/web/CHttpRequest.php Diff File
mod - framework/web/auth/CWebUser.php Diff File
mod - framework/web/filters/CHttpCacheFilter.php Diff File
mod - framework/web/helpers/CHtml.php Diff File
rm - framework/web/js/source/jui/css/base/images/ui-bg_flat_0_aaaaaa_40x100.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_flat_75_ffffff_40x100.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_glass_55_fbf9ee_1x400.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_glass_65_ffffff_1x400.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_glass_75_dadada_1x400.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_glass_75_e6e6e6_1x400.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_glass_95_fef1ec_1x400.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-bg_highlight-soft_75_cccccc_1x100.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-icons_222222_256x240.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-icons_2e83ff_256x240.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-icons_454545_256x240.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-icons_888888_256x240.png Diff
rm - framework/web/js/source/jui/css/base/images/ui-icons_cd0a0a_256x240.png Diff
mod - framework/web/js/source/jui/css/smoothness/images/ui-bg_glass_55_fbf9ee_1x400.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-bg_glass_75_dadada_1x400.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-bg_glass_75_e6e6e6_1x400.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-bg_glass_95_fef1ec_1x400.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-bg_highlight-soft_75_cccccc_1x100.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-icons_222222_256x240.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-icons_2e83ff_256x240.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-icons_454545_256x240.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-icons_888888_256x240.png Diff File
mod - framework/web/js/source/jui/css/smoothness/images/ui-icons_cd0a0a_256x240.png Diff File
mod - framework/web/widgets/CStarRating.php Diff File
mod - framework/web/widgets/captcha/SpicyRice.md Diff File
mod - framework/yiic Diff File
mod - framework/yiic.bat Diff File
mod - framework/yiilite.php Diff File

Issue History

Date Modified Username Field Change
2022-12-09 10:09 DenisChenu New Issue
2022-12-09 10:09 DenisChenu File Added: 500 Internal Server Error.html
2022-12-09 10:09 DenisChenu File Added: Capture d’écran du 2022-12-09 10-05-32.png
2022-12-09 10:09 DenisChenu Assigned To => DenisChenu
2022-12-09 10:09 DenisChenu Status new => assigned
2022-12-09 10:10 DenisChenu Relationship added related to 18102
2022-12-09 10:10 DenisChenu Relationship added related to 18420
2022-12-09 10:12 DenisChenu Note Added: 73043
2022-12-09 10:12 DenisChenu Bug heat 0 => 2
2022-12-12 18:31 DenisChenu Assigned To DenisChenu =>
2022-12-12 18:31 DenisChenu Status assigned => ready for code review
2022-12-15 16:09 DenisChenu Assigned To => DenisChenu
2022-12-15 16:09 DenisChenu Status ready for code review => confirmed
2022-12-15 16:10 DenisChenu Note Added: 73141
2022-12-15 16:10 DenisChenu Status confirmed => acknowledged
2023-04-19 18:23 DenisChenu Status acknowledged => closed
2023-04-19 18:23 DenisChenu Resolution open => fixed
2023-04-19 18:23 DenisChenu Note Added: 74552
2023-06-19 16:43 DenisChenu Changeset attached => LimeSurvey 3.x-LTS 71fb9849
2023-06-19 16:43 DenisChenu Note Added: 75720
2023-06-19 16:43 DenisChenu Changeset attached => LimeSurvey 3.x-LTS 71fb9849
2023-06-19 16:43 DenisChenu Note Added: 75722