View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
18615 | Bug reports | Installation | public | 2023-02-02 18:30 | 2023-02-02 19:27 |
Reporter | riqcles | Assigned To | |||
Priority | none | Severity | block | ||
Status | new | Resolution | open | ||
Product Version | 5.5.x | ||||
Summary | 18615: data integrity fail | ||||
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. | ||||
Bug heat | 4 | ||||
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 |
|
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 |