View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
20579Bug reportsStatisticspublic2026-06-29 11:002026-07-02 12:23
ReporterL.Guldi Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version7.0.x 
Summary20579: Statistics can't be exported
Description

When trying to export a surveys statistics, while having the output option 'Show text responses inline: on', 'View summary of all available fields: on' and 'Show graphs: on' selected, the statistics can't be esported as an excel file.
The file will be created but it will show an error in the actual file and no data. Furthermore, when using HTML for the output, the answers to the text responses won't be displayed.

Steps To Reproduce

Steps to reproduce

Open any survey that contains text responses and head to 'statistics'.
Select 'Show text responses inline: on' and export the data as an Excel file.

Expected result

An Excel file containing the statistics data of the survey.

Actual result

Fileformat and filextension mismatch
Problems while loading due to missing files
An Excel file with an Error 500: internal Servererror - Databaseerror message.

TagsNo tags attached.
Attached Files
Error500.png (26,276 bytes)   
Error500.png (26,276 bytes)   
Fileformat.png (9,604 bytes)   
Fileformat.png (9,604 bytes)   
MissingFiles.png (12,520 bytes)   
MissingFiles.png (12,520 bytes)   
survey_archive_498594.lsa (3,933 bytes)
Bug heat4
Complete LimeSurvey version number (& build)Version 7.0.5+260623
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome
Database type & versionmariadb-10.11.18
Server OS (if known)Linux Gentoo
Webserver software & version (if known)apache-2.4.68
PHP Versionphp-8.3

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2026-06-29 11:01

developer   ~85097

Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here.
L.Guldi

L.Guldi

2026-06-29 13:22

reporter   ~85100

It doesn't seem like limesurvey produces an errormessage here.
I've activated the debugging in the config.php and even enabled E_ALL logging in the php configuration but there were no messages logged.
DenisChenu

DenisChenu

2026-06-29 14:43

developer   ~85103

The «« exceml»» produced file ?
L.Guldi

L.Guldi

2026-06-30 08:35

reporter   ~85115

Here's the file thats produced.

statistic-survey498594.xls (13,558 bytes)    


<!DOCTYPE html>
<html lang="de" dir="ltr"
      class="de dir-ltr  no-js " 
      xmlns="http://www.w3.org/1999/html">

<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/c8798c9e/jquery-ui.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/aebf116d/css/font-awesome.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/9ed04ece/ibm-sans.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/6f4d3d10/ibm-serif.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/1b7999b/remixicon.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/a217979b/build/tempus-dominus.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/a32eae2f/roboto.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/a32eae2f/icomoon.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/1f0d8a81/css/select2.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/6c82aa06/select2-bootstrap-5-theme.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/e306ec4/build/lstutorial.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/5f8de21e/css/sea_green.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/2c325e17/build.min/css/adminsidepanel.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/ba325f36/editorModal.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/f646df82/survey.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/28c1bfec/build/embeddables.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/86ac9bd6/template-core.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/86ac9bd6/awesome-bootstrap-checkbox/awesome-bootstrap-checkbox.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/df7bc50c/css/bootstrap_5.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/a32eae2f/noto.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/b66c6719/css/base.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/b66c6719/css/noTablesOnMobile.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/b66c6719/css/errors.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/2e4d86c1/css/variations/flatly.min.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/2e4d86c1/css/theme.css" />
<link rel="stylesheet" type="text/css" href="/tmp/assets/2e4d86c1/css/custom.css" />
<script type='text/javascript'>window.debugState = {frontend : (0 === 1), backend : (0 === 1)};</script><script type="text/javascript" src="/tmp/assets/27b5cd1/jquery.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/150ca47c/jquery-migrate.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/c8798c9e/jquery-ui.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/2c325e17/build.min/js/adminsidepanel.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/fa360d7e/js.cookie.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/40d31a0d/moment-with-locales.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/a217979b/build/popper-tempus.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/a217979b/datepickerInit.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/12eee3fd/build/lslog.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/fe35f874/min/pjax.combined.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/1f0d8a81/js/select2.full.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/assets/packages/ckeditor/ckeditor.js" class="headScriptTag"></script>
<script type="text/javascript" src="/assets/packages/ckeditor/config.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/faccf151/ckeditoradditions.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/df7bc50c/js/bootstrap_5.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/c8980c87/activateEditor.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/548a5901/em_javascript.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/fe35f874/pjax.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/f646df82/survey.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/86ac9bd6/template-core.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/b66c6719/scripts/theme.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/b66c6719/scripts/ajaxify.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/b66c6719/scripts/custom.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/2a3f2294/json2.min.js" class="headScriptTag"></script>
<script type="text/javascript" src="/tmp/assets/5f6665e0/createpdf_worker.js" class="headScriptTag"></script>
<script type="text/javascript">
/*<![CDATA[*/

           window.LS = window.LS || {}; window.LS.globalUserId = "1";
/*]]>*/
</script>
<title>
                    500: Interner Serverfehler
            </title>

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

<body class="bootswatch vanilla flatly lang-de " marginwidth="0"
      marginheight="0" ><script type="text/javascript" src="/tmp/assets/414d62e6/build/adminbasics.min.js"></script>
<script type="text/javascript" src="/tmp/assets/3bbdaf82/js/modaleditor.js"></script>
<script type="text/javascript" src="/tmp/assets/9bdf332e/dist/jszip.min.js"></script>
<script type="text/javascript" src="/tmp/assets/9bdf332e/vendor/FileSaver.js"></script>
<script type="text/javascript" src="/tmp/assets/d45cafa2/decimal.js"></script>
<script type="text/javascript" src="/tmp/assets/240267d8/decimalcustom.js"></script>
<script type="text/javascript" src="/tmp/assets/5f6665e0/statistics.js"></script>
<script type="text/javascript" id="lemscripts">
/*<![CDATA[*/
var LEMmode='group';
var LEMgseq='';
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;
}
if (evt_type == 'updated'  && (typeof last_sgqa !== 'undefined' && sgqa==last_sgqa)) {
  last_evt_type='updated';
  last_sgqa=sgqa;
  return;
}
last_evt_type = evt_type;
last_sgqa=sgqa;

}

/*]]>*/
</script>

