Hello there,
Recently, one of our users got a SQL error while conducting a survey. We use version 2.72.3+171020. She received an e-mail with the following (I'm translating it to English):
Code:
Subject: Error saving results
An error happened while trying to save a response in the survey <span style="font-size:20px;">Survey name</span> - 299365
DATA TO BE INSERTED:
token: N/A
299365X218X4187:
299365X218X4357: A2
299365X218X4190: A3
299365X218X4191: N/A
299365X218X4192: N/A
299365X218X4365: A1
299365X218X4188: A8
299365X218X4361: A3
299365X218X4358: A2
299365X218X4364: A2
299365X221X4249:
299365X221X4214SQ001: A5
299365X221X4214SQ002: A4
(goes on and on...)
SQL CODE THAT PRESENTED THE ERROR:
UPDATE {{survey_299365}} SET "lastpage"=1, "datestamp"='2020-06-22 11:54:21', "299365X231X4471"='', "299365X231X4415"='A3', "299365X231X4416"='A4', "299365X231X4418"='A5', "299365X231X4417"='A5', "299365X231X4419"='A1', "299365X231X4420"=NULL, "299365X231X4421"='A1', "299365X231X4422"='A6', "299365X231X4423"='A3', "299365X231X4424"='' WHERE ID=3160
Apache logs show nothing. Enabling debug mode to show errors on screen seems awkward since it's a production environment and it seems the error happens following some external action. I couldn't find any logs inside LimeSurvey folders, including "limesurvey/tmp/runtime/application.log", which is mentioned in the wiki. Any advice? Are these messages supposed to be recorded on some log file?
Thank you!
