SugarCrm 4.0 Patch

[mgamboa]

When i try to apply the sugar patch to version 3.5.1e i use the wizard update whe press commit the sugar installation say failed in execute sql command and for some reason can't delete the version and change to 4.0 is something wrong or need diferent step to upgrade my sugar crm for explicit description it is show me when press commit

ncluding: cache/upload//upgrades/temp/IFxZ3z/scripts/post_install.php

Upgrading the database to version 4.0.0

Running SQL file 351_to_400_mysql_part1.sql
Sending query: -- MySQL upgrade script for Sugar 3.5.1 to 4.0.0, part 1 -- $Id: 351_to_400_mysql_part1.sql,v 1.15 2005/12/16 06:34:03 andrew Exp $ -- -- accounts_bugs -- ALTER TABLE `accounts_bugs` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `account_id` varchar(36) default NULL, MODIFY COLUMN `bug_id` varchar(36) default NULL ;
Sending query: -- -- accounts_cases -- ALTER TABLE `accounts_cases` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `account_id` varchar(36) default NULL, MODIFY COLUMN `case_id` varchar(36) default NULL ;
Sending query: -- -- accounts_contacts -- ALTER TABLE `accounts_contacts` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `contact_id` varchar(36) default NULL, MODIFY COLUMN `account_id` varchar(36) default NULL ;
Sending query: -- -- accounts_opportunities -- ALTER TABLE `accounts_opportunities` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `opportunity_id` varchar(36) default NULL, MODIFY COLUMN `account_id` varchar(36) default NULL ;
Sending query: -- -- acl_actions -- CREATE TABLE `acl_actions` ( `id` varchar(36) NOT NULL default '', `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_user_id` varchar(36) NOT NULL default '', `created_by` varchar(36) default NULL, `name` varchar(150) default NULL, `category` varchar(100) default NULL, `acltype` varchar(100) default NULL, `aclaccess` int(3) default NULL, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_aclaction_id_del` (`id`,`deleted`) ) ;
Sending query: -- -- acl_roles -- CREATE TABLE `acl_roles` ( `id` varchar(36) NOT NULL default '', `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_user_id` varchar(36) NOT NULL default '', `created_by` varchar(36) default NULL, `name` varchar(150) default NULL, `description` text, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_aclrole_id_del` (`id`,`deleted`) ) ;
Sending query: -- -- acl_roles_actions -- CREATE TABLE `acl_roles_actions` ( `id` varchar(36) NOT NULL default '', `role_id` varchar(36) default NULL, `action_id` varchar(36) default NULL, `access_override` int(3) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_acl_role_id` (`role_id`), KEY `idx_acl_action_id` (`action_id`) ) ;
Sending query: -- -- acl_roles_users -- CREATE TABLE `acl_roles_users` ( `id` varchar(36) NOT NULL default '', `role_id` varchar(36) default NULL, `user_id` varchar(36) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_aclrole_id` (`role_id`), KEY `idx_acluser_id` (`user_id`) ) ;
Sending query: -- -- bugs -- ALTER TABLE `bugs` CHANGE `release` `found_in_release` varchar(255) default NULL ;
Sending query: -- -- calls -- ALTER TABLE `calls` MODIFY COLUMN `duration_hours` int(2) default NULL, MODIFY COLUMN `duration_minutes` int(2) default NULL ;
Sending query: -- -- calls_contacts -- ALTER TABLE `calls_contacts` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `call_id` varchar(36) default NULL, MODIFY COLUMN `contact_id` varchar(36) default NULL, MODIFY COLUMN `accept_status` varchar(25) default 'none' ;
Sending query: -- -- calls_users -- ALTER TABLE `calls_users` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `call_id` varchar(36) default NULL, MODIFY COLUMN `user_id` varchar(36) default NULL, MODIFY COLUMN `accept_status` varchar(25) default 'none' ;
Sending query: -- -- campaign_log -- CREATE TABLE `campaign_log` ( `id` varchar(36) NOT NULL default '', `campaign_id` varchar(36) default NULL, `target_tracker_key` varchar(36) default NULL, `target_id` varchar(36) default NULL, `target_type` varchar(25) default NULL, `activity_type` varchar(25) default NULL, `activity_date` datetime default NULL, `related_id` varchar(36) default NULL, `related_type` varchar(25) default NULL, `archived` tinyint(1) default '0', `hits` int(11) default '0', `list_id` varchar(36) default NULL, `deleted` tinyint(1) default '0', `date_modified` datetime default NULL, PRIMARY KEY (`id`) ) ;
Sending query: -- -- cases_bugs -- ALTER TABLE `cases_bugs` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `case_id` varchar(36) default NULL, MODIFY COLUMN `bug_id` varchar(36) default NULL ;
Sending query: -- -- config -- ALTER TABLE `config` MODIFY COLUMN `category` varchar(32) default NULL, MODIFY COLUMN `name` varchar(32) default NULL ;
Sending query: -- -- contacts -- ALTER TABLE `contacts` MODIFY COLUMN `title` varchar(50) default NULL, MODIFY COLUMN `modified_user_id` varchar(36) default NULL ;
Sending query: -- -- contacts_bugs -- ALTER TABLE `contacts_bugs` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `contact_id` varchar(36) default NULL, MODIFY COLUMN `bug_id` varchar(36) default NULL, MODIFY COLUMN `contact_role` varchar(50) default NULL ;
Sending query: -- -- contacts_cases -- ALTER TABLE `contacts_cases` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `contact_id` varchar(36) default NULL, MODIFY COLUMN `case_id` varchar(36) default NULL, MODIFY COLUMN `contact_role` varchar(50) default NULL ;
Sending query: -- -- contacts_users -- ALTER TABLE `contacts_users` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `contact_id` varchar(36) default NULL, MODIFY COLUMN `user_id` varchar(36) default NULL ;
Sending query: -- -- currencies -- ALTER TABLE `currencies` MODIFY COLUMN `id` varchar(36) NOT NULL default '', MODIFY COLUMN `name` varchar(36) NOT NULL default '', MODIFY COLUMN `symbol` varchar(36) NOT NULL default '', MODIFY COLUMN `status` varchar(25) default NULL, MODIFY COLUMN `created_by` varchar(36) NOT NULL default '' ;
Sending query: -- -- custom_fields -- ALTER TABLE `custom_fields` MODIFY COLUMN `bean_id` varchar(36) default NULL, MODIFY COLUMN `field0` varchar(255) default NULL, MODIFY COLUMN `field1` varchar(255) default NULL, MODIFY COLUMN `field2` varchar(255) default NULL, MODIFY COLUMN `field3` varchar(255) default NULL, MODIFY COLUMN `field4` varchar(255) default NULL, MODIFY COLUMN `field5` varchar(255) default NULL, MODIFY COLUMN `field6` varchar(255) default NULL, MODIFY COLUMN `field7` varchar(255) default NULL, MODIFY COLUMN `field8` varchar(255) default NULL, MODIFY COLUMN `field9` varchar(255) default NULL ;
Sending query: -- -- dashboards -- CREATE TABLE `dashboards` ( `id` varchar(36) NOT NULL default '', `deleted` tinyint(1) NOT NULL default '0', `date_entered` datetime NOT NULL default '0000-00-00 00:00:00', `date_modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_user_id` varchar(36) NOT NULL default '', `assigned_user_id` varchar(36) default NULL, `created_by` varchar(36) default NULL, `name` varchar(100) default NULL, `description` text, `content` text, PRIMARY KEY (`id`), KEY `idx_desc` (`name`,`deleted`) ) ;
Sending query: -- -- documents -- ALTER TABLE `documents` ADD COLUMN `mail_merge_document` char(3) default 'off' AFTER `document_revision_id` ;
Sending query: -- -- email_marketing -- ALTER TABLE `email_marketing` ADD COLUMN `inbound_email_id` varchar(36) default NULL AFTER `from_name`, ADD COLUMN `status` varchar(25) NOT NULL default '' AFTER `template_id`, ADD COLUMN `all_prospect_lists` tinyint(1) default '0' AFTER `campaign_id` ;
Sending query: -- -- email_marketing_prospect_lists -- CREATE TABLE `email_marketing_prospect_lists` ( `id` varchar(36) NOT NULL default '', `prospect_list_id` varchar(36) default NULL, `email_marketing_id` varchar(36) default NULL, `date_modified` datetime default NULL, `deleted` tinyint(1) default '0', PRIMARY KEY (`id`), KEY `idx_realted_id` (`email_marketing_id`,`prospect_list_id`) ) ;
Sending query: -- -- emailman -- columns template_id, from_email, from_name, module_id, module, -- invalid_email, user_name, campaign_name, to_contact, to_prospect, -- to_lead, contact_email, prospect_email, and lead_email will be dropped -- later -- table emailman_sent will be dropped later -- ALTER TABLE `emailman` ADD COLUMN `related_id` varchar(36) default NULL AFTER `deleted`, ADD COLUMN `related_type` varchar(100) default NULL AFTER `related_id`, DROP PRIMARY KEY, CHANGE COLUMN `id` `old_id` varchar(36) NOT NULL default '', ADD COLUMN `id` int(11) NOT NULL auto_increment after `user_id`, ADD PRIMARY KEY (`id`) ;
An error has occured while running.
Query Failed: -- -- emailman -- columns template_id, from_email, from_name, module_id, module, -- invalid_email, user_name, campaign_name, to_contact, to_prospect, -- to_lead, contact_email, prospect_email, and lead_email will be dropped -- later -- table emailman_sent will be dropped later -- ALTER TABLE `emailman` ADD COLUMN `related_id` varchar(36) default NULL AFTER `deleted`, ADD COLUMN `related_type` varchar(100) default NULL AFTER `related_id`, DROP PRIMARY KEY, CHANGE COLUMN `id` `old_id` varchar(36) NOT NULL default '', ADD COLUMN `id` int(11) NOT NULL auto_increment after `user_id`, ADD PRIMARY KEY (`id`);::MySQL error 1060: Duplicate column name 'old_id'