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!

I'm having the exact same issue. Any help would be appreciated. Update was from 2.05 to 2.51.4

how did you updated?

It turns out that there were some rows in lime_surveys with NULL values. I deleted these and the message went away.

did you update manually? Or using comfortUpdate?
if we understand what happened, maybe we could fix it for future users.

btw: nice avatar

Manual. There was pre-existing database corruption unrelated to the upgrade, but the software only seemed to half catch it.

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.

from which build to which build?

From 2.05+ Build 140520 to 2.51.4 (not sure which build it is, commit hash is 713761459f3c8e4f8a0eb193c4ea86324e89d129).

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.