Upgrade 6.5.20 to 7.1 database error

📦 Install & Upgrade Help
1

Hi,

I have a problem upgrading SugarCRM 6.5.20 to SuiteCRM. I use the upgrade wizard, upload the zip, do the preflight check and start upgrade.

It ended up with:

Database failure. Please refer to sugarcrm.log for details.

I then startet from beginning (using my backup), set log level to WARN and looked at sugarcrm Logfile (sugarcrm_03_2015.log)


Wed Mar 11 10:50:15 2015 [11982][1][WARN] Image icon_UpgradeWizard_32.png not found
Wed Mar 11 10:50:15 2015 [11982][1][WARN] Image dashboard.png not found
Wed Mar 11 10:50:20 2015 [11982][1][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][1][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][7f1a7218-aec7-f575-2ded-4dd404761ebf][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][7f1a7218-aec7-f575-2ded-4dd404761ebf][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][5836c43e-0d52-fb71-1921-4dd40562408b][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][5836c43e-0d52-fb71-1921-4dd40562408b][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e1d07b28-2df1-7853-b798-4e5dede9757b][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e1d07b28-2df1-7853-b798-4e5dede9757b][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][b0506901-a660-6576-46b6-4e8325409c8f][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][b0506901-a660-6576-46b6-4e8325409c8f][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][d196db22-be74-aa20-b772-4fd1c1b687e6][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][d196db22-be74-aa20-b772-4fd1c1b687e6][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][7dc90de2-d1af-fdca-5d1e-5007ca7d53bb][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][7dc90de2-d1af-fdca-5d1e-5007ca7d53bb][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][6dfd0e03-c4e5-1e45-524d-5064865635d9][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][6dfd0e03-c4e5-1e45-524d-5064865635d9][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] Formatting correction: DynamicFields->len had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] Formatting correction: DynamicFields->duplicate_merge had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] Formatting correction: DynamicFields->len had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] Formatting correction: DynamicFields->duplicate_merge had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] Formatting correction: DynamicFields->len had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] Formatting correction: DynamicFields->duplicate_merge had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] Formatting correction: DynamicFields->len had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] Formatting correction: DynamicFields->duplicate_merge had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][DEPRECATED] SugarBean.php: preprocess_fields_on_save() is deprecated
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Mar 11 10:50:20 2015 [11982][e9a32fc7-b33f-f114-7b99-5458db9418ae][FATAL] Cannot create column Query Failed: ALTER TABLE cases_cstm add COLUMN jjwg_maps_lng_c float(11,8)  NULL : MySQL error 1060: Duplicate column name 'jjwg_maps_lng_c

I have done the exact same steps (on the same server) two weeks ago with a clone of our productive SugarCRM 6.5.20 CE and it worked well back then. Despite some new leads and note, the data schema of the instance has not been changed.

I tried to manually drop the table the last FATAL error shows, but this only brings up the next error with another column (all named jjwg_) in different tables. After doing this a while and reload the browser tab I ended up with a kind of “upgrade complete” message. But Schedular page was not accessible then, and obviously something has gone wrong.

Can anyone give me a hint what I can do? What is causing this error?

I will try this next:
https://suitecrm.com/forum/installation-upgrade-help/2810-upgraded-to-7-1-4-now-my-leads-won-t-save-database-failure-please-refer-to-sugarcrm-log-for-details

2

Was able to get the upgrade run without errors by manually dropping all columns in the error log:


ALTER TABLE cases_cstm DROP COLUMN jjwg_maps_lng_c;
ALTER TABLE cases_cstm DROP COLUMN jjwg_maps_lat_c;
ALTER TABLE cases_cstm DROP COLUMN jjwg_maps_geocode_status_c;
ALTER TABLE cases_cstm DROP COLUMN jjwg_maps_address_c;

ALTER TABLE project_cstm DROP COLUMN jjwg_maps_lng_c;
ALTER TABLE project_cstm DROP COLUMN jjwg_maps_lat_c;
ALTER TABLE project_cstm DROP COLUMN jjwg_maps_geocode_status_c;
ALTER TABLE project_cstm DROP COLUMN jjwg_maps_address_c;

ALTER TABLE meetings_cstm DROP COLUMN jjwg_maps_lng_c;
ALTER TABLE meetings_cstm DROP COLUMN jjwg_maps_lat_c;
ALTER TABLE meetings_cstm DROP COLUMN jjwg_maps_geocode_status_c;
ALTER TABLE meetings_cstm DROP COLUMN jjwg_maps_address_c;

ALTER TABLE opportunities_cstm DROP COLUMN jjwg_maps_lng_c;
ALTER TABLE opportunities_cstm DROP COLUMN jjwg_maps_lat_c;
ALTER TABLE opportunities_cstm DROP COLUMN jjwg_maps_geocode_status_c;
ALTER TABLE opportunities_cstm DROP COLUMN jjwg_maps_address_c;

ALTER TABLE prospects_cstm DROP COLUMN jjwg_maps_lng_c;
ALTER TABLE prospects_cstm DROP COLUMN jjwg_maps_lat_c;
ALTER TABLE prospects_cstm DROP COLUMN jjwg_maps_geocode_status_c;
ALTER TABLE prospects_cstm DROP COLUMN jjwg_maps_address_c;

After that the upgrade works (as far as I testet). So this is a kind of solved (even if I don’t know what caused the problem)

3

Maybe is because you had already the jjwg maps module installed

best regards