<div class="container">
    <div id="error-card" class="card w-75 mt-6 mb-0 mx-auto">
        <div class="card-body">
            <h2 class="card-title">
                                    500: Interner Serverfehler
                                 - Datenbankfehler!
            </h2>
            <hr>
            <div class="card-text">Ein interner Fehler ist aufgetreten, während der Webserver Ihre Anfrage bearbeitet hat.</div>
                            Bitte kontaktieren Sie Umfragen Stadt Heilbronn, um dieses Problem zu melden.
                                </div>

    </div>
</div>
    
<script type="text/javascript" src="/tmp/assets/e306ec4/build/lstutorial.min.js"></script>
<script type="text/javascript" src="/tmp/assets/28c1bfec/build/embeddables.min.js"></script>
<script type="text/javascript">
/*<![CDATA[*/

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

triggerEmRelevance();
jQuery(function($) {

            // First, remove all existing modals
            $('div[id="feature-preview-modal"]').remove();
            
            // Add the modal only once, with a flag to prevent duplication
            if (!window.featurePreviewModalAdded) {
                $('body').append("<!-- Modal to activate\/deactivate the react question editor -->\n<div id=\"activate_editor\" class=\"modal fade\" role=\"dialog\">\n    <div class=\"modal-dialog modal-xl\">\n        <!-- Modal content-->\n        <div class=\"modal-content\">\n            <div class=\"modal-body position-relative p-0\">\n                <button type=\"button\"\n                        class=\"btn-close position-absolute top-0 end-0 m-3\"\n                        data-bs-dismiss=\"modal\" aria-label=\"Close\"\n                        style=\"z-index: 1050;\"><\/button> <!-- TODO inline style-->\n                <input type=\"hidden\" id=\"saveUrl\" name=\"saveUrl\"\n                       value=\"\/plugins\/direct\/plugin\/ReactEditor\/function\/saveActivateDeactivate\">\n                <input type=\"hidden\" id=\"successMsgFeatureOptin\"\n                       value=\"Der neue Editor wurde erfolgreich aktiviert.\">\n                <input type=\"hidden\" id=\"successMsgFeatureOptout\"\n                       value=\"Der neue Editor wurde erfolgreich deaktiviert.\">\n                <input type=\"hidden\" id=\"errorOnSave\"\n                       value=\"Beim Speichern ist ein Fehler aufgetreten.\">\n                <div class=\"card pt-3 pb-5\">\n                    <div class=\"row g-0\">\n                        <div class=\"col-md-5\">\n                            <div class=\"card-body ps-4 pe-4\">\n                                <h1 class=\"card-title reg-24 mb-16\">\n                                    Willkommen zum neuen LimeSurvey                                <\/h1>\n                                <p class=\"card-text reg-14 mb-16\">Mit dem LimeSurvey Editor k\u00f6nnen Sie Umfragen im Handumdrehen erstellen. Er kombiniert intuitives Design mit leistungsstarken Funktionen f\u00fcr ein schnelleres und intelligenteres Umfrageerlebnis.                                    <br><br>\n                                    <a class=\"link-info\" href=\"https:\/\/www.limesurvey.org\" target=\"_blank\">Entdecken Sie jetzt<\/a>, was der neue Editor alles kann!                                <\/p>\n                                <div class=\"row mb-16\">\n                                    <label class=\"label-s mb-1\" for='editor-switch-btn'>Editorversion<\/label>\n                                    <div class=\"lime-toggle-btn-group isSecondary\">\n                                    \n<div class=\"btn-group \" data-bs-toggle=\"tooltip\"\n    id=\"editor-switch-btn\" role=\"group\"\n            >\n                <input type=\"radio\" class=\"btn-check\" name=\"editor-switch-btn\" id=\"editor-switch-btn_1\" autocomplete=\"off\"\n            value=\"0\"  >\n        <label class=\"btn btn-outline-secondary\" for=\"editor-switch-btn_1\">\n                        Klassisch        <\/label>\n                    <input type=\"radio\" class=\"btn-check\" name=\"editor-switch-btn\" id=\"editor-switch-btn_2\" autocomplete=\"off\"\n            value=\"1\" checked >\n        <label class=\"btn btn-outline-secondary\" for=\"editor-switch-btn_2\">\n                        Neu        <\/label>\n            <\/div>\n                                    <\/div>\n                                        <br>\n                                <\/div>\n                                                                <div class=\"hint-text-box p-3\">\n                                    <p class=\"hint-text med-14-c mb-1\">\n                                        Gut zu wissen...                                    <\/p>\n                                    <p class=\"hint-text reg-12\">\n                                        Sie k\u00f6nnen jederzeit in Ihren Kontoeinstellungen zwischen dem klassischen und dem neuen Editor wechseln. Wir empfehlen Ihnen, die neue Version auszuprobieren \u2013 sie ist jetzt aus der Beta-Phase und wir freuen uns \u00fcber Ihr Feedback!                                    <\/p>\n                                <\/div>\n                                                            <\/div>\n                        <\/div>\n                        <div class=\"col-md-7\">\n                            <img src=\"\/assets\/images\/new_editor_image_small.png\"\n                                 class=\"img-fluid editor-preview\"\n                                 alt=\"Editor preview\">\n                        <\/div>\n                    <\/div>\n                <\/div>\n            <\/div>\n        <\/div>\n    <\/div>\n<\/div>\n");
                window.featurePreviewModalAdded = true;
                
                
            }
            
});
jQuery(document).off('pjax:scriptcomplete.mainBottom').on('ready pjax:scriptcomplete.mainBottom', function() {
updateMandatoryErrorClass();
});
/*]]>*/
</script>
</body>
</html>
statistic-survey498594.xls (13,558 bytes)   
DenisChenu

DenisChenu

2026-06-30 10:37

developer   ~85124

Arg !
Right, we disable error to produce excel file :(
L.Guldi

L.Guldi

2026-06-30 15:34

reporter   ~85130

We managed to get the error in the excel file :)

statistic-survey498594-2.xls (10,117 bytes)    
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta name="Excel Workbook Frameset">
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 15">
<link rel=File-List href="statistic-survey498594%20(1)-Dateien/filelist.xml">
<title>CDbException</title>
<![if !supportTabStrip]>
<link id="shLink" href="statistic-survey498594%20(1)-Dateien/sheet001.htm">

<link id="shLink">

<script language="JavaScript">
<!--
 var c_lTabs=1;

 var c_rgszSh=new Array(c_lTabs);
 c_rgszSh[0] = "statistic-survey498594 (1)";



 var c_rgszClr=new Array(8);
 c_rgszClr[0]="window";
 c_rgszClr[1]="buttonface";
 c_rgszClr[2]="windowframe";
 c_rgszClr[3]="windowtext";
 c_rgszClr[4]="threedlightshadow";
 c_rgszClr[5]="threedhighlight";
 c_rgszClr[6]="threeddarkshadow";
 c_rgszClr[7]="threedshadow";

 var g_iShCur;
 var g_rglTabX=new Array(c_lTabs);

function fnGetIEVer()
{
 var ua=window.navigator.userAgent
 var msie=ua.indexOf("MSIE")
 if (msie>0 && window.navigator.platform=="Win32")
  return parseInt(ua.substring(msie+5,ua.indexOf(".", msie)));
 else
  return 0;
}

function fnBuildFrameset()
{
 var szHTML="<frameset rows=\"*,18\" border=0 width=0 frameborder=no framespacing=0>"+
  "<frame src=\""+document.all.item("shLink")[0].href+"\" name=\"frSheet\" noresize>"+
  "<frameset cols=\"54,*\" border=0 width=0 frameborder=no framespacing=0>"+
  "<frame src=\"\" name=\"frScroll\" marginwidth=0 marginheight=0 scrolling=no>"+
  "<frame src=\"\" name=\"frTabs\" marginwidth=0 marginheight=0 scrolling=no>"+
  "</frameset></frameset><plaintext>";

 with (document) {
  open("text/html","replace");
  write(szHTML);
  close();
 }

 fnBuildTabStrip();
}

function fnBuildTabStrip()
{
 var szHTML=
  "<html><head><style>.clScroll {font:8pt Courier New;color:"+c_rgszClr[6]+";cursor:default;line-height:10pt;}"+
  ".clScroll2 {font:10pt Arial;color:"+c_rgszClr[6]+";cursor:default;line-height:11pt;}</style></head>"+
  "<body onclick=\"event.returnValue=false;\" ondragstart=\"event.returnValue=false;\" onselectstart=\"event.returnValue=false;\" bgcolor="+c_rgszClr[4]+" topmargin=0 leftmargin=0><table cellpadding=0 cellspacing=0 width=100%>"+
  "<tr><td colspan=6 height=1 bgcolor="+c_rgszClr[2]+"></td></tr>"+
  "<tr><td style=\"font:1pt\">&nbsp;<td>"+
  "<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(0);\" onmouseout=\"parent.fnMouseOutScroll(0);\"><a>&#171;</a></td>"+
  "<td valign=top id=tdScroll class=\"clScroll2\" onclick=\"parent.fnScrollTabs(0);\" ondblclick=\"parent.fnScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(1);\" onmouseout=\"parent.fnMouseOutScroll(1);\"><a>&lt</a></td>"+
  "<td valign=top id=tdScroll class=\"clScroll2\" onclick=\"parent.fnScrollTabs(1);\" ondblclick=\"parent.fnScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(2);\" onmouseout=\"parent.fnMouseOutScroll(2);\"><a>&gt</a></td>"+
  "<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(3);\" onmouseout=\"parent.fnMouseOutScroll(3);\"><a>&#187;</a></td>"+
  "<td style=\"font:1pt\">&nbsp;<td></tr></table></body></html>";

 with (frames['frScroll'].document) {
  open("text/html","replace");
  write(szHTML);
  close();
 }

 szHTML =
  "<html><head>"+
  "<style>A:link,A:visited,A:active {text-decoration:none;"+"color:"+c_rgszClr[3]+";}"+
  ".clTab {cursor:hand;background:"+c_rgszClr[1]+";font:9pt Arial;padding-left:3px;padding-right:3px;text-align:center;}"+
  ".clBorder {background:"+c_rgszClr[2]+";font:1pt;}"+
  "</style></head><body onload=\"parent.fnInit();\" onselectstart=\"event.returnValue=false;\" ondragstart=\"event.returnValue=false;\" bgcolor="+c_rgszClr[4]+
  " topmargin=0 leftmargin=0><table id=tbTabs cellpadding=0 cellspacing=0>";

 var iCellCount=(c_lTabs+1)*2;

 var i;
 for (i=0;i<iCellCount;i+=2)
  szHTML+="<col width=1><col>";

 var iRow;
 for (iRow=0;iRow<6;iRow++) {

  szHTML+="<tr>";

  if (iRow==5)
   szHTML+="<td colspan="+iCellCount+"></td>";
  else {
   if (iRow==0) {
    for(i=0;i<iCellCount;i++)
     szHTML+="<td height=1 class=\"clBorder\"></td>";
   } else if (iRow==1) {
    for(i=0;i<c_lTabs;i++) {
     szHTML+="<td height=1 nowrap class=\"clBorder\">&nbsp;</td>";
     szHTML+=
      "<td id=tdTab height=1 nowrap class=\"clTab\" onmouseover=\"parent.fnMouseOverTab("+i+");\" onmouseout=\"parent.fnMouseOutTab("+i+");\">"+
      "<a href=\""+document.all.item("shLink")[i].href+"\" target=\"frSheet\" id=aTab>&nbsp;"+c_rgszSh[i]+"&nbsp;</a></td>";
    }
    szHTML+="<td id=tdTab height=1 nowrap class=\"clBorder\"><a id=aTab>&nbsp;</a></td><td width=100%></td>";
   } else if (iRow==2) {
    for (i=0;i<c_lTabs;i++)
     szHTML+="<td height=1></td><td height=1 class=\"clBorder\"></td>";
    szHTML+="<td height=1></td><td height=1></td>";
   } else if (iRow==3) {
    for (i=0;i<iCellCount;i++)
     szHTML+="<td height=1></td>";
   } else if (iRow==4) {
    for (i=0;i<c_lTabs;i++)
     szHTML+="<td height=1 width=1></td><td height=1></td>";
    szHTML+="<td height=1 width=1></td><td></td>";
   }
  }
  szHTML+="</tr>";
 }

 szHTML+="</table></body></html>";
 with (frames['frTabs'].document) {
  open("text/html","replace");
  charset=document.charset;
  write(szHTML);
  close();
 }
}

