Received error from update wizard - need help

[ctran-prowess]

Hello Everyone,

I just work for this company and they were using old SugarCRM 4.2.1b. They asked me to upgrade the SugarCRM 4.2.1b to SugarCRM 5.2. I tried to upgrade to SugarCRM 4.2.1 to 4.5.1l but I receive following error from the upgrade wizard doing preflight check. Can anyone help me with this issue?

Errors Found During Preflight Check: Show Bad Queries


table exists::CREATE TABLE `saved_search` ( `id` char(36) NOT NULL default '', `name` varchar(150) default NULL, `search_module` varchar(150) default NULL, `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', `assigned_user_id` char(36) default NULL, `contents` text, `description` text, PRIMARY KEY (`id`), KEY `idx_desc` (`name`,`deleted`) ) DEFAULT CHARSET=utf8


table exists::CREATE TABLE `user_preferences` ( `id` char(36) NOT NULL default '', `category` varchar(50) default NULL, `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', `assigned_user_id` char(36) NOT NULL default '', `contents` text, PRIMARY KEY (`id`), KEY `idx_userprefnamecat` (`assigned_user_id`,`category`) ) DEFAULT CHARSET=utf8

Thank you.

SugarCRM 4.2.1b, PHP 4.4.3.3, Apache 2.0.5

[bickart68]

Sugar is attempting to create tables inside of your database. According to the SQL, the tables already exist. You will have to rename or delete the 2 tables that are causing you issues.

Has somebody previously run the upgrade?

[ctran-prowess]

Thanks for your reply -bickart68.

Yes, this sugarCRM my company currently running is install and upgraded by previous employee. That person no longer with the company and he did not left any detail of all the changes and files for company. I have to recreate the SugarCRM from the scratch to duplicate the current 4.2.1b that is still running.

Do you happen to know with directory the files is located? Any help is very appreicated.