View Issue Details

This bug affects 1 person(s).
 24
IDProjectCategoryView StatusLast Update
15642Bug reports_ Unknownpublic2022-06-06 15:10
Reporterpparzer Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status feedbackResolutionreopened 
Summary15642: checking data integrity modifies column names in result tables
Description

After checking data integrity some column names of some result tables were changed, breaking the surveys. A diff of the table structure before and after the data integrity check is attached.

Steps To Reproduce

Since it is a production system I will not try to reproduce it.

TagsNo tags attached.
Attached Files
table-changes.diff (24,413 bytes)   
*** last-tables.sql	2019-12-04 14:41:01.508569998 +0100
--- tables.sql	2019-12-04 14:41:01.508569998 +0100
***************
*** 24,59 ****
    `146515X104X595` datetime DEFAULT NULL,
    `146515X104X596` text COLLATE utf8mb4_unicode_ci,
    `146515X104X597` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5981_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5981_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5981_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5982_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5982_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5982_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5983_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5983_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5983_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5984_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5984_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5984_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5985_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5985_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5985_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5991_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5991_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5991_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5992_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5992_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5992_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5993_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5993_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5993_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5994_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5994_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5994_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5995_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5995_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X104X5995_3` text COLLATE utf8mb4_unicode_ci,
    `146515X104X600` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `146515X104X601` datetime DEFAULT NULL,
    `146515X104X602` text COLLATE utf8mb4_unicode_ci,
--- 24,59 ----
    `146515X104X595` datetime DEFAULT NULL,
    `146515X104X596` text COLLATE utf8mb4_unicode_ci,
    `146515X104X597` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5981_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5981_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5981_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5982_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5982_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5982_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5983_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5983_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5983_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5984_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5984_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5984_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5985_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5985_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5985_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5991_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5991_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5991_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5992_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5992_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5992_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5993_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5993_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5993_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5994_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5994_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5994_3` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5995_1` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5995_2` text COLLATE utf8mb4_unicode_ci,
!   `146515X340X5995_3` text COLLATE utf8mb4_unicode_ci,
    `146515X104X600` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `146515X104X601` datetime DEFAULT NULL,
    `146515X104X602` text COLLATE utf8mb4_unicode_ci,
***************
*** 5738,5753 ****
    `667116X108X645m` decimal(30,10) DEFAULT NULL,
    `667116X108X646h` decimal(30,10) DEFAULT NULL,
    `667116X108X646m` decimal(30,10) DEFAULT NULL,
!   `667116X108X6471_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X108X6471_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X108X6472_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X108X6472_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X108X6473_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X108X6473_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X108X6474_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X108X6474_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X108X6475_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X108X6475_b` text COLLATE utf8mb4_unicode_ci,
    `667116X108X648` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `667116X107X631` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `667116X107X632h` decimal(30,10) DEFAULT NULL,
--- 5738,5753 ----
    `667116X108X645m` decimal(30,10) DEFAULT NULL,
    `667116X108X646h` decimal(30,10) DEFAULT NULL,
    `667116X108X646m` decimal(30,10) DEFAULT NULL,
!   `667116X361X6471_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X361X6471_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X361X6472_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X361X6472_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X361X6473_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X361X6473_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X361X6474_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X361X6474_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X361X6475_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X361X6475_b` text COLLATE utf8mb4_unicode_ci,
    `667116X108X648` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `667116X107X631` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `667116X107X632h` decimal(30,10) DEFAULT NULL,
***************
*** 5760,5775 ****
    `667116X107X636m` decimal(30,10) DEFAULT NULL,
    `667116X107X637h` decimal(30,10) DEFAULT NULL,
    `667116X107X637m` decimal(30,10) DEFAULT NULL,
!   `667116X107X6381_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X107X6381_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X107X6382_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X107X6382_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X107X6383_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X107X6383_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X107X6384_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X107X6384_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X107X6385_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X107X6385_b` text COLLATE utf8mb4_unicode_ci,
    `667116X107X639` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `667116X109X649` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `667116X109X650h` decimal(30,10) DEFAULT NULL,
--- 5760,5775 ----
    `667116X107X636m` decimal(30,10) DEFAULT NULL,
    `667116X107X637h` decimal(30,10) DEFAULT NULL,
    `667116X107X637m` decimal(30,10) DEFAULT NULL,
!   `667116X360X6381_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X360X6381_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X360X6382_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X360X6382_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X360X6383_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X360X6383_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X360X6384_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X360X6384_b` text COLLATE utf8mb4_unicode_ci,
!   `667116X360X6385_a` text COLLATE utf8mb4_unicode_ci,
!   `667116X360X6385_b` text COLLATE utf8mb4_unicode_ci,
    `667116X107X639` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `667116X109X649` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `667116X109X650h` decimal(30,10) DEFAULT NULL,
***************
*** 6947,6969 ****
    `916263X102X559` text COLLATE utf8mb4_unicode_ci,
    `916263X102X560` text COLLATE utf8mb4_unicode_ci,
    `916263X103X582` text COLLATE utf8mb4_unicode_ci,
!   `916263X103X5611` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5612` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5613` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5614` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5615` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5616` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5621` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5622` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5623` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5624` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5625` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5631` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5632` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5633` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5634` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5635` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X103X5636` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `idx_survey_token_916263_47975` (`token`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--- 6947,6969 ----
    `916263X102X559` text COLLATE utf8mb4_unicode_ci,
    `916263X102X560` text COLLATE utf8mb4_unicode_ci,
    `916263X103X582` text COLLATE utf8mb4_unicode_ci,
!   `916263X319X5611` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X319X5612` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X319X5613` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X319X5614` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X319X5615` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X319X5616` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5621` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5622` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5623` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5624` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5625` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5631` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5632` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5633` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5634` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5635` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `916263X320X5636` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `idx_survey_token_916263_47975` (`token`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
***************
*** 7981,7993 ****
    `989141X95X371` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X3721` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X3722` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3723` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3724` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3725` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3726` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3727` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3728` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3729` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X37210` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X37211` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X372other` text COLLATE utf8mb4_unicode_ci,
--- 7981,7993 ----
    `989141X95X371` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X3721` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X3722` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X213X3723` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X213X3724` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X213X3725` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X213X3726` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X213X3727` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X213X3728` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X213X3729` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X37210` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X37211` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X372other` text COLLATE utf8mb4_unicode_ci,
***************
*** 8004,8015 ****
    `989141X95X381` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X382` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X383` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3841` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3842` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3843` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3844` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3845` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X3846` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X385` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X386` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X387` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
--- 8004,8015 ----
    `989141X95X381` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X382` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X383` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X231X3841` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X231X3842` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X231X3843` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X231X3844` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X231X3845` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X231X3846` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X385` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X386` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X387` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
***************
*** 8034,8057 ****
    `989141X95X3963_art` text COLLATE utf8mb4_unicode_ci,
    `989141X95X3963_alter` text COLLATE utf8mb4_unicode_ci,
    `989141X95X3963_dauer` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3964_art` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3964_alter` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3964_dauer` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3965_art` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3965_alter` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3965_dauer` text COLLATE utf8mb4_unicode_ci,
    `989141X95X3966_art` text COLLATE utf8mb4_unicode_ci,
    `989141X95X3966_alter` text COLLATE utf8mb4_unicode_ci,
    `989141X95X3966_dauer` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3967_art` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3967_alter` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3967_dauer` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3968_art` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3968_alter` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3968_dauer` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3969_art` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3969_alter` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X3969_dauer` text COLLATE utf8mb4_unicode_ci,
    `989141X95X39610_art` text COLLATE utf8mb4_unicode_ci,
    `989141X95X39610_alter` text COLLATE utf8mb4_unicode_ci,
    `989141X95X39610_dauer` text COLLATE utf8mb4_unicode_ci,
--- 8034,8057 ----
    `989141X95X3963_art` text COLLATE utf8mb4_unicode_ci,
    `989141X95X3963_alter` text COLLATE utf8mb4_unicode_ci,
    `989141X95X3963_dauer` text COLLATE utf8mb4_unicode_ci,
!   `989141X240X3964_art` text COLLATE utf8mb4_unicode_ci,
!   `989141X240X3964_alter` text COLLATE utf8mb4_unicode_ci,
!   `989141X240X3964_dauer` text COLLATE utf8mb4_unicode_ci,
!   `989141X240X3965_art` text COLLATE utf8mb4_unicode_ci,
!   `989141X240X3965_alter` text COLLATE utf8mb4_unicode_ci,
!   `989141X240X3965_dauer` text COLLATE utf8mb4_unicode_ci,
    `989141X95X3966_art` text COLLATE utf8mb4_unicode_ci,
    `989141X95X3966_alter` text COLLATE utf8mb4_unicode_ci,
    `989141X95X3966_dauer` text COLLATE utf8mb4_unicode_ci,
!   `989141X242X3967_art` text COLLATE utf8mb4_unicode_ci,
!   `989141X242X3967_alter` text COLLATE utf8mb4_unicode_ci,
!   `989141X242X3967_dauer` text COLLATE utf8mb4_unicode_ci,
!   `989141X242X3968_art` text COLLATE utf8mb4_unicode_ci,
!   `989141X242X3968_alter` text COLLATE utf8mb4_unicode_ci,
!   `989141X242X3968_dauer` text COLLATE utf8mb4_unicode_ci,
!   `989141X242X3969_art` text COLLATE utf8mb4_unicode_ci,
!   `989141X242X3969_alter` text COLLATE utf8mb4_unicode_ci,
!   `989141X242X3969_dauer` text COLLATE utf8mb4_unicode_ci,
    `989141X95X39610_art` text COLLATE utf8mb4_unicode_ci,
    `989141X95X39610_alter` text COLLATE utf8mb4_unicode_ci,
    `989141X95X39610_dauer` text COLLATE utf8mb4_unicode_ci,
***************
*** 8066,8084 ****
    `989141X95X401other` text COLLATE utf8mb4_unicode_ci,
    `989141X95X402` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X402other` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X4031` decimal(30,10) DEFAULT NULL,
    `989141X95X4032` decimal(30,10) DEFAULT NULL,
!   `989141X95X4033` decimal(30,10) DEFAULT NULL,
    `989141X95X404` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4051` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4052` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4053` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4054` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4055` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4056` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4057` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4058` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4059` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X40510` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X40511` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X40512` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
--- 8066,8084 ----
    `989141X95X401other` text COLLATE utf8mb4_unicode_ci,
    `989141X95X402` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X402other` text COLLATE utf8mb4_unicode_ci,
!   `989141X249X4031` decimal(30,10) DEFAULT NULL,
    `989141X95X4032` decimal(30,10) DEFAULT NULL,
!   `989141X249X4033` decimal(30,10) DEFAULT NULL,
    `989141X95X404` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4051` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4052` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4053` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4054` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4055` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4056` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4057` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4058` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4059` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X40510` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X40511` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X40512` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
***************
*** 8086,8113 ****
    `989141X95X40514` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X40515` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X405other` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X4061` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4062` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4063` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4064` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4065` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4066` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4067` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X406other` text COLLATE utf8mb4_unicode_ci,
!   `989141X95X4071` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4072` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4073` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4074` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4075` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4076` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4077` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4078` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4079` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X407other` text COLLATE utf8mb4_unicode_ci,
    `989141X95X408` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4091` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4092` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X95X4093` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `idx_survey_token_989141_20845` (`token`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--- 8086,8113 ----
    `989141X95X40514` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X40515` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X405other` text COLLATE utf8mb4_unicode_ci,
!   `989141X249X4061` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4062` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4063` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4064` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4065` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4066` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4067` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X406other` text COLLATE utf8mb4_unicode_ci,
!   `989141X249X4071` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4072` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4073` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4074` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4075` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4076` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4077` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4078` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4079` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `989141X95X407other` text COLLATE utf8mb4_unicode_ci,
    `989141X95X408` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X249X4091` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X248X4092` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
!   `989141X250X4093` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `idx_survey_token_989141_20845` (`token`)
  ) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
table-changes.diff (24,413 bytes)   
Bug heat24
Complete LimeSurvey version number (& build)Version 3.25.20+210330
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionMariaDB 10.1.43
Server OS (if known)Linux v22019012905281138 4.15.0-72-generic #81-Ubuntu SMP Tue Nov 26 12:20:02 UTC 2019 x86_64
Webserver software & version (if known)Apache/2.4.29 (Ubuntu)
PHP Version 7.2.24-0ubuntu0.18.04.1

Users monitoring this issue

Activities

DenisChenu

DenisChenu

2019-12-10 08:05

developer   ~54984

Argl … bad gid for sub questions … fixed by Check integrity … but : broke survey …

pparzer

pparzer

2019-12-10 09:15

reporter   ~54985

Last edited: 2021-03-31 10:28

I created a virtual machine from the backups with the state before the integrity check.

For example for the survey 146515, the qid and gid before the check look like this:

select gid,sid from lime_groups where sid=146515;

+-----+--------+
| gid | sid |
+-----+--------+
| 104 | 146515 |
| 170 | 146515 |
+-----+--------+

select qid,parent_qid,sid,gid from lime_questions where sid=146515;

+------+------------+--------+-----+
| qid | parent_qid | sid | gid |
+------+------------+--------+-----+
| 591 | 0 | 146515 | 104 |
| 590 | 0 | 146515 | 104 |
| 592 | 0 | 146515 | 104 |
| 589 | 0 | 146515 | 104 |
| 588 | 0 | 146515 | 104 |
| 587 | 0 | 146515 | 104 |
| 586 | 0 | 146515 | 104 |
| 585 | 0 | 146515 | 104 |
| 584 | 0 | 146515 | 104 |
| 583 | 0 | 146515 | 104 |
| 593 | 0 | 146515 | 104 |
| 594 | 0 | 146515 | 104 |
| 595 | 0 | 146515 | 104 |
| 596 | 0 | 146515 | 104 |
| 597 | 0 | 146515 | 104 |
| 598 | 0 | 146515 | 104 |
| 599 | 0 | 146515 | 104 |
| 600 | 0 | 146515 | 104 |
| 601 | 0 | 146515 | 104 |
| 602 | 0 | 146515 | 104 |
| 603 | 0 | 146515 | 104 |
| 604 | 598 | 146515 | 104 |
| 605 | 598 | 146515 | 104 |
| 606 | 598 | 146515 | 104 |
| 607 | 598 | 146515 | 104 |
| 608 | 598 | 146515 | 104 |
| 609 | 598 | 146515 | 104 |
| 610 | 598 | 146515 | 104 |
| 611 | 598 | 146515 | 104 |
| 612 | 599 | 146515 | 104 |
| 613 | 599 | 146515 | 104 |
| 614 | 599 | 146515 | 104 |
| 615 | 599 | 146515 | 104 |
| 616 | 599 | 146515 | 104 |
| 617 | 599 | 146515 | 104 |
| 618 | 599 | 146515 | 104 |
| 619 | 599 | 146515 | 104 |
| 1808 | 0 | 146515 | 170 |
| 1807 | 0 | 146515 | 170 |
+------+------------+--------+-----+

They match the column names of the table lime_survey_146515. After the integrity check, the column names of the table are changed, but the tables lime_groups and lime_questions are unchanged. The integrity check replaces for some questions the correct gid 104 with the wrong gid 340. The gid 340 is from another survey.

select gid,sid from lime_groups where gid=340;
+-----+--------+
| gid | sid |
+-----+--------+
| 340 | 571954 |
+-----+--------+

So it seems there is nothing to repair by the integrity check.

DenisChenu

DenisChenu

2019-12-10 12:02

developer   ~54988

Last edited: 2021-03-31 10:28

The gid 340 is from another survey.

Then : there are an issue in integrity checker ? Put bad values for this question, right ?

pparzer

pparzer

2019-12-10 12:27

reporter   ~54989

Last edited: 2021-03-31 10:28

Yes, it must be a problem with the integrity checker. It does not report any problems (see screenshot), but breaks surveys.

DenisChenu

DenisChenu

2019-12-10 14:38

developer   ~54993

Last edited: 2021-03-31 10:28

Can you send the original sql dump ?
You can set this issue as private

pparzer

pparzer

2019-12-11 14:48

reporter   ~55009

Last edited: 2021-03-31 10:28

I cannot send you the whole database, the survey responses contain patient data. I will remove the survey responses from the dump and if the problem still exist, than I send you the cleaned database. But give me some time.