function fnInit()
{
 g_rglTabX[0]=0;
 var i;
 for (i=1;i<=c_lTabs;i++)
  with (frames['frTabs'].document.all.tbTabs.rows[1].cells[fnTabToCol(i-1)])
   g_rglTabX[i]=offsetLeft+offsetWidth-6;
}

function fnTabToCol(iTab)
{
 return 2*iTab+1;
}

function fnNextTab(fDir)
{
 var iNextTab=-1;
 var i;

 with (frames['frTabs'].document.body) {
  if (fDir==0) {
   if (scrollLeft>0) {
    for (i=0;i<c_lTabs&&g_rglTabX[i]<scrollLeft;i++);
    if (i<c_lTabs)
     iNextTab=i-1;
   }
  } else {
   if (g_rglTabX[c_lTabs]+6>offsetWidth+scrollLeft) {
    for (i=0;i<c_lTabs&&g_rglTabX[i]<=scrollLeft;i++);
    if (i<c_lTabs)
     iNextTab=i;
   }
  }
 }
 return iNextTab;
}

function fnScrollTabs(fDir)
{
 var iNextTab=fnNextTab(fDir);

 if (iNextTab>=0) {
  frames['frTabs'].scroll(g_rglTabX[iNextTab],0);
  return true;
 } else
  return false;
}

function fnFastScrollTabs(fDir)
{
 if (c_lTabs>16)
  frames['frTabs'].scroll(g_rglTabX[fDir?c_lTabs-1:0],0);
 else
  if (fnScrollTabs(fDir)>0) window.setTimeout("fnFastScrollTabs("+fDir+");",5);
}

function fnSetTabProps(iTab,fActive)
{
 var iCol=fnTabToCol(iTab);
 var i;

 if (iTab>=0) {
  with (frames['frTabs'].document.all) {
   with (tbTabs) {
    for (i=0;i<=4;i++) {
     with (rows[i]) {
      if (i==0)
       cells[iCol].style.background=c_rgszClr[fActive?0:2];
      else if (i>0 && i<4) {
       if (fActive) {
        cells[iCol-1].style.background=c_rgszClr[2];
        cells[iCol].style.background=c_rgszClr[0];
        cells[iCol+1].style.background=c_rgszClr[2];
       } else {
        if (i==1) {
         cells[iCol-1].style.background=c_rgszClr[2];
         cells[iCol].style.background=c_rgszClr[1];
         cells[iCol+1].style.background=c_rgszClr[2];
        } else {
         cells[iCol-1].style.background=c_rgszClr[4];
         cells[iCol].style.background=c_rgszClr[(i==2)?2:4];
         cells[iCol+1].style.background=c_rgszClr[4];
        }
       }
      } else
       cells[iCol].style.background=c_rgszClr[fActive?2:4];
     }
    }
   }
   with (aTab[iTab].style) {
    cursor=(fActive?"default":"hand");
    color=c_rgszClr[3];
   }
  }
 }
}

function fnMouseOverScroll(iCtl)
{
 frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[7];
}

function fnMouseOutScroll(iCtl)
{
 frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[6];
}

function fnMouseOverTab(iTab)
{
 if (iTab!=g_iShCur) {
  var iCol=fnTabToCol(iTab);
  with (frames['frTabs'].document.all) {
   tdTab[iTab].style.background=c_rgszClr[5];
  }
 }
}

function fnMouseOutTab(iTab)
{
 if (iTab>=0) {
  var elFrom=frames['frTabs'].event.srcElement;
  var elTo=frames['frTabs'].event.toElement;

  if ((!elTo) ||
   (elFrom.tagName==elTo.tagName) ||
   (elTo.tagName=="A" && elTo.parentElement!=elFrom) ||
   (elFrom.tagName=="A" && elFrom.parentElement!=elTo)) {

   if (iTab!=g_iShCur) {
    with (frames['frTabs'].document.all) {
     tdTab[iTab].style.background=c_rgszClr[1];
    }
   }
  }
 }
}

function fnSetActiveSheet(iSh)
{
 if (iSh!=g_iShCur) {
  fnSetTabProps(g_iShCur,false);
  fnSetTabProps(iSh,true);
  g_iShCur=iSh;
 }
}

 window.g_iIEVer=fnGetIEVer();
 if (window.g_iIEVer>=4)
  fnBuildFrameset();
//-->
</script>
<![endif]><!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>statistic-survey498594 (1)</x:Name>
    <x:WorksheetSource HRef="statistic-survey498594%20(1)-Dateien/sheet001.htm"/>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:Stylesheet HRef="statistic-survey498594%20(1)-Dateien/stylesheet.css"/>
  <x:WindowHeight>13845</x:WindowHeight>
  <x:WindowWidth>28800</x:WindowWidth>
  <x:WindowTopX>32767</x:WindowTopX>
  <x:WindowTopY>32767</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<frameset rows="*,39" border=0 width=0 frameborder=no framespacing=0>
 <frame src="statistic-survey498594%20(1)-Dateien/sheet001.htm" name="frSheet">
 <frame src="statistic-survey498594%20(1)-Dateien/tabstrip.htm" name="frTabs" marginwidth=0 marginheight=0>
 <noframes>
  <body>
   <p>Diese Seite verwendet Frames. Frames werden von Ihrem Browser aber nicht unterstützt.</p>
  </body>
 </noframes>
</frameset>
</html>
statistic-survey498594-2.xls (10,117 bytes)   
L.Guldi

L.Guldi

2026-07-02 12:05

reporter   ~85145

My colleague noticed a problem with the xls file i uploaded. For some reason the error might not be displayed in the file, so here is another file that shoud display the error correctly.

statistic-survey498594-2.htm (9,973 bytes)    
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta name="Excel Workbook Frameset">
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 15">
<link rel=File-List href="test-Dateien/filelist.xml">
<title>CDbException</title>
<![if !supportTabStrip]>
<link id="shLink" href="test-Dateien/sheet001.htm">

<link id="shLink">

<script language="JavaScript">
<!--
 var c_lTabs=1;

 var c_rgszSh=new Array(c_lTabs);
 c_rgszSh[0] = "statistic-survey498594 (1)";



 var c_rgszClr=new Array(8);
 c_rgszClr[0]="window";
 c_rgszClr[1]="buttonface";
 c_rgszClr[2]="windowframe";
 c_rgszClr[3]="windowtext";
 c_rgszClr[4]="threedlightshadow";
 c_rgszClr[5]="threedhighlight";
 c_rgszClr[6]="threeddarkshadow";
 c_rgszClr[7]="threedshadow";

 var g_iShCur;
 var g_rglTabX=new Array(c_lTabs);

function fnGetIEVer()
{
 var ua=window.navigator.userAgent
 var msie=ua.indexOf("MSIE")
 if (msie>0 && window.navigator.platform=="Win32")
  return parseInt(ua.substring(msie+5,ua.indexOf(".", msie)));
 else
  return 0;
}

function fnBuildFrameset()
{
 var szHTML="<frameset rows=\"*,18\" border=0 width=0 frameborder=no framespacing=0>"+
  "<frame src=\""+document.all.item("shLink")[0].href+"\" name=\"frSheet\" noresize>"+
  "<frameset cols=\"54,*\" border=0 width=0 frameborder=no framespacing=0>"+
  "<frame src=\"\" name=\"frScroll\" marginwidth=0 marginheight=0 scrolling=no>"+
  "<frame src=\"\" name=\"frTabs\" marginwidth=0 marginheight=0 scrolling=no>"+
  "</frameset></frameset><plaintext>";

 with (document) {
  open("text/html","replace");
  write(szHTML);
  close();
 }

 fnBuildTabStrip();
}

function fnBuildTabStrip()
{
 var szHTML=
  "<html><head><style>.clScroll {font:8pt Courier New;color:"+c_rgszClr[6]+";cursor:default;line-height:10pt;}"+
  ".clScroll2 {font:10pt Arial;color:"+c_rgszClr[6]+";cursor:default;line-height:11pt;}</style></head>"+
  "<body onclick=\"event.returnValue=false;\" ondragstart=\"event.returnValue=false;\" onselectstart=\"event.returnValue=false;\" bgcolor="+c_rgszClr[4]+" topmargin=0 leftmargin=0><table cellpadding=0 cellspacing=0 width=100%>"+
  "<tr><td colspan=6 height=1 bgcolor="+c_rgszClr[2]+"></td></tr>"+
  "<tr><td style=\"font:1pt\">&nbsp;<td>"+
  "<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(0);\" onmouseout=\"parent.fnMouseOutScroll(0);\"><a>&#171;</a></td>"+
  "<td valign=top id=tdScroll class=\"clScroll2\" onclick=\"parent.fnScrollTabs(0);\" ondblclick=\"parent.fnScrollTabs(0);\" onmouseover=\"parent.fnMouseOverScroll(1);\" onmouseout=\"parent.fnMouseOutScroll(1);\"><a>&lt</a></td>"+
  "<td valign=top id=tdScroll class=\"clScroll2\" onclick=\"parent.fnScrollTabs(1);\" ondblclick=\"parent.fnScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(2);\" onmouseout=\"parent.fnMouseOutScroll(2);\"><a>&gt</a></td>"+
  "<td valign=top id=tdScroll class=\"clScroll\" onclick=\"parent.fnFastScrollTabs(1);\" onmouseover=\"parent.fnMouseOverScroll(3);\" onmouseout=\"parent.fnMouseOutScroll(3);\"><a>&#187;</a></td>"+
  "<td style=\"font:1pt\">&nbsp;<td></tr></table></body></html>";

 with (frames['frScroll'].document) {
  open("text/html","replace");
  write(szHTML);
  close();
 }

 szHTML =
  "<html><head>"+
  "<style>A:link,A:visited,A:active {text-decoration:none;"+"color:"+c_rgszClr[3]+";}"+
  ".clTab {cursor:hand;background:"+c_rgszClr[1]+";font:9pt Arial;padding-left:3px;padding-right:3px;text-align:center;}"+
  ".clBorder {background:"+c_rgszClr[2]+";font:1pt;}"+
  "</style></head><body onload=\"parent.fnInit();\" onselectstart=\"event.returnValue=false;\" ondragstart=\"event.returnValue=false;\" bgcolor="+c_rgszClr[4]+
  " topmargin=0 leftmargin=0><table id=tbTabs cellpadding=0 cellspacing=0>";

 var iCellCount=(c_lTabs+1)*2;

 var i;
 for (i=0;i<iCellCount;i+=2)
  szHTML+="<col width=1><col>";

 var iRow;
 for (iRow=0;iRow<6;iRow++) {

  szHTML+="<tr>";

  if (iRow==5)
   szHTML+="<td colspan="+iCellCount+"></td>";
  else {
   if (iRow==0) {
    for(i=0;i<iCellCount;i++)
     szHTML+="<td height=1 class=\"clBorder\"></td>";
   } else if (iRow==1) {
    for(i=0;i<c_lTabs;i++) {
     szHTML+="<td height=1 nowrap class=\"clBorder\">&nbsp;</td>";
     szHTML+=
      "<td id=tdTab height=1 nowrap class=\"clTab\" onmouseover=\"parent.fnMouseOverTab("+i+");\" onmouseout=\"parent.fnMouseOutTab("+i+");\">"+
      "<a href=\""+document.all.item("shLink")[i].href+"\" target=\"frSheet\" id=aTab>&nbsp;"+c_rgszSh[i]+"&nbsp;</a></td>";
    }
    szHTML+="<td id=tdTab height=1 nowrap class=\"clBorder\"><a id=aTab>&nbsp;</a></td><td width=100%></td>";
   } else if (iRow==2) {
    for (i=0;i<c_lTabs;i++)
     szHTML+="<td height=1></td><td height=1 class=\"clBorder\"></td>";
    szHTML+="<td height=1></td><td height=1></td>";
   } else if (iRow==3) {
    for (i=0;i<iCellCount;i++)
     szHTML+="<td height=1></td>";
   } else if (iRow==4) {
    for (i=0;i<c_lTabs;i++)
     szHTML+="<td height=1 width=1></td><td height=1></td>";
    szHTML+="<td height=1 width=1></td><td></td>";
   }
  }
  szHTML+="</tr>";
 }

 szHTML+="</table></body></html>";
 with (frames['frTabs'].document) {
  open("text/html","replace");
  charset=document.charset;
  write(szHTML);
  close();
 }
}

