Quick Repair keeps saying Differences found between database and vardefs

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Differences found between database and vardefs

/* Table : users */
/*COLUMNS*/
/* INDEXES */
/*INDEX MISMATCH WITH DATABASE - idx_user_name -  ROW <name> idx_user_name <type> index <fields>[0] => 'user_name'  [1] => 'is_group'  [2] => 'status'  [3] => 'last_name'  [4] => 'first_name'  [5] => 'id'  */
/* VARDEF - idx_user_name -  ROW<name> idx_user_name <type> index <fields>[0] => 'user_name'  [1] => 'is_group'  [2] => 'status'  [3] => 'last_name (30)'  [4] => 'first_name (30)'  [5] => 'id'  */
ALTER TABLE users   DROP INDEX idx_user_name,  ADD INDEX idx_user_name (user_name,is_group,status,last_name (30),first_name (30),id);

When I click Execute it says ā€œDatabase tables are synced with vardefsā€, but it is still there when I run Quick Repair again. How can I solve this? Log attached

Version 7.11.7

2

Got the exact same issue (with the same query), here is another topic where admin are trying to help us :

https://suitecrm.com/suitecrm/forum/installation-upgrade-help/27257-upgrage-from-7-11-7-to-7-11-8-failed

If I found a fix Iā€™ll post it there.

3

Hi @farkle @holdusback

Iā€™ve been working in a fix for this issue here.

Would be great if you can test this fix.
You can read an explanation of the issue here

Long story short: SuiteCRM is not detecting correctly these index and drop and create it every time you run QuickRepair.

Regards
Jose

1 Like