SuiteCRM : Installation

SuiteCRM Forum - English Language Installation & Upgrade Help
#1

Hi I tried to install the latest version 7.1 and checked the crm.log file and noticed few fatal errors can any one suggest me what these error mean and is there anything that I am missing during the installation.

Please find the log attached.

#2

Hi there,

What is your Server/MySQL/PHP setup? What permissions are set on your instance?

Thanks,

Will.

#3

Server: Localhost via UNIX socket
Software: MySQL
Software version: 5.1.61 - Source distribution
Protocol version: 10
Server charset: UTF-8 Unicode (utf8)

Apache/2.2.15 (CentOS)
Database client version: libmysql - 5.1.61
PHP extension: mysqli

PHP Version 5.4.21

Please let me know if I am missing any information.

Permission to the installation folder is seen as 777

#4

Hi there,

We are aware that SugarCRM/SuiteCRM has issues with PHP 5.4.x/5.5.x but cannot confirm if this would be related to your fatal errors. Is there any possibility of you being able to install SuiteCRM on PHP 5.3 for example and letting us know the result?

Thanks,

Will.

1 Like
#5

i did an installation on PHP 5.3 version but i see diff set of error logs this time
please find it attached.

Thanks.

Mon Apr 7 19:51:43 2014 [5664][-none-][FATAL] Query Failed: select securitygroups_default.id, securitygroups.name, securitygroups_default.module, securitygroups_default.securitygroup_id from securitygroups_default inner join securitygroups on securitygroups_default.securitygroup_id = securitygroups.id where securitygroups_default.deleted = 0 and securitygroups.deleted = 0: MySQL error 1146: Table ‘suitecrm.securitygroups_default’ doesn’t exist
Mon Apr 7 19:51:43 2014 [5664][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Mon Apr 7 19:51:43 2014 [5664][-none-][FATAL] Query Failed: select securitygroups_default.id, securitygroups.name, securitygroups_default.module, securitygroups_default.securitygroup_id from securitygroups_default inner join securitygroups on securitygroups_default.securitygroup_id = securitygroups.id where securitygroups_default.deleted = 0 and securitygroups.deleted = 0: MySQL error 1146: Table ‘suitecrm.securitygroups_default’ doesn’t exist
Mon Apr 7 19:51:43 2014 [5664][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Mon Apr 7 19:51:43 2014 [5664][-none-][FATAL] Query Failed: select securitygroups_default.id, securitygroups.name, securitygroups_default.module, securitygroups_default.securitygroup_id from securitygroups_default inner join securitygroups on securitygroups_default.securitygroup_id = securitygroups.id where securitygroups_default.deleted = 0 and securitygroups.deleted = 0: MySQL error 1146: Table ‘suitecrm.securitygroups_default’ doesn’t exist
Mon Apr 7 19:51:43 2014 [5664][-none-][FATAL] Query Failed: SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND aow_workflow.deleted = 0 : MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Mon Apr 7 19:51:43 2014 [5664][-none-][FATAL] Query Failed: select securitygroups_default.id, securitygroups.name, securitygroups_default.module, securitygroups_default.securitygroup_id from securitygroups_default inner join securitygroups on securitygroups_default.securitygroup_id = securitygroups.id where securitygroups_default.deleted = 0 and securitygroups.deleted = 0: MySQL error 1146: Table ‘suitecrm.securitygroups_default’ doesn’t exist

:
:
:
:
Mon Apr 7 19:52:58 2014 [5675][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone Asia/Colombo. Please set date.timezone=“Asia/Colombo” in php.ini!
Mon Apr 7 19:53:01 2014 [5662][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone Asia/Colombo. Please set date.timezone=“Asia/Colombo” in php.ini!
Mon Apr 7 19:53:02 2014 [5664][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone Asia/Colombo. Please set date.timezone=“Asia/Colombo” in php.ini!

#6

Yep, I am seeing the exact same thing. Some tables are not getting created apparently.

PHP 5.4 has been out for how long now? Not willing to try to dredge up 5.3 to test suitecrm, it has to work on Debian for me to use it.
If it’s in Debian then it’s been out a long time.

#7

Please note I’m not using the PRO 7.1. But I have migrated to suiteCRM CE v7.1.4
and I’m using Ubuntu 14.04.1 with latest PHP v5.5 and all my custom code is working fine.

One of your fatal errors regarding date.timezone was my experience too, but I fixed it by running #php -i
and discovered that the php.ini file for my client session was in a different place than the much older versions I’d been using for years

Here’s how I fixed that aspect.
(I do note that suiteCRM talks of using an older v5.3, and I did choose to try and go beyond that, so be aware of that personal decision)
FIXED: php with apache is bleating about set date.timezone
seen in root@absvenombuildmgr6520:/home/gaz# tail /var/www/sugarcrm/sugarcrm_01_2015.log

PHP has been trying to use a php.ini assumed to be in location /usr/local/lib/php.ini
SO: make a symbolic LINK of the real php.ini to point to that target location
and then check all the php settings with #php -i
(previously I was using /etc/php5/cli/… and /etc/php5/apache2/… php.ini

Gary

#8

Note: gazoutback is now forum member: gazza73