function fnInit()
{
 g_rglTabX[0]=0;
 var i;
 for (i=1;i<=c_lTabs;i++)
  with (frames['frTabs'].document.all.tbTabs.rows[1].cells[fnTabToCol(i-1)])
   g_rglTabX[i]=offsetLeft+offsetWidth-6;
}

function fnTabToCol(iTab)
{
 return 2*iTab+1;
}

function fnNextTab(fDir)
{
 var iNextTab=-1;
 var i;

 with (frames['frTabs'].document.body) {
  if (fDir==0) {
   if (scrollLeft>0) {
    for (i=0;i<c_lTabs&&g_rglTabX[i]<scrollLeft;i++);
    if (i<c_lTabs)
     iNextTab=i-1;
   }
  } else {
   if (g_rglTabX[c_lTabs]+6>offsetWidth+scrollLeft) {
    for (i=0;i<c_lTabs&&g_rglTabX[i]<=scrollLeft;i++);
    if (i<c_lTabs)
     iNextTab=i;
   }
  }
 }
 return iNextTab;
}

function fnScrollTabs(fDir)
{
 var iNextTab=fnNextTab(fDir);

 if (iNextTab>=0) {
  frames['frTabs'].scroll(g_rglTabX[iNextTab],0);
  return true;
 } else
  return false;
}

function fnFastScrollTabs(fDir)
{
 if (c_lTabs>16)
  frames['frTabs'].scroll(g_rglTabX[fDir?c_lTabs-1:0],0);
 else
  if (fnScrollTabs(fDir)>0) window.setTimeout("fnFastScrollTabs("+fDir+");",5);
}

function fnSetTabProps(iTab,fActive)
{
 var iCol=fnTabToCol(iTab);
 var i;

 if (iTab>=0) {
  with (frames['frTabs'].document.all) {
   with (tbTabs) {
    for (i=0;i<=4;i++) {
     with (rows[i]) {
      if (i==0)
       cells[iCol].style.background=c_rgszClr[fActive?0:2];
      else if (i>0 && i<4) {
       if (fActive) {
        cells[iCol-1].style.background=c_rgszClr[2];
        cells[iCol].style.background=c_rgszClr[0];
        cells[iCol+1].style.background=c_rgszClr[2];
       } else {
        if (i==1) {
         cells[iCol-1].style.background=c_rgszClr[2];
         cells[iCol].style.background=c_rgszClr[1];
         cells[iCol+1].style.background=c_rgszClr[2];
        } else {
         cells[iCol-1].style.background=c_rgszClr[4];
         cells[iCol].style.background=c_rgszClr[(i==2)?2:4];
         cells[iCol+1].style.background=c_rgszClr[4];
        }
       }
      } else
       cells[iCol].style.background=c_rgszClr[fActive?2:4];
     }
    }
   }
   with (aTab[iTab].style) {
    cursor=(fActive?"default":"hand");
    color=c_rgszClr[3];
   }
  }
 }
}

function fnMouseOverScroll(iCtl)
{
 frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[7];
}

function fnMouseOutScroll(iCtl)
{
 frames['frScroll'].document.all.tdScroll[iCtl].style.color=c_rgszClr[6];
}

function fnMouseOverTab(iTab)
{
 if (iTab!=g_iShCur) {
  var iCol=fnTabToCol(iTab);
  with (frames['frTabs'].document.all) {
   tdTab[iTab].style.background=c_rgszClr[5];
  }
 }
}

function fnMouseOutTab(iTab)
{
 if (iTab>=0) {
  var elFrom=frames['frTabs'].event.srcElement;
  var elTo=frames['frTabs'].event.toElement;

  if ((!elTo) ||
   (elFrom.tagName==elTo.tagName) ||
   (elTo.tagName=="A" && elTo.parentElement!=elFrom) ||
   (elFrom.tagName=="A" && elFrom.parentElement!=elTo)) {

   if (iTab!=g_iShCur) {
    with (frames['frTabs'].document.all) {
     tdTab[iTab].style.background=c_rgszClr[1];
    }
   }
  }
 }
}

function fnSetActiveSheet(iSh)
{
 if (iSh!=g_iShCur) {
  fnSetTabProps(g_iShCur,false);
  fnSetTabProps(iSh,true);
  g_iShCur=iSh;
 }
}

 window.g_iIEVer=fnGetIEVer();
 if (window.g_iIEVer>=4)
  fnBuildFrameset();
//-->
</script>
<![endif]><!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>statistic-survey498594 (1)</x:Name>
    <x:WorksheetSource HRef="test-Dateien/sheet001.htm"/>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:Stylesheet HRef="test-Dateien/stylesheet.css"/>
  <x:WindowHeight>13845</x:WindowHeight>
  <x:WindowWidth>28800</x:WindowWidth>
  <x:WindowTopX>32767</x:WindowTopX>
  <x:WindowTopY>32767</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<frameset rows="*,39" border=0 width=0 frameborder=no framespacing=0>
 <frame src="test-Dateien/sheet001.htm" name="frSheet">
 <frame src="test-Dateien/tabstrip.htm" name="frTabs" marginwidth=0 marginheight=0>
 <noframes>
  <body>
   <p>Diese Seite verwendet Frames. Frames werden von Ihrem Browser aber nicht unterstützt.</p>
  </body>
 </noframes>
</frameset>
</html>
statistic-survey498594-2.htm (9,973 bytes)   
L.Guldi

L.Guldi

2026-07-02 12:10

reporter   ~85146

Limesurvey_Error_Message.txt (13,628 bytes)    
CDbException	
	
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'TQ29460' in 'WHERE'. The SQL statement executed was: SELECT * FROM `lime_responses_498594` `t` WHERE `TQ29460` != ''	
	
