Upgrade from Sugarcrm 6.5.4 to Suitecrm 7.1.8

dtosun · 10 June 2016 13:59

My Sugarcrm version is 6.5.4

When upgrade it from Sugarcrm to Suitecrm 7.1.8 version, it does not work properly. I use SugarCE Migration 6.5.x to SuiteCRM 7.1.8 package for upgrading.

Homepage is coming and some other functions are working. But when i try to quick repair from admin panel, all pages are white screen. I could not understand what is the problem

I have two server, Which are one is for Sugarcrm and other is for Suitecrm. Which side should i do upgrade to go Suitecrm?

Any advice and help i need.

My Sugarcrm 6.5.4 Server;

Php: 5.2.10
MySQL: 5.0.95

My Suitecrm Server;

Php: 7.0.4
MySQL:10.0.24

mikebeck · 10 June 2016 18:56

you need to upgrade you SugarCRM version to at least 6.5.20 (best upgrade path to start with) then you need to upgrade your php version to at least 5.3 and your MySQL version to at least 5.1, and those are just to get upgrade from Sugar to Suite

then check this https://suitecrm.com/wiki/index.php/Compatibility_Matrix to go on the rest of the upgrades

best regards

dtosun · 15 June 2016 11:21

Hi Again,

When i try to upgrade again via upgrade wizard, There is no success. I could not finish upgrade, because upgrade wizard page was being white. When i try to run upgrade wizard, permission of the my crm files are always changed. I could not finish upgrade succesfully. What is wrong? I could not know
Is there any way to upgrade it from Sugarcrm to Suitecrm?

I set my crm files permission like;
sudo chown -R www-data:www-data .
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload config_override.php

My Server Info;
My Sugarcrm version is 6.5.20
My php version is 5.4.45
My MySQL version is 5.5.50
My Server Os is Redhat 5

[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of SugarEmailAddress::save() should be compatible with SugarBean::save($check_notify = false) in /var/www/crm/html/lyocrm/include/SugarEmailAddress/SugarEmailAddress.php on line 1110
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of Person::create_export_query() should be compatible with SugarBean::create_export_query($order_by, $where) in /var/www/crm/html/lyocrm/include/SugarObjects/templates/person/Person.php on line 41
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of User::retrieve() should be compatible with Person::retrieve($id = -1, $encode = true, $deleted = true) in /var/www/crm/html/lyocrm/modules/Users/User.php on line 41
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of User::create_export_query() should be compatible with Person::create_export_query(&$order_by, &$where, $relate_link_join = '') in /var/www/crm/html/lyocrm/modules/Users/User.php on line 41
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of User::create_new_list_query() should be compatible with SugarBean::create_new_list_query($order_by, $where, $filter = Array, $params = Array, $show_deleted = 0, $join_type = '', $return_array = false, $parentbean = NULL, $singleSelect = false, $ifListForExport = false) in /var/www/crm/html/lyocrm/modules/Users/User.php on line 41
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of User::list_view_parse_additional_sections() should be compatible with SugarBean::list_view_parse_additional_sections(&$list_form) in /var/www/crm/html/lyocrm/modules/Users/User.php on line 41
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of Currency::retrieve() should be compatible with SugarBean::retrieve($id = -1, $encode = true, $deleted = true) in /var/www/crm/html/lyocrm/modules/Currencies/Currency.php on line 236
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Non-static method UploadStream::register() should not be called statically in /var/www/crm/html/lyocrm/include/entryPoint.php on line 181
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Non-static method SugarConfig::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/crm/html/lyocrm/include/SugarLogger/LoggerManager.php on line 73
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Non-static method SugarConfig::getInstance() should not be called statically, assuming $this from incompatible context in /var/www/crm/html/lyocrm/include/SugarLogger/SugarLogger.php on line 118
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Warning:  date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /var/www/crm/html/lyocrm/include/SugarLogger/SugarLogger.php on line 140
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of MysqlManager::checkQuery() should be compatible with DBManager::checkQuery($sql, $object_name = false) in /var/www/crm/html/lyocrm/include/database/MysqlManager.php on line 1497
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Notice:  Undefined index: db_port in /var/www/crm/html/lyocrm/include/database/MysqliManager.php on line 274
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of TemplateTextArea::get_db_default() should be compatible with TemplateField::get_db_default($modify = false) in /var/www/crm/html/lyocrm/modules/DynamicFields/templates/Fields/TemplateTextArea.php on line 93
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of TemplateMultiEnum::get_db_default() should be compatible with TemplateField::get_db_default($modify = false) in /var/www/crm/html/lyocrm/modules/DynamicFields/templates/Fields/TemplateMultiEnum.php on line 163
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of TemplateRadioEnum::get_db_default() should be compatible with TemplateField::get_db_default($modify = false) in /var/www/crm/html/lyocrm/modules/DynamicFields/templates/Fields/TemplateRadioEnum.php on line 133
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of ParserLabel::handleSave() should be compatible with ModuleBuilderParser::handleSave($file, $view, $moduleName, $defs) in /var/www/crm/html/lyocrm/modules/ModuleBuilder/parsers/parser.label.php on line 43
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of UndeployedRelationships::findRelatableModules() should be compatible with AbstractRelationships::findRelatableModules($includeActivitiesSubmodules = true) in /var/www/crm/html/lyocrm/modules/ModuleBuilder/parsers/relationships/UndeployedRelationships.php on line 44
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Declaration of UndeployedRelationships::build() should be compatible with AbstractRelationships::build($basepath, $installDefPrefix, $relationships) in /var/www/crm/html/lyocrm/modules/ModuleBuilder/parsers/relationships/UndeployedRelationships.php on line 44
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Fatal error:  sugar_file_put_contents_atomic() : fatal rename failure '/tmp/tempSjk3it' -> 'cache/modules/UserPreferences/UserPreferencevardefs.php' in /var/www/crm/html/lyocrm/include/utils/sugar_file_utils.php on line 187
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Non-static method LogicHook::initialize() should not be called statically in /var/www/crm/html/lyocrm/include/utils.php on line 3017
[Wed Jun 15 11:41:51 2016] [error] [client 10.18.1.57] PHP Strict Standards:  Non-static method Tracker::logPage() should not be called statically in /var/www/crm/html/lyocrm/include/utils.php on line 3028

mikebeck · 15 June 2016 11:39

dtosun, please specify in which upgrade you’re getting problems. Also check that in SuiteCRM 7.5.X you need at least PHP 5.5 https://suitecrm.com/wiki/index.php/Compatibility_Matrix, also I think that in RedHat 5 the apache user and group is apache:apache, check the documentation here https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/6/html/Deployment_Guide/ch-Web_Servers.html

best regards

dtosun · 15 June 2016 12:02

Hi mikebeck,

I m try to use SugarCE_Migration_6.5.x_to_SuiteCRM_7.1.8 package. I know RedHat 5 the apache user and group is apache:apache. Everythings are ok when check installation guide

Regards,

dtosun · 15 June 2016 12:07

Can i use sugarcrm 6.5.16 version db with new installation of suitecrm 7.0.1?

mikebeck · 15 June 2016 12:12

then you need to

sudo chown -R apache:apache .

no

try again you upgrade process with the above indication, please read the documentation https://suitecrm.com/wiki/index.php/Upgrade

best regards

dtosun · 15 June 2016 12:48

I tried it again with

sudo chown -R apache:apache .

. I could not finish the wizard. There was a blank white page.
I tried to quick repair from admin panel, there was sql code which is;

/* Table : cases */
/*COLUMNS*/
/*MISSING IN DATABASE - state -  ROW*/
/* INDEXES */
ALTER TABLE cases   add COLUMN state varchar(100)  DEFAULT 'Open' NULL ;
/* Table : contacts */
/*COLUMNS*/
/*MISSING IN DATABASE - joomla_account_id -  ROW*/
/*MISSING IN DATABASE - portal_account_disabled -  ROW*/
/*MISSING IN DATABASE - portal_user_type -  ROW*/
/* INDEXES */
ALTER TABLE contacts   add COLUMN joomla_account_id varchar(255)  NULL ,  add COLUMN portal_account_disabled bool  DEFAULT '0' NULL ,  add COLUMN portal_user_type varchar(100)  DEFAULT 'Single' NULL ;
/* Table : sugarfeed */
/*COLUMNS*/
/*MISMATCH WITH DATABASE - description -  ROW [name] => 'description'  [type] => 'varchar'  [len] => '255'  */
/* VARDEF - description -  ROW[name] => 'description'  [type] => 'text'  [dbType] => 'text'  [vname] => 'LBL_NAME'  [len] => '255'  [comment] => 'Name of the feed'  [unified_search] => '1'  [full_text_search] => 'Array'  [audited] => '1'  [merge_filter] => 'selected'  [required] => ''  */
/* INDEXES */
ALTER TABLE sugarfeed   modify COLUMN description text(255)  NULL ;

I execute it and quick repair again, it seems, crm is upgraded to 7.1.8. But when i check my data like contacts, all data are there but when i enter details of contact, there is an error which is “There was an error processing your request, please try again at a later time.”.

And also when i try to run upgrade wizard, there is a error which is “Database failure. Please refer to sugarcrm.log for details.”

Any suggestion you have?

dtosun · 24 June 2016 06:52

I solve my problem. I upgrade my sugarcrm version to 6.5.16. Then i install suitecrm version 7.0.1 by using sugarcrm 6.0.16 version db. Everything is working good.