View Issue Details

IDProjectCategoryView StatusLast Update
15642Bug reports[All Projects] _ Unknownpublic2020-01-10 15:37
Reporterpparzer Assigned Tocdorin  
PrioritynoneSeveritymajor 
Status assignedResolutionopen 
Product Version 
Target VersionFixed in Version 
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.
Complete LimeSurvey version number (& build)Version 3.17.7+190627
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database & DB-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

Activities

pparzer

pparzer

2019-12-04 15:28

reporter  

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)
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

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

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

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



screenshot-check-data-integrity.png (179,498 bytes)
DenisChenu

DenisChenu

2019-12-10 14:38

developer   ~54993

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

pparzer

pparzer

2019-12-11 14:48

reporter   ~55009

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

partner   ~55146

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

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-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