Error with repair database

[aheuermann]

I get this error when running repair database. I am running open source 4.2.0d. I am

Error creating table: repair_table: Query Failed:create table repair_table (id char(36) NOT NULL ,deleted bool DEFAULT '0' NOT NULL ,date_entered datetime NOT NULL ,date_modified datetime NOT NULL ,modified_user_id char(36) ,assigned_user_id char(36) ,created_by char(36) ,salutation varchar(5) ,first_name varchar(100) ,last_name varchar(100) ,lead_source varchar(100) ,title varchar(50) ,department varchar(100) ,reports_to_id char(36) ,birthdate date ,do_not_call varchar(3) DEFAULT '0' ,phone_home varchar(25) ,phone_mobile varchar(25) ,phone_work varchar(25) ,phone_other varchar(25) ,phone_fax varchar(25) ,email1 varchar(100) ,email2 varchar(100) ,assistant varchar(75) ,assistant_phone varchar(25) ,email_opt_out varchar(3) DEFAULT '0' ,primary_address_street varchar(150) ,primary_address_city varchar(100) ,primary_address_state varchar(100) ,primary_address_postalcode varchar(20) ,primary_address_country varchar(100) ,alt_address_street varchar(150) ,alt_address_city varchar(100) ,alt_address_state varchar(100) ,alt_address_postalcode varchar(20) ,alt_address_country varchar(100) ,description text ,portal_name varchar(255) ,portal_active bool DEFAULT '0' NOT NULL ,portal_app varchar(255) ,invalid_email bool DEFAULT 0 , , PRIMARY KEY (id), KEY idx_cont_last_first (last_name, first_name, deleted), KEY idx_contacts_del_last (deleted, last_name), KEY idx_cont_del_reports (deleted, reports_to_id, last_name), KEY idx_cont_assigned (assigned_user_id), KEY idx_cont_email1 (email1), KEY idx_cont_email2 (email2))::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' PRIMARY KEY (id), KEY idx_cont_last_first (last_name, first_name, deleted), ' at line 1

Thanks in advance for any help!

Nevermind, the error is resolved, I was doing some customizations and forgot to delete a customization file of a module I uninstalled. I commented out the code and everything works fine.

[bands]

When i click on the Repair Database , Am getting following errors.

Warning: Invalid argument supplied for foreach() in C:\Program Files\xampp\htdocs\sugar_remote\include\database\D BManager.php on line 337

Warning: Invalid argument supplied for foreach() in C:\Program Files\xampp\htdocs\sugar_remote\include\database\D BManager.php on line 337
/* Table : files */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - id - ROW [Field] => 'id' [Type] => 'varchar(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
/* VARDEF - id - ROW[Field] => 'id' [Type] => 'char(36)' [Null] => 'NO' [Key] => 'PRI' [Default] => '' [Extra] => '' */
alter table files modify column id char(36) NOT NULL
/*INDEXES/*
/* Table : problem */
/*COLUMNS/*
/*INDEXES/*
/*MISSING INDEX IN DATABASE - keywords_index -fulltext ROW/*
ALTER TABLE problem ADD
/* Table : files */
/*COLUMNS/*
/*MISMATCH WITH DATABASE - assigned_user_id - ROW [Field] => 'assigned_user_id' [Type] => 'char(36)' [Null] => 'YES' [Key] => 'MUL' [Default] => '' [Extra] => '' */
/* VARDEF - assigned_user_id - ROW[Field] => 'assigned_user_id' [Type] => 'varchar(36)' [Null] => 'YES' [Key] => 'MUL' [Default] => '' [Extra] => '' */
alter table files modify column assigned_user_id varchar(36)
/*INDEXES/*

How to resolve these.