Mazi

Mazi

2020-01-08 08:53

updater   ~55146

Last edited: 2021-03-31 10:28

@cdorin, pinging you to bring this to your attention since it sounds like a very serious issue.

c_schmitz

c_schmitz

2021-03-17 13:16

administrator   ~63402

Last edited: 2021-03-31 10:28

@pparzer: I would love to work on this issue but the file cannot be downloaded. Would it be possible to provide it again?

c_schmitz

c_schmitz

2021-03-17 17:20

administrator   ~63412

Last edited: 2021-03-31 10:28

Awesome. Thank you!

c_schmitz

c_schmitz

2021-03-17 17:49

administrator   ~63417

Last edited: 2021-03-31 10:28

Ok, so I imported limesurvey.sql, logged into the administration once, then created a dump (because some DB changes were applied due to database updates from the newer 3.x version I am using) again.
Then I ran the integrity check and dumped the database again.
Compared both dumps - no change.

I did this with Version 3.25.18.

So I can see no problem here.
Can you confirm this? Are you still able to reproduce the issue using the latest version?

c_schmitz

c_schmitz

2021-03-22 23:12

administrator   ~63568

Last edited: 2021-03-31 10:28

I think I found the issue. I think it is not reproducible for me because the order in which the surveys are stored in the table matters for this bug.
By dumping and restoring the database the exact order is not preserved. Anway, I was able to find two questions that were mistaken for each other during the integrity check (I saw that in your dump diff, so that helped).

I did a blind fix because I have a good idea where the problem originates.
Please check after a new version was released next week and feel free to leave feedback, if the integrity check now behaves as expected (and does not rename anything).

c_schmitz

c_schmitz

2021-03-22 23:18

administrator   ~63569

Last edited: 2021-03-31 10:28

Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=31375

c_schmitz

c_schmitz

2021-03-22 23:21

administrator   ~63570

Last edited: 2021-03-31 10:28

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=31376

lime_release_bot

lime_release_bot

2021-03-29 12:31

administrator   ~63690

Last edited: 2021-03-31 10:28

Fixed in Release 4.4.15+210329

pparzer

pparzer

2021-03-30 14:26

reporter   ~63719

Last edited: 2021-03-31 10:28

I checked with the new version and the bug is fixed. Thank You!

pparzer

pparzer

2021-03-31 10:28

reporter   ~63732

Last edited: 2021-03-31 10:28

Please reopen the bug (s. previous notes)

c_schmitz

c_schmitz

2021-08-31 09:58

administrator   ~66227

Can we try to find this, again? I would need the production database, again and updated instructions on the messed up data after checking integrity. Could you provide that please?

Related Changesets

LimeSurvey: 3.x-LTS 89cc7fc8

2021-03-22 23:17:41

c_schmitz

Details Diff
Fixed issue 15642: Checking data integrity erroneously modifies column names in result tables Affected Issues
15642
mod - application/controllers/admin/checkintegrity.php Diff File

LimeSurvey: master 4bd86551

2021-03-22 23:20:59

