| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 17820 | Bug reports | ComfortUpdate | public | 2021-12-29 19:57 | 2021-12-31 10:25 |
| Reporter | netikja | Assigned To | galads | ||
| Priority | none | Severity | block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 5.2.x | ||||
| Summary | 17820: Error 500: CDbCommand failed to execute the SQL statement" when participant submits response | ||||
| Description | After comfort-updating from LS 3.17.x (cannot remember the exact version) to latest stable 5.2.7+211221 CE, an error occurs every time user submits his or her response, no matter what survey. 500 internal server error appears instead of "submit successful" message with following details:
Although this error may scare the participants, their responses seem to save well into the database. I suspect that the database upgrade failed at some point, but I cannot spot the issue. Is there any remedy to this? Note that when I install a fresh LS which works well, I cannot see a column called "question.language" at all anywhere. | ||||
| Steps To Reproduce | Steps to reproduceUse ComfortUpdate. After the update, fill a survey (doesn't matter which one), click Submit at the final page. Expected resultMessage about successful response submission. Response saved into response table. Actual result500 internal server error occurs with | ||||
| Tags | bug, PDF, PDFreport | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 5.2.7+211221 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Chrome 96.0.4664.110 | ||||
| Database type & version | MariaDB / 10.3.31-MariaDB-0+deb10u1-log - Debian 10 / | ||||
| Server OS (if known) | Debian | ||||
| Webserver software & version (if known) | Apache/2.4.38 (Debian) / libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $ | ||||
| PHP Version | 7.3.31-1~deb10u1 | ||||
 |
EDIT: The issue is caused by a plugin called “PDFReport”. Solved by disabling it. However, I cannot remember I have ever installed it, maybe it was sort of standard plugin shipped with LS 3.17.16? As a user I would definitely appreciate some warning about this possible LS vs. plugin ”version” mismatch either during the update or in the manual. IMHO, there should be some compatibility checks or measures like those Wordpress utilizes. |
|
|
EDIT: The issue is caused by a plugin called “PDFReport”. Solved by disabling it. However, I cannot remember I have ever installed it, maybe it was sort of standard plugin shipped with LS 3.17.16? As a user I would definitely appreciate some warning about this possible LS vs. plugin ”version” mismatch either during the update or in the manual. IMHO, there should be some compatibility checks or measures like those Wordpress utilizes. |
|
|
Hello, thank you for reporting this issue. PDFReport is not a standard plugin in LS3. By the way, there is already a task to disable all plugins that are not core plugins when updating. At the moment, I also think incompatible plugins are disabled by default when upgrading. I will close this issue now, since there is already a task to fix this issue in the pipeline. |