/var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/db/CDbCommand.php(543)	
	
531         {	
532             if($this->_connection->enableProfiling)	
533                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');	
534	
535             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;	
536             $message=$e->getMessage();	
537             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',	
538                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');	
539	
540             if(YII_DEBUG)	
541                 $message.='. The SQL statement executed was: '.$this->getText().$par;	
542	
543             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',	
544                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);	
545         }	
546     }	
547	
548     /**	
549      * Builds a SQL SELECT statement from the given query specification.	
550      * @param array $query the query specification in name-value pairs. The following	
551      * query options are supported: {@link select}, {@link distinct}, {@link from},	
552      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},	
553      * {@link limit}, {@link offset} and {@link union}.	
554      * @throws CDbException if "from" key is not present in given query parameter	
555      * @return string the SQL statement	
	
	
Stack Trace	
#0	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/db/CDbCommand.php(396): CDbCommand->queryInternal()
	
	
	391      * An empty array is returned if the query results in nothing.
	392      * @throws CException execution failed
	393      */
	394     public function queryAll($fetchAssociative=true,$params=array())
	395     {
	396         return $this->queryInternal('fetchAll',$fetchAssociative ? $this->_fetchMode : PDO::FETCH_NUM, $params);
	397     }
	398
	399     /**
	400      * Executes the SQL statement and returns the first row of the result.
	401      * This is a convenient method of {@link query} when only the first row of data is needed.
	
	
#1	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1359): CDbCommand->queryAll()
	
	
	1354         if(empty($criteria->with))
	1355         {
	1356             if(!$all)
	1357                 $criteria->limit=1;
	1358             $command=$this->getCommandBuilder()->createFindCommand($this->getTableSchema(),$criteria);
	1359             return $all ? $this->populateRecords($command->queryAll(), true, $criteria->index) : $this->populateRecord($command->queryRow());
	1360         }
	1361         else
	1362         {
	1363             $finder=$this->getActiveFinder($criteria->with);
	1364             return $finder->query($criteria,$all);
	
	
#2	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/application/models/LSActiveRecord.php(72): CActiveRecord->query()
	
	
	67      * @since 1.1.7
	68      */
	69     protected function query($criteria, $all = false, $asAR = true)
	70     {
	71         if ($asAR === true) {
	72             return parent::query($criteria, $all);
	73         } else {
	74             $this->beforeFind();
	75             $this->applyScopes($criteria);
	76             if (!$all) {
	77                 $criteria->limit = 1;
	
	
#3	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1478): LSActiveRecord->query()
	
	
	1473      */
	1474     public function findAll($condition='',$params=array())
	1475     {
	1476         Yii::trace(get_class($this).'.findAll()','system.db.ar.CActiveRecord');
	1477         $criteria=$this->getCommandBuilder()->createCriteria($condition,$params);
	1478         return $this->query($criteria,true);
	1479     }
	1480
	1481     /**
	1482      * Finds a single active record with the specified primary key.
	1483      * See {@link find()} for detailed explanation about $condition and $params.
	
	
#4	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/application/helpers/admin/statistics_helper.php(4262): CActiveRecord->findAll()
	
	
	4257             if ($sortmethod && !in_array($sortmethod, ['ASC', 'DESC'])) {
	4258                 $sortmethod = "";
	4259             }
	4260             $search['order'] = $sortby . ' ' . $sortmethod;
	4261         }
	4262         $results = SurveyDynamic::model($surveyid)->findAll($search);
	4263         $output = array();
	4264         foreach ($results as $row) {
	4265             $row->decrypt();
	4266             $output[] = array("id" => $row['id'], "value" => $row[$column]);
	4267         }
	
	
#5	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/application/helpers/admin/statistics_helper.php(2406): statistics_helper->_listcolumn()
	
	
	2401
	2402                 if ($browse === true && !empty($_POST['showtextinline']) && $outputType == 'xls') {
	2403                     $headXLS = array();
	2404                     $headXLS[] = array(gT("ID"), gT("Response"));
	2405
	2406                     $result2 = $this->_listcolumn($surveyid, $sColumnName);
	2407
	2408                     foreach ($result2 as $row2) {
	2409                         $tableXLS[] = array($row2['id'], $row2['value']);
	2410                     }
	2411                 }
	
	
#6	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/application/helpers/admin/statistics_helper.php(4043): statistics_helper->displayResults()
	
	
	4038                 $outputs = $this->buildOutputList($rt, $language, $surveyid, $outputType, $sql, $sLanguageCode);
	4039                 $sOutputHTML .= $outputs['statisticsoutput'];
	4040                 //2. Collect and Display results #######################################################################
	4041                 if (isset($outputs['alist']) && $outputs['alist']) {
	4042                     //Make sure there really is an answerlist, and if so:
	4043                     $display = $this->displayResults($outputs, $results, $rt, $outputType, $surveyid, $sql, $usegraph, $browse, $sLanguageCode);
	4044                     $sOutputHTML .= $display['statisticsoutput'];
	4045                     $aStatisticsData = array_merge($aStatisticsData, $display['astatdata']);
	4046                 }    //end if -> collect and display results
	4047
	4048
	
	
#7	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/application/controllers/admin/Statistics.php(479): statistics_helper->generate_statistics()
	
	
	474                 case 'pdf':
	475                     $helper->generate_statistics($surveyid, $summary, $summary, $usegraph, $outputType, 'D', $statlang);
	476                     exit;
	477                     break;
	478                 case 'xls':
	479                     $helper->generate_statistics($surveyid, $summary, $summary, $usegraph, $outputType, 'DD', $statlang);
	480                     exit;
	481                     break;
	482                 default:
	483                     break;
	484             }
	
	
#8	 unknown(0): Statistics->run()
	
	
#9	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/actions/CAction.php(114): ReflectionMethod->invokeArgs()
	
	
	109             elseif($param->isDefaultValueAvailable())
	110                 $ps[]=$param->getDefaultValue();
	111             else
	112                 return false;
	113         }
	114         $method->invokeArgs($object,$ps);
	115         return true;
	116     }
	117 }
	
	
#10	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/application/core/SurveyCommonAction.php(86): CAction->runWithParamsInternal()
	
	
	81             $oMethod = new ReflectionMethod($this, $sDefault);
	82         }
	83
	84         // We're all good to go, let's execute it
	85         // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
	86         return parent::runWithParamsInternal($this, $oMethod, $params);
	87     }
	88
	89     /**
	90      * Some functions have different parameters, which are just an alias of the
	91      * usual parameters we're getting in the url. This function just populates
	
	
#11	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/CController.php(308): SurveyCommonAction->runWithParams()
	
	
	303     {
	304         $priorAction=$this->_action;
	305         $this->_action=$action;
	306         if($this->beforeAction($action))
	307         {
	308             if($action->runWithParams($this->getActionParams())===false)
	309                 $this->invalidActionParams($action);
	310             else
	311                 $this->afterAction($action);
	312         }
	313         $this->_action=$priorAction;
	
	
#12	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/CController.php(286): CController->runAction()
	
	
	281      * @see runAction
	282      */
	283     public function runActionWithFilters($action,$filters)
	284     {
	285         if(empty($filters))
	286             $this->runAction($action);
	287         else
	288         {
	289             $priorAction=$this->_action;
	290             $this->_action=$action;
	291             CFilterChain::create($this,$action,$filters)->run();
	
	
#13	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/CController.php(265): CController->runActionWithFilters()
	
	
	260         {
	261             if(($parent=$this->getModule())===null)
	262                 $parent=Yii::app();
	263             if($parent->beforeControllerAction($this,$action))
	264             {
	265                 $this->runActionWithFilters($action,$this->filters());
	266                 $parent->afterControllerAction($this,$action);
	267             }
	268         }
	269         else
	270             $this->missingAction($actionID);
	
	
#14	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/application/controllers/AdminController.php(203): CController->run()
	
	
	198         $this->runModuleController($action);
	199         // this will redirect the default action to the new controller previously "admin/index" or "admin" to "dashboard/view"
	200         if (empty($action) || $action === 'index') {
	201             $this->redirect($this->createUrl('dashboard/view'));
	202         }
	203         return parent::run($action);
	204     }
	205
	206     /**
	207      * Starting with LS4, 3rd party developer can extends any of the LimeSurve controllers.
	208      *
	
	
#15	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/CWebApplication.php(282): AdminController->run()
	
	
	277         {
	278             list($controller,$actionID)=$ca;
	279             $oldController=$this->_controller;
	280             $this->_controller=$controller;
	281             $controller->init();
	282             $controller->run($actionID);
	283             $this->_controller=$oldController;
	284         }
	285         else
	286             throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
	287                 array('{route}'=>$route===''?$this->defaultController:$route)));
	
	
#16	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): CWebApplication->runController()
	
	
	136             foreach(array_splice($this->catchAllRequest,1) as $name=>$value)
	137                 $_GET[$name]=$value;
	138         }
	139         else
	140             $route=$this->getUrlManager()->parseUrl($this->getRequest());
	141         $this->runController($route);
	142     }
	143
	144     /**
	145      * Registers the core application components.
	146      * This method overrides the parent implementation by registering additional core components.
	
	
#17	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/vendor/yiisoft/yii/framework/base/CApplication.php(185): CWebApplication->processRequest()
	
	
	180     public function run()
	181     {
	182         if($this->hasEventHandler('onBeginRequest'))
	183             $this->onBeginRequest(new CEvent($this));
	184         register_shutdown_function(array($this,'end'),0,false);
	185         $this->processRequest();
	186         if($this->hasEventHandler('onEndRequest'))
	187             $this->onEndRequest(new CEvent($this));
	188     }
	189
	190     /**
	
	
#18	+
	
	
	–
	
	
	 /var/www/limesurvey.host/htdocs/index.php(161): CApplication->run()
	
	
	156 require_once APPPATH . 'core/LSYii_Application' . EXT;
	157
	158 $config = require_once(APPPATH . 'config/internal' . EXT);
	159
	160 Yii::$enableIncludePath = false;
	161 Yii::createApplication('LSYii_Application', $config)->run();
	162
	163 /* End of file index.php */
	164 /* Location: ./index.php */
	
	
	
	
2026-06-30 13:22:36 Apache Yii Framework/1.1.32
Limesurvey_Error_Message.txt (13,628 bytes)   
L.Guldi

L.Guldi

2026-07-02 12:23

reporter   ~85147

The column appears to be named differently in the actual database.

Error/Fails:

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]:
Column not found: 1054 Unknown column 'TQ29460' in 'WHERE'. The SQL statement
executed was: SELECT * FROM lime_responses_498594 t WHERE TQ29460 != ''

No Error:

SELECT * FROM lime_responses_498594 t WHERE Q29460 != '';

Issue History

Date Modified Username Field Change
2026-06-29 11:00 L.Guldi New Issue
2026-06-29 11:00 L.Guldi File Added: Error500.png
2026-06-29 11:00 L.Guldi File Added: Fileformat.png
2026-06-29 11:00 L.Guldi File Added: MissingFiles.png
2026-06-29 11:00 L.Guldi File Added: survey_archive_498594.lsa
2026-06-29 11:01 DenisChenu Note Added: 85097
2026-06-29 11:01 DenisChenu Bug heat 0 => 2
2026-06-29 13:22 L.Guldi Note Added: 85100
2026-06-29 13:22 L.Guldi Bug heat 2 => 4
2026-06-29 14:43 DenisChenu Note Added: 85103
2026-06-30 08:35 L.Guldi Note Added: 85115
2026-06-30 08:35 L.Guldi File Added: statistic-survey498594.xls
2026-06-30 10:37 DenisChenu Note Added: 85124
2026-06-30 15:34 L.Guldi Note Added: 85130
2026-06-30 15:34 L.Guldi File Added: statistic-survey498594-2.xls
2026-07-02 12:05 L.Guldi Note Added: 85145
2026-07-02 12:05 L.Guldi File Added: statistic-survey498594-2.htm
2026-07-02 12:10 L.Guldi Note Added: 85146
2026-07-02 12:10 L.Guldi File Added: Limesurvey_Error_Message.txt
2026-07-02 12:23 L.Guldi Note Added: 85147