Index mismatch with database

[clairec]

I am using Version: 5.5.0 Community Edition

I can see Accounts in my SugarCRM database; however the Accounts do not show up in ListView, Dashlets or when I do a search to connect to a new Lead or Contact.

Accounts do not show up in the Accounts tab and I've cleared my search parameters in Search & Advanced Search.

I've gone into phpMyAdmin, but the missing VarDef is not part of my selection options.... I would truly like to see a screenshot of how a basic Account's Indexes table should look...that would enable me to see where my setup went wrong.

I've gone through the Admin-Repair sessions and this is what it has rendered

/* Table : accounts */
/*COLUMNS*/
/* INDEXES */
/*INDEX MISMATCH WITH DATABASE - idx_accnt_id_del - ROW <name> idx_accnt_id_del <type> index <fields>[0] => 'deleted' */
/* VARDEF - idx_accnt_id_del - ROW<name> idx_accnt_id_del <type> index <fields>[0] => 'id' [1] => 'deleted' */
/*INDEX MISMATCH WITH DATABASE - idx_accnt_parent_id - ROW <name> idx_accnt_parent_id <type> index <fields>[0] => 'parent_id' [1] => 'deleted' */
/* VARDEF - idx_accnt_parent_id - ROW<name> idx_accnt_parent_id <type> index <fields>[0] => 'parent_id' */
ALTER TABLE accounts DROP INDEX idx_accnt_id_del , ADD INDEX idx_accnt_id_del (id, deleted), DROP INDEX idx_accnt_parent_id , ADD INDEX idx_accnt_parent_id (parent_id);

Any help would be appreciated, this is my first post.

Thank you!

[davidboris]

Hi,

I would suggest echoing the list view query and run the same in phpmyadmin to see if there is something wrong.

Sometimes sorting fails and returns empty result too!

To echo the list query -> include/ListView/ListViewData.php

Search for $main_query around line # 296

[geraldobh]

I had the same problem! I made a manual update on database:

UPDATE accounts SET deleted = '0' WHERE account_type ='Customer'