View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
18615Bug reportsInstallationpublic2023-02-02 19:27
Reporterriqcles Assigned To 
PrioritynoneSeverityblock 
Status newResolutionopen 
Product Version5.5.x 
Summary18615: data integrity fail
Description

Hello,
I perform the data integrity test to clean the database.

After a while, I have the "Fix" button that appears.

I use the "fix" button
it runs for a while, then after an error message.

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
2023-02-02 15:34:11.252 CET [32469] INSTRUCTION: DELETE FROM "lime_quota_languagesettings" LEFT JOIN lime_quota q ON lime_quota_languagesettings.quotals_quota_id=q.id WHERE (q.id IS NULL)

I have broken down the query as follows:
SELECT * FROM "lime_quota_languagesettings" LEFT JOIN lime_quota q ON lime_quota_languagesettings.quotals_quota_id=q.id WHERE (q.id IS NULL)

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 :
select * from lime_quota as lime1

I put in screenshot the results of the 3 queries,
I don't understand the syntax error.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)Version 5.4.5+221010
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgresql 13
Server OS (if known)
Webserver software & version (if known)
PHP Version7.4.32

Users monitoring this issue

User List There are no users monitoring this issue.

Activities

riqcles

riqcles

2023-02-02 18:30

reporter  

1.png (79,960 bytes)   
1.png (79,960 bytes)   
2.png (79,361 bytes)   
2.png (79,361 bytes)   
3.png (54,335 bytes)   
3.png (54,335 bytes)   
4.png (26,825 bytes)   
4.png (26,825 bytes)   
DenisChenu

DenisChenu

2023-02-02 18:31

developer   ~73641

Seems files are not shown ?

riqcles

riqcles

2023-02-02 19:22

reporter   ~73642

After this : http://192.168.56.111/limesurvey/index.php/admin/checkintegrity?sa=fixintegrity
somes captures

Integrity_1.png (58,813 bytes)   
Integrity_1.png (58,813 bytes)   
Integrity_2.png (80,831 bytes)   
Integrity_2.png (80,831 bytes)   
Integrity_3.png (118,212 bytes)
Integrity_4.png (61,968 bytes)   
Integrity_4.png (61,968 bytes)   
Integrity_5.png (73,192 bytes)   
Integrity_5.png (73,192 bytes)   

Issue History

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