Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Data integrity check message

  • bodonne2
  • bodonne2's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 7 months ago #140153 by bodonne2
Data integrity check message was created by bodonne2
I recently updated from 2.06 to 2.50 on an instance that had some corrupted tables in the database. After the schema migration was complete, I saw the 'One or more surveys seem to be broken - please use the data integrity check tool to fix this.' message. I ran the check several times and resolved all of the reported errors, but I still keep seeing the message on the admin panel. How can I make it go away?

Data consistency check
If errors are showing up you might have to execute this script repeatedly.

All conditions meet consistency standards.
All question attributes meet consistency standards.
All default values meet consistency standards.
All quotas meet consistency standards.
All quota language settings meet consistency standards.
All quota quota members meet consistency standards.
All assessments meet consistency standards.
All answers meet consistency standards.
All surveys meet consistency standards.
All survey language settings meet consistency standards.
All questions meet consistency standards.
All groups meet consistency standards.
All old survey tables meet consistency standards.
All old token tables meet consistency standards.

No database action required!


Thanks!
The topic has been locked.
More
7 years 5 months ago #141942 by Jelle_S
Replied by Jelle_S on topic Data integrity check message
I'm having the exact same issue. Any help would be appreciated. Update was from 2.05 to 2.51.4
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 5 months ago #141946 by LouisGac
Replied by LouisGac on topic Data integrity check message
how did you updated?
The topic has been locked.
  • bodonne2
  • bodonne2's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 months ago #141947 by bodonne2
Replied by bodonne2 on topic Data integrity check message [RESOLVED]
It turns out that there were some rows in lime_surveys with NULL values. I deleted these and the message went away.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 5 months ago #141948 by LouisGac
Replied by LouisGac on topic Data integrity check message [RESOLVED]
did you update manually? Or using comfortUpdate?
if we understand what happened, maybe we could fix it for future users.

btw: nice avatar ;-)
The topic has been locked.
  • bodonne2
  • bodonne2's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
7 years 5 months ago #141949 by bodonne2
Replied by bodonne2 on topic Data integrity check message
Manual. There was pre-existing database corruption unrelated to the upgrade, but the software only seemed to half catch it.
The topic has been locked.
More
7 years 5 months ago #141952 by Jelle_S
Replied by Jelle_S on topic Data integrity check message
Manual update as well, pulled master and went to /admin, then followed the steps, did the integrity check, fixed all issues until none were left, still getting the message.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
7 years 5 months ago #141953 by LouisGac
Replied by LouisGac on topic Data integrity check message
from which build to which build?
The topic has been locked.
More
7 years 5 months ago - 7 years 5 months ago #141954 by Jelle_S
Replied by Jelle_S on topic Data integrity check message
From 2.05+ Build 140520 to 2.51.4 (not sure which build it is, commit hash is 713761459f3c8e4f8a0eb193c4ea86324e89d129).
Last edit: 7 years 5 months ago by Jelle_S.
The topic has been locked.
More
7 years 1 month ago #148774 by chrisSL
Replied by chrisSL on topic Data integrity check message
Just upgraded manually from limesurvey205plus-build150310 to limesurvey-2.62.2plus-build170203 I got the error message

"Eine oder mehrere Umfragen scheinen beschädigt zu sein - bitte nutzen Sie das Datenintegritätsüberprüfung"


After running the integrity check several times there were 187 entries left in the database table lime_surveys.

18 of these had

sid: [number]
ownerid: 0
admin: [empty] or NULL
active: N

None of the sid-Numbers had related token or survey tables.

I removed those lines and the error was solved.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose