Hi guys I have in the field a long weekly tracking survey which we have converted recently from Lighthouse version 9.9.2 to 9.10.0. The survey was converted w/o any errors, uploaded to the server w/o errors and everything looked good until we tried to download the collected data.
Lighthouse studio shows this error when downloading the data from the server:
"No respondents can be accumulated from
C:\Users\ssiadmin\AppData\Local\Temp\8\a000216CZ_data.csv.
The file contains an invalid field 'Content-type: application/json'. ERROR: Name cannot contain spaces."
CSV contains only:
"Content-type: application/json
{"result": false error: "Error #264 - Database error."}
"
In the Admin panel the same error is displayed as:
"Database error. Cannot read respnum column in download area. [ID: 264]
System Error:
DBD::mysql::db selectall_arrayref failed: Column 'sys_RespNum' in field list is ambiguous at /var/www/html/a000216CZ/cgi-bin/admin.pl line 17, line 8.
Form Input:
hid_original_page=>download_data | hid_page=>download_data_builder | hid_report_settings=> | hid_session=>10971001091051101240970480480480500490541201613927942 | hid_studyname=>a000216CZ | with_completes=>on | with_disqualified=>on | with_incompletes=>on
Lighthouse Studio Version:
9.10.0
IP Address:
86.49.253.16
User Agent:
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.182 Safari/537.36 Edg/88.0.705.74"
When trying to download data from Admin panel will get CSV with following:
"Content-type: text/html
<!DOCTYPE html>
<html>
<head>
<!-- Sawtooth Software Web Interviewing System - Lighthouse Studio 9_10_0 -->
<!-- Copyright Sawtooth Software Inc. 1998-2021 - www.sawtoothsoftware.com - USA - (801) 477-4700 -->
<link rel="shortcut icon" href="/a000216CZ/graphics/system/survey.ico" type="image/x-icon">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta name="robots" content="noindex nofollow">
<meta name="viewport" content="width=device-width initial-scale=1">
<body>
<div style="border: 1px solid black; background-color: white; color: black; font-family: arial; padding: 5px; width: 800px; margin-left: auto; margin-right: auto; padding: 5px;">
<div style="color: red; text-decoration: underline; font-weight: bold;">Sawtooth Error # 264</div><div><p>Database error.</p></div><div style="margin-top: 30px;">Please try to refresh your browser or try to backup and submit again. If the error continues please contact the survey administrator.</div></div>
<style type="text/css">
.loading{display: none;}
.stage{display: block;}
</style>
</body>
</html>
"
I have no problems with the version-to-version upgrades since 9.6.1until now.
Can somebody help?
Best, Kosťa