View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
18615 | Bug reports | Installation | public | 2023-02-02 18:30 | 2023-06-12 10:45 |
Reporter | riqcles | Assigned To | c_schmitz | ||
Priority | normal | Severity | block | ||
Status | closed | Resolution | fixed | ||
Product Version | 5.5.x | ||||
Summary | 18615: Data integrity SQL syntax error on Postgres | ||||
Description | Hello, After a while, I have the "Fix" button that appears. I use the "fix" button Looking in the logs we find this: 2023-02-02 15:34:11.252 CET [32469] ERROR: syntax error on or near "LEFT" at character 43 I have broken down the query as follows: first result: I have rows with NULL and others not we continue : select * from lime_quota_languagesettings as lime1 where lime1.quotals_name IS NULL; I have NULLs for name but I did not find a NULL id And the last : I put in screenshot the results of the 3 queries, | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 10 | ||||
Complete LimeSurvey version number (& build) | Version 5.4.5+221010 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | Postgresql 13 | ||||
Server OS (if known) | |||||
Webserver software & version (if known) | |||||
PHP Version | 7.4.32 | ||||
Seems files are not shown ? |
|
After this : http://192.168.56.111/limesurvey/index.php/admin/checkintegrity?sa=fixintegrity |
|
You're not supposed to LEFT JOIN in delete? |
|
Good morning, |
|
https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-delete-join/ |
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34787 |
|
Fix committed to 5.x branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34788 |
|
Fixed in Release 6.1.3+230612 |
|
LimeSurvey: master 20775288 2023-06-08 20:03 Details Diff |
Fixed issue 18615: Data integrity SQL syntax error on Postgres when trying to fix quotas |
Affected Issues 18615 |
|
mod - application/controllers/admin/CheckIntegrity.php | Diff File | ||
LimeSurvey: 5.x e747eb5c 2023-06-08 20:03 Details Diff |
Fixed issue 18615: Data integrity SQL syntax error on Postgres when trying to fix quotas |
Affected Issues 18615 |
|
mod - application/controllers/admin/CheckIntegrity.php | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2023-02-02 18:30 | riqcles | New Issue | |
2023-02-02 18:30 | riqcles | File Added: 1.png | |
2023-02-02 18:30 | riqcles | File Added: 2.png | |
2023-02-02 18:30 | riqcles | File Added: 3.png | |
2023-02-02 18:30 | riqcles | File Added: 4.png | |
2023-02-02 18:31 | DenisChenu | Note Added: 73641 | |
2023-02-02 18:31 | DenisChenu | Bug heat | 0 => 2 |
2023-02-02 19:22 | riqcles | Note Added: 73642 | |
2023-02-02 19:22 | riqcles | File Added: Integrity_1.png | |
2023-02-02 19:22 | riqcles | File Added: Integrity_2.png | |
2023-02-02 19:22 | riqcles | File Added: Integrity_3.png | |
2023-02-02 19:22 | riqcles | File Added: Integrity_4.png | |
2023-02-02 19:22 | riqcles | File Added: Integrity_5.png | |
2023-02-02 19:22 | riqcles | Bug heat | 2 => 4 |
2023-05-03 15:03 | ollehar | Note Added: 74787 | |
2023-05-03 15:03 | ollehar | Bug heat | 4 => 6 |
2023-05-03 15:03 | ollehar | Priority | none => normal |
2023-05-03 15:03 | ollehar | Status | new => acknowledged |
2023-05-03 15:03 | ollehar | Summary | data integrity fail => Data integrity SQL syntax error on Postgres |
2023-05-05 12:23 | riqcles | Note Added: 74837 | |
2023-06-08 17:41 | c_schmitz | Note Added: 75489 | |
2023-06-08 17:41 | c_schmitz | Bug heat | 6 => 8 |
2023-06-08 17:41 | c_schmitz | Note Edited: 75489 | |
2023-06-08 18:03 | c_schmitz | Assigned To | => c_schmitz |
2023-06-08 18:03 | c_schmitz | Status | acknowledged => resolved |
2023-06-08 18:03 | c_schmitz | Resolution | open => fixed |
2023-06-08 18:19 | c_schmitz | Changeset attached | => LimeSurvey master 20775288 |
2023-06-08 18:19 | c_schmitz | Note Added: 75490 | |
2023-06-08 18:21 | c_schmitz | Changeset attached | => LimeSurvey 5.x e747eb5c |
2023-06-08 18:21 | c_schmitz | Note Added: 75493 | |
2023-06-12 10:45 | LimeBot | Note Added: 75543 | |
2023-06-12 10:45 | LimeBot | Status | resolved => closed |
2023-06-12 10:45 | LimeBot | Bug heat | 8 => 10 |