AnsweredAssumed Answered

Quick repair returns "Database failure. Please refer to sugarcrm.log for details."

Question asked by Arvo Bowen on Jun 12, 2014
Latest reply on Jun 19, 2014 by Arvo Bowen
sugarcrm_06_2014.log contents...
Thu Jun 12 11:48:54 2014 [9263][1][FATAL] Executing repair query:  Query Failed: CREATE TABLE lg_portaluser (id char(36)  NOT NULL ,name varchar(30)  NULL ,date_entered datetime  NULL ,date_modified datetime  NULL ,modified_user_id char(36)  NULL ,created_by char(36)  NULL ,description text  NULL ,deleted bool  DEFAULT '0' NULL ,assigned_user_id char(36)  NULL ,password varchar(255)  NULL ,status varchar(100)  DEFAULT 'active' NULL ,role varchar(100)  NULL  , PRIMARY KEY (id),   KEY idx_lg_portaluser_tmst_id (team_set_id)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1072: Key column 'team_set_id' doesn't exist in table
So right off the bat I see this ... "Key column 'team_set_id' doesn't exist in table".  Since I'm using the community edition of SugarCRM shouldn't "teams" be taken out of the whole equation??

Any ideas on how to fix this?  Currently I can not open up any cases and it says on the GUI that it has something to do with Ajax.

Using SugarCRM Community Edition - Version 6.5.16 (Build 1082)
I do have one custom module I have built for it and have disabled Ajax for that module via the Admin->System Settings-> "Configure AJAX User Interface".

Outcomes