View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
17522 | Bug reports | _ Unknown | public | 2021-08-18 14:55 | 2021-09-06 10:59 |
Reporter | nooblag | Assigned To | ollehar | ||
Priority | normal | Severity | crash | ||
Status | closed | Resolution | fixed | ||
Product Version | 5.x | ||||
Summary | 17522: CDbCommand failed to execute the SQL statement: SQLSTATE[42803] | ||||
Description | I'm getting this error whenever I try to Export Results of a survey:
I've done the Data consistency check and Data redundancy check in Lime Survey admin and still this occurs. System configuration:
| ||||
Steps To Reproduce | Go to Export data from a survey | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 36 | ||||
Complete LimeSurvey version number (& build) | 5.1.3, github build | ||||
I will donate to the project if issue is resolved | Yes | ||||
Browser | Firefox 91.0 | ||||
Database type & version | Postgres 10.17 | ||||
Server OS (if known) | Ubuntu 18.04.5 LTS | ||||
Webserver software & version (if known) | nginx 1.18.0 | ||||
PHP Version | PHP 7.4.22 | ||||
Can you enable debug = 2 in application/config/config.php and try again, please? Paste the complete error message here. |
|
|
|
@p_teichmann Probably same issue, ORDER BY needs to be removed. |
|
Hi, are there news about this bug? thanks! |
|
I will add it to our current sprint. Thank you for the reminder. |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=32626 |
|
Can you try to apply this patch, please? https://github.com/LimeSurvey/LimeSurvey/commit/c27613ffd5ee51d8fe6303c209ceb523fdc22573 |
|
That appears to have fixed it for me. Thanks! |
|
Yes, for me too it worked, thanks! |
|
Hello, |
|
We release a bug fix release every Monday. So within an hour or so from this message. |
|
Thanks for the info! |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2021-08-18 14:55 | nooblag | New Issue | |
2021-08-18 14:55 | nooblag | File Added: Screenshot 2021-08-18 at 09-59-14.png | |
2021-08-18 14:55 | nooblag | File Added: Screenshot 2021-08-18 at 09-59-50.png | |
2021-08-18 15:22 | ollehar | Note Added: 66052 | |
2021-08-18 15:22 | ollehar | Bug heat | 0 => 2 |
2021-08-18 15:23 | ollehar | Assigned To | => ollehar |
2021-08-18 15:23 | ollehar | Status | new => feedback |
2021-08-18 15:23 | ollehar | Severity | minor => crash |
2021-08-18 15:23 | ollehar | Description Updated | |
2021-08-18 15:23 | ollehar | Priority | none => normal |
2021-08-18 16:50 | galads | Relationship added | has duplicate 17523 |
2021-08-18 16:50 | galads | Issue Monitored: zufolo441 | |
2021-08-18 16:50 | galads | Bug heat | 2 => 14 |
2021-08-18 18:27 | nooblag | Note Added: 66057 | |
2021-08-18 18:27 | nooblag | File Added: Screenshot 2021-08-19 at 02-26-49 CDbException.png | |
2021-08-18 18:27 | nooblag | Status | feedback => assigned |
2021-08-18 18:52 | ollehar | Note Added: 66060 | |
2021-08-31 08:20 | guest | Bug heat | 14 => 20 |
2021-08-31 08:20 | zufolo441 | Note Added: 66202 | |
2021-08-31 08:20 | zufolo441 | Bug heat | 20 => 22 |
2021-08-31 08:29 | c_schmitz | Bug heat | 22 => 28 |
2021-08-31 09:07 | guest | Bug heat | 28 => 34 |
2021-08-31 10:34 | p_teichmann | Sync to Zoho Project | => |Yes| |
2021-08-31 11:11 | ollehar | Sync to Zoho Project | Yes => |Yes| |
2021-08-31 11:12 | ollehar | Sync to Zoho Project | Yes => |
2021-08-31 11:12 | ollehar | Sync to Zoho Project | => |Yes| |
2021-08-31 11:14 | ollehar | Note Added: 66234 | |
2021-08-31 12:19 | c_schmitz | Sync to Zoho Project | Yes => |
2021-08-31 12:19 | c_schmitz | Sync to Zoho Project | => |Yes| |
2021-09-01 16:32 | ollehar | Changeset attached | => LimeSurvey master c27613ff |
2021-09-01 16:32 | ollehar | Note Added: 66264 | |
2021-09-01 16:32 | ollehar | Resolution | open => fixed |
2021-09-01 16:32 | ollehar | Note Added: 66265 | |
2021-09-01 16:33 | ollehar | Status | assigned => ready for testing |
2021-09-01 16:45 | nooblag | Note Added: 66267 | |
2021-09-01 16:50 | ollehar | Status | ready for testing => resolved |
2021-09-01 17:59 | zufolo441 | Note Added: 66270 | |
2021-09-06 07:02 | YannCr | Note Added: 66328 | |
2021-09-06 07:02 | YannCr | Bug heat | 34 => 36 |
2021-09-06 10:28 | ollehar | Note Added: 66338 | |
2021-09-06 10:31 | YannCr | Note Added: 66339 | |
2021-09-06 10:59 | c_schmitz | Status | resolved => closed |