c_schmitz

Details Diff
Fixed issue 15642: Checking data integrity erroneously modifies column names in result tables Affected Issues
15642
mod - application/controllers/admin/checkintegrity.php Diff File

Issue History

Date Modified Username Field Change
2019-12-04 15:28 pparzer New Issue
2019-12-04 15:28 pparzer File Added: table-changes.diff
2019-12-10 08:05 DenisChenu Note Added: 54984
2019-12-10 09:15 pparzer Note Added: 54985
2019-12-10 12:02 DenisChenu Note Added: 54988
2019-12-10 12:27 pparzer File Added: screenshot-check-data-integrity.png
2019-12-10 12:27 pparzer Note Added: 54989
2019-12-10 14:38 DenisChenu Note Added: 54993
2019-12-11 14:48 pparzer Note Added: 55009
2020-01-04 11:22 DenisChenu Issue Monitored: DenisChenu
2020-01-08 08:53 Mazi Note Added: 55146
2020-01-10 15:37 cdorin Assigned To => cdorin
2020-01-10 15:37 cdorin Status new => assigned
2020-12-28 18:43 cdorin Assigned To cdorin =>
2020-12-28 18:43 cdorin Priority none => normal
2020-12-28 18:43 cdorin Status assigned => confirmed
2020-12-28 18:43 cdorin Sync to Zoho Project => |Yes|
2021-03-15 16:32 c_schmitz Assigned To => c_schmitz
2021-03-15 16:32 c_schmitz Status confirmed => assigned
2021-03-17 13:16 c_schmitz Status assigned => feedback
2021-03-17 13:16 c_schmitz Note Added: 63402
2021-03-17 16:24 pparzer Status feedback => assigned
2021-03-17 17:20 c_schmitz Note Added: 63412
2021-03-17 17:49 c_schmitz Note Added: 63417
2021-03-17 17:49 c_schmitz Status assigned => feedback
2021-03-18 08:14 c_schmitz Note Edited: 63417
2021-03-22 22:33 c_schmitz Note View State: 63417: public
2021-03-22 23:12 c_schmitz Note Added: 63568
2021-03-22 23:14 c_schmitz Status feedback => assigned
2021-03-22 23:14 c_schmitz Sync to Zoho Project Yes => |Yes|
2021-03-22 23:15 c_schmitz Note Edited: 63568
2021-03-22 23:15 c_schmitz Note Edited: 63568
2021-03-22 23:18 c_schmitz Changeset attached => LimeSurvey 3.x-LTS 89cc7fc8
2021-03-22 23:18 c_schmitz Note Added: 63569
2021-03-22 23:18 c_schmitz Resolution open => fixed
2021-03-22 23:21 c_schmitz Changeset attached => LimeSurvey master 4bd86551
2021-03-22 23:21 c_schmitz Note Added: 63570
2021-03-22 23:21 c_schmitz Status assigned => resolved
2021-03-22 23:22 c_schmitz Issue Monitored: pedesjensen
2021-03-22 23:22 c_schmitz Issue Monitored: c_schmitz
2021-03-22 23:23 c_schmitz Issue End Monitor: c_schmitz
2021-03-29 12:31 lime_release_bot Sync to Zoho Project Yes => |Yes|
2021-03-29 12:31 lime_release_bot Note Added: 63690
2021-03-29 12:31 lime_release_bot Status resolved => closed
2021-03-30 14:26 pparzer Note Added: 63719
2021-03-31 10:28 pparzer Status closed => feedback
2021-03-31 10:28 pparzer Resolution fixed => reopened
2021-03-31 10:28 pparzer Complete LimeSurvey version number (& build) Version 3.17.7+190627 => Version 3.25.20+210330
2021-03-31 10:28 pparzer Note Added: 63732
2021-08-31 09:58 c_schmitz Note Added: 66227
2022-06-06 15:10 duvemyster Issue Monitored: duvemyster
2022-06-06 15:10 duvemyster Bug heat 22 => 24