View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
17981Bug reportsDatabase designpublic2022-03-22 19:562022-03-23 09:55
Reporterlabd1301 Assigned To 
PrioritynoneSeveritypartial_block 
Status closedResolutionduplicate 
Product Version5.2.x 
Summary17981: "check data integrity" issue
Description

Hi,
We are not able to run the "check data integrity" function anymore. We have a pretty big database with thousands of surveys. It is an Windows IIS Server and a Microsoft SQL Server Database. Error is "The conversion of the nvarchar value '12503013491' overflowed an int column' (see screenshot).
LimeSurvey 5.3.5+220314
PHP version 7.2.7

Thanks,

Steps To Reproduce

Steps to reproduce

  1. login to LimeSurvey as an admin
  2. Click "configuration" and then "Check data integrity"
  3. Wait about 30 seconds, then get an error 500.

Expected result

We would like to use this function to delete old surveys because the database is becoming too big.

Actual result

(Write here what happened instead)

TagsNo tags attached.
Attached Files
check_integrity.png (85,650 bytes)   
check_integrity.png (85,650 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)LimeSurvey 5.3.5+220314
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMS SQL Server
Server OS (if known)Windows Server 2012 R2
Webserver software & version (if known)
PHP Version7.2.7

Relationships

Relationship GraphDependency Graph
duplicate of 17458 closedadamzammit Check integrety broke with SQL error 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-03-22 20:46

developer   ~68780

Seems to be a duplicate :)
labd1301

labd1301

2022-03-22 20:58

reporter   ~68781

indeed. sorry for that.

Issue History

Date Modified Username Field Change
2022-03-22 19:56 labd1301 New Issue
2022-03-22 19:56 labd1301 File Added: check_integrity.png
2022-03-22 20:45 DenisChenu Relationship added duplicate of 17458
2022-03-22 20:46 DenisChenu Note Added: 68780
2022-03-22 20:46 DenisChenu Bug heat 0 => 2
2022-03-22 20:58 labd1301 Note Added: 68781
2022-03-22 20:58 labd1301 Bug heat 2 => 4
2022-03-23 09:55 DenisChenu Status new => closed
2022-03-23 09:55 DenisChenu Resolution open => duplicate