Install over Sugar 6.5.15 (Build 1083) CE

Will · 5 November 2013 18:50

Hi Chad,

Currently, you need to use the upgrade wizard to upgrade to SuiteCRM. A silent upgrade may be introduced to the project, but I cannot guarantee this.

SuiteCRM is an open source, community project. As such, I’m sure a contribution of a silent upgrade path for those who require it would be a much appreciated contribution to the project.

Thanks,

Will.

hzzg6y · 15 November 2013 10:43

Hello all,

Apologies.. I am new to CRM & if I am hijacking the topic.  I need to have CRM for my small business. I initially planned for

Sugar CRM community Edition 6.5.16. Do I need to install SuiteCRM 7.0.1 on the top of SugarCRM community V6.5.16 or Can I just install SuiteCRM which also includes SugarCRM CE (any version ) within it’s bundle.

I mean just totally installing SuiteCRM is sufficient & do I need SugarCRM ?

Please advice.

Rgds,

Will · 15 November 2013 10:47

Hi there,

You can install SuiteCRM 7.0.1 as a standalone CRM instance. There is no requirement to install SugarCRM first as SuiteCRM 7.0.1 is built upon SugarCRM 6.5.16.

Thanks,

Will.

hzzg6y · 15 November 2013 11:49

Hi Will,

Thanks a lot for quick reply. Today I have downloaded

SugarCE-6.5.16 which of size 20,758 KB
SuiteCRM-7.0.1 which of size 31,844 KB.

Please can you clarify my understanding to be doubly sure.

You mean all the features of SugarCE 6.5.16 are available in SuiteCE 7.0.1
SuiteCE 7.0.1 has additional features such as reporting etc available in SugarCE & Sugar Professional.
A new CRM user can directly use SuiteCRM instead of SugarCRM to start with. He will get almost all features which are available in SugarCRM Paid or professional version.

Rgds,

Will · 15 November 2013 11:52

Hi there,

Yes. All of your points stated are correct. SuiteCRM is an open source fork of SugarCRM Community Edition with additional open source modules included and packed into one standalone CRM. Free to use and download.

Thanks,

Will.

jsneo · 24 March 2014 14:13

I am upgrading my SugarCRM 6.5.16 to SuiteCRM using the link provided but am getting a HTTP 500 error when uploading the package. Please advise what may be the cause?

Will · 24 March 2014 14:23

Hi jsneo,

What is your Server/MySQL/PHP setup? Please ensure your php.ini has the following settings:

upload_max_filesize = 60M
max_execution_time = 200
post_max_size = 120M

Please ensure you also set the recommended permissions(linux):

sudo chown -R www-data:www-data .

sudo chmod -R 755 .

sudo chmod -R 775 cache custom modules themes data upload config_override.php

Thanks,

Will.

Andreas · 24 March 2014 14:41

maybe your server has some alter problems, try to create or update your .htaccess file in your root with the following lines

AddHandler php53-cgi .php
#optional php_flag magic_quotes_gpc off
#optional php_flag display_errors off
php_value memory_limit 512M

dfijalkowski · 11 April 2014 09:58

Hi,

i tried to update my SugarCRM 6.5.16 to SuiteCRM. I get a 500 - Internal Server Error too.

PHP configuration is adjusted to the described values.

.htaccess file ist created too

Please help.

clayb · 22 April 2014 14:52

Does anyone have instructions or a link to a thread for migrating Sugar 6.5.16 professional to Suite 7.x? I’ve tried google and the forum search to no avail.

tia, clay

Matt · 22 April 2014 18:19

@dfijalkowski - if you can check your php error log and see if it showing any errors,

@clayb - If you are not using anything that is not in Sugar CE it would faily simple, if not, you would need to write migration script or something to translate the data from sugar pro to the suite equivalent, if it exists

clayb · 22 April 2014 18:30

Thanks Matt,
I’ve got a lot of custom stuff, plus a lot of workflows on webforms.
I worked it out after I found it was dumping the errors in to /var/log/apache2/error.log

I’ve managed to get upgraded to 7.1.1, now I just need an export function for my workflows that will match the import.

prashantcafe · 9 May 2014 06:24

I tried to upgrade SugarCrm 6.5.16 using upgrade path to

SuiteCRM upgrade from 6.5.X to 7.0.2, now when i tried to upgrade from 7.0.2 to 7.1.1 , i started getting error in upgrade wizard running itself in 1st phase system check :

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

Sugarcrm log says this:



Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: CREATE TABLE temp (id varchar(36)): MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: INSERT INTO temp (id) VALUES ('abcdef0123456789abcdef0123456789abcd'): MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: UPDATE temp SET id = '100000000000000000000000000000000000' WHERE id = 'abcdef0123456789abcdef0123456789abcd': MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: SELECT id FROM temp WHERE id='100000000000000000000000000000000000' LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Get One Failed:SELECT id FROM temp WHERE id='100000000000000000000000000000000000': MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: DELETE FROM temp WHERE id = '100000000000000000000000000000000000': MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: ALTER TABLE temp add COLUMN test varchar(50)  NULL : MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: ALTER TABLE temp modify COLUMN test varchar(100)  NULL : MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: ALTER TABLE temp drop COLUMN test: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: DROP TABLE IF EXISTS temp: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL] Checking privileges: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: SELECT version() version LIMIT 0,1: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Get One Failed:SELECT version() version: MySQL error 2006: MySQL server has gone away
Fri May  9 05:52:43 2014 [462959][1][FATAL]  Query Failed: SELECT id FROM upgrade_history ORDER BY date_entered desc: MySQL error 2006: MySQL server has gone away

Sugarcrm error log says this:


[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Declaration of SugarEmailAddress::save() should be compatible with SugarBean::save($check_notify = false) in /home/******/public_html/crm1/include/SugarEmailAddress/SugarEmailAddress.php on line 1110
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Declaration of Person::create_export_query() should be compatible with SugarBean::create_export_query($order_by, $where) in /home/********/public_html/crm1/include/SugarObjects/templates/person/Person.php on line 41
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Declaration of User::retrieve() should be compatible with Person::retrieve($id = -1, $encode = true, $deleted = true) in /home/*********/public_html/crm1/modules/Users/User.php on line 41
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Declaration of User::create_export_query() should be compatible with Person::create_export_query(&$order_by, &$where, $relate_link_join = '') in /home/********/public_html/crm1/modules/Users/User.php on line 41
[09-May-2014 05:54:13 Etc/GMT] 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 /home/******/public_html/crm1/modules/Users/User.php on line 41
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Declaration of User::list_view_parse_additional_sections() should be compatible with SugarBean::list_view_parse_additional_sections(&$list_form) in /home/*******/public_html/crm1/modules/Users/User.php on line 41
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Declaration of Currency::retrieve() should be compatible with SugarBean::retrieve($id = -1, $encode = true, $deleted = true) in /home/********/public_html/crm1/modules/Currencies/Currency.php on line 236
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Non-static method UploadStream::register() should not be called statically in /home/*******/public_html/crm1/include/entryPoint.php on line 181
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Non-static method SugarConfig::getInstance() should not be called statically, assuming $this from incompatible context in /home/********/public_html/crm1/include/SugarLogger/LoggerManager.php on line 73
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Non-static method SugarConfig::getInstance() should not be called statically, assuming $this from incompatible context in /home/********/public_html/crm1/include/SugarLogger/SugarLogger.php on line 118
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Declaration of MysqlManager::checkQuery() should be compatible with DBManager::checkQuery($sql, $object_name = false) in /home/*******/public_html/crm1/include/database/MysqlManager.php on line 1497
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Non-static method LogicHook::initialize() should not be called statically in /home/*********/public_html/crm1/include/entryPoint.php on line 236
[09-May-2014 05:54:13 Etc/GMT] PHP Strict Standards:  Only variables should be passed by reference in /home/***********/public_html/crm1/modules/vCals/vCal.php on line 99
[09-May-2014 05:54:14 Etc/GMT] PHP Strict Standards:  Non-static method LogicHook::initialize() should not be called statically in /home/*********/public_html/crm1/include/utils.php on line 3014
[09-May-2014 05:54:14 Etc/GMT] PHP Strict Standards:  Non-static method Tracker::logPage() should not be called statically in /home/********/public_html/crm1/include/utils.php on line 3025
[09-May-2014 05:54:14 Etc/GMT] PHP Strict Standards:  Non-static method SugarConfig::getInstance() should not be called statically in /home/***********/public_html/crm1/include/utils/sugar_file_utils.php on line 362
[09-May-2014 05:54:14 Etc/GMT] PHP Strict Standards:  Non-static method SugarConfig::getInstance() should not be called statically in /home/*********/public_html/crm1/include/utils/sugar_file_utils.php on line 362

My PHP info is :Check my PHP info here

prashantcafe · 12 May 2014 14:03

Pls help … what could be the solution.

dev77 · 12 May 2014 16:26

My guess is that this is a password issue with mySQL. You need to use the password and user name in the Suite config file that allows SuiteCRM FULL privileges to the database.

The other stuff about Strict standards has to do with PHP 5.4 and as I remember there are posts here on how to get around it via adding something to the php.ini or the .htaccess file.

dbphoto84 · 12 May 2014 20:44

Where can we get these upgrade scripts now that the website has changed?

Ian · 13 May 2014 07:27

Hi,

You can obtain the upgrade scripts from this link,

http://www.suitecrm.com/index.php?option=com_content&view=article&id=127&Itemid=483

You will have to be logged in to get them

Thanks,

Ian.

prashantcafe · 13 May 2014 13:35

hi ive tried upgrading through this link only … but getting the error as conveyed in my earlier post.

the user name & pwd are correct. strict standard error can be handled but what about this : Database failure. Please refer to sugarcrm.log for details.

Already have QuickCrm Mobile Pro & Workflow process by SierraCrm installed in the base version.

Ian · 13 May 2014 13:41

Hi,

The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection. Looking at the errors you posted previously I would suggest looking at the mysql config file and check the limits that have been set and maybe raise them and see if that helps ?

Thanks,

Ian.

bbueltel · 21 May 2014 17:44

Hi Will,

The link for migration takes you to the suitecrm home page. Please advise if this is the intent.