nothing happens when click Next at step 2 of 2 configuration during new installation of 7.6.1

dianyuanwang · 4 May 2016 17:58

Hi

We are trying to evaluate SuiteCRM 7.6.1.
During the installation phase—http://xxx/SuiteCRM/install.php, all the requirements passed and we typed in db/admin information, then click Next.
A window (with verying db information message) flashed by, but then nothing happens. We checked DB, no database got created.
In the install.log, we saw the following:

2016-05-04 17:36:54…Connection made using host: localhost, usr: root
2016-05-04 17:36:54…Testing priviliged account…
2016-05-04 17:36:54…Connection made using host: localhost, usr: root

We also tried version 7.5.3, it seems to be working better—at lease DB/tables got created, and we saw the messages about creating db etc in the browser.
But then it just hung there and log was not updating. DB is not updating. We saw lots of errors complaining about missing tables.

We are using php5.6.4 + apache 2.4.12.

Any help is appreciated.

Dian

dianyuanwang · 5 May 2016 13:02

We are on RHEL : 2.6.32-573.18.1.el6.x86_64

dianyuanwang · 5 May 2016 14:32

Hi

can someone please help me?

BTW, we run apache/mysql all as the same non-root user. So permission should not be an issue at all.

thanks!

Dian

amariussi · 5 May 2016 14:34

I experienced the same issue and I resolved by increasing the values of certain PHP paramaters:
. max_execution_time

Additionally you may increase:
. memory_limit
. max_input_time
. post_max_size
. upload_max_filesize
. max_input_vars

I suggest that you also check:
. error_reporting
making sure that it is set for a production envirenment. For example you can use: E_ALL & ~E_DEPRECATED & ~E_NOTICE

dianyuanwang · 5 May 2016 16:08

Hi

Thanks for your reply.

yes, I have found those tips from the forum except max_input_vars.

So after changing that, still the same. Attached please find our php settings.

The problem is I could not find any error messages.

Really appreciate your help! I feel helpless.

Thanks!

Dian

amariussi · 5 May 2016 16:57

I)f it’s a fresh install you can try deleting the fle config.php and then run again the installation script.

One more thing: have you set the correct permissions before running the installation script? In case you haven’t set everything to 775. Once you have finishe the installation reset permissions to the values required by SuiteCRM. (tere are plenty of instructions on the subject in the Forum)

amariussi · 5 May 2016 16:57

If it’s a fresh install you can try deleting the fle config.php and then run again the installation script.

One more thing: have you set the correct permissions before running the installation script? In case you haven’t set everything to 775. Once you have finishe the installation reset permissions to the values required by SuiteCRM. (tere are plenty of instructions on the subject in the Forum)

dianyuanwang · 5 May 2016 17:36

Hi

thanks for the reply again.

Yes, I have set the permission to 775, and even tried 777. So I do not think it is the permission issue.

I do not find config.php under SuiteCRM directory, but find some under sub-directories and delete them all.

Still the same. nothing happens.

Anything else I can try?

thanks!

Dian

amariussi · 5 May 2016 23:14

Possibly something went wrong in the first place.

So you could try deleting everything and start again from scratch.

Are you sure that there are no errors in the logs?

dianyuanwang · 6 May 2016 13:22

Hi,

I have tried many times—deleting the whole folder and try again.

sugarcrm.log has 0 byte.
Install.log has nothing----attached.
error_log is clean–attached.

is it possible to turn on debug for the installation?

Thanks!

Dian

dianyuanwang · 6 May 2016 13:25

Not sure why I can not attach files any more.

here is from error_log of Apache server:
[Fri May 06 09:16:24.656960 2016] [authz_core:debug] [pid 22508:tid 140099807090432] mod_authz_core.c(809): [client 172.23.172.18:50629] AH01626: authorization result of : granted, referer: http://crm-sys.putnaminv.com/SuiteCRM/install.php
[Fri May 06 09:16:24.659185 2016] [authz_core:debug] [pid 22508:tid 140099805505280] mod_authz_core.c(809): [client 172.23.172.18:50624] AH01626: authorization result of Require all granted: granted, referer: http://crm-sys.putnaminv.com/SuiteCRM/install.php
[Fri May 06 09:16:24.659207 2016] [authz_core:debug] [pid 22508:tid 140099805505280] mod_authz_core.c(809): [client 172.23.172.18:50624] AH01626: authorization result of : granted, referer: http://crm-sys.putnaminv.com/SuiteCRM/install.php
[Fri May 06 09:16:24.661222 2016] [authz_core:debug] [pid 22593:tid 140099806033664] mod_authz_core.c(809): [client 172.23.172.18:50627] AH01626: authorization result of Require all granted: granted, referer: http://crm-sys.putnaminv.com/SuiteCRM/install.php
[Fri May 06 09:16:24.661233 2016] [authz_core:debug] [pid 22593:tid 140099806033664] mod_authz_core.c(809): [client 172.23.172.18:50627] AH01626: authorization result of : granted, referer: http://crm-sys.putnaminv.com/SuiteCRM/install.php

And install.log:

[sousr@linvm2544 logs]$ cat /www/content/crm-sys/docs/SuiteCRM/install.log

2016-05-06 13:16:24…installerHook: Could not find custom/install/install_hooks.php
2016-05-06 13:16:28…Begin System Check Process *************
2016-05-06 13:16:28…XML Parsing Support Found
2016-05-06 13:16:28…MBString Support Found
2016-05-06 13:16:28…ZIP Support Found
2016-05-06 13:16:28…/custom directory and subdirectory check passed
2016-05-06 13:16:28…cache directory and subdirectory check passed
2016-05-06 13:16:28…/module directory and subdirectory check passed
2016-05-06 13:16:28…/upload directory check passed
2016-05-06 13:16:28…/zip check passed
2016-05-06 13:16:28…PCRE version check passed
2016-05-06 13:16:28…installerHook: Could not find custom/install/install_hooks.php
2016-05-06 13:16:28…php.ini location found. /www/tools/php-5.6.4/lib/php.ini
2016-05-06 13:16:28…Outputting HTML for System check
2016-05-06 13:16:28…No Errors were found *************
2016-05-06 13:16:28…installerHook: Could not find custom/install/install_hooks.php
2016-05-06 13:16:30…installerHook: Could not find custom/install/install_hooks.php

amariussi · 6 May 2016 14:55

from one of the logs you posted there seem to be a bug in the install script.

The script, at around line 63 tries to open the file custom/install/install_hooks.php but this file is not there because it is in install/install_hooks.php


     63           if(file_exists('custom/install/install_hooks.php')){
     64               installLog("installerHook: Found custom/install/install_hooks.php");
     65               require_once('custom/install/install_hooks.php');
     69               installLog("installerHook: Could not find custom/install/install_hooks.php");

try copying (and leaving also the original) the whole install directory to custom/install and see if it works.
(you will end up with two install directories: one in the SuiteCRM root and the other in the custom directory.)

dianyuanwang · 6 May 2016 15:14

Hi

thanks for replying.

Well, install_hooks.php does not even exist in the downloaded 7.6.1 package (not even in 7.5.3 where we do get some progress in the installation although it failed too)

I tried to copy install to custom and still nothing happens.

Do you see this file in the package?

Thanks!

Dian

offliner · 6 May 2016 15:47

I think I had the same problem. Please look here:

https://github.com/salesagility/SuiteCRM/issues/1357

and then here:

https://github.com/gymad/SuiteCRM/commit/048a419af641d9eba4a6666a7f12e9a44f3ca20d

– Andreas

amariussi · 6 May 2016 17:03

With respect to install_hook.php I found the followingfunction in install/install_utils.php:

////////////////
////  GLOBAL utility
/**
 * Calls a custom function (if it exists) based on the first parameter,
 *   and returns result of function call, or 'undefined' if the function doesn't exist
 * @param string function name to call in custom install hooks
 * @return mixed function call result, or 'undefined'
 */
function installerHook($function_name, $options = array()){
    if(!isset($GLOBALS['customInstallHooksExist'])){
        if(file_exists('custom/install/install_hooks.php')){
            installLog("installerHook: Found custom/install/install_hooks.php");
            require_once('custom/install/install_hooks.php');
            $GLOBALS['customInstallHooksExist'] = true;
        }
        else{
            installLog("installerHook: Could not find custom/install/install_hooks.php");
            $GLOBALS['customInstallHooksExist'] = false;
        }
    }

    if($GLOBALS['customInstallHooksExist'] === false){
        return 'undefined';
    }
    else{
        if(function_exists($function_name)){
            installLog("installerHook: function {$function_name} found, calling and returning the return value");
            return $function_name($options);
        }
        else{
            installLog("installerHook: function {$function_name} not found in custom install hooks file");
            return 'undefined';
        }
    }
}

Your error log appears because

$GLOBALS['customInstallHooksExist']

is evaluated as TRUE, but install_hook.php is not found.

So, unless the functon needs to perform something really important it may also be possible that even failure to execute it may not interrupt the rest of the code.
But unfortunately I don’t know so you have to explore other things.

dianyuanwang · 6 May 2016 19:01

Andreas

yes, that did do the trick. Now it makes some progress, but got fatal error:
Fatal error: Uncaught exception ‘Zend_Search_Lucene_Exception’ with message ‘Utf8Num analyzer needs PCRE unicode support to be enabled.’ in /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num.php:62 Stack trace: #0 /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num/CaseInsensitive.php(44): Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num->__construct() #1 /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/AOD_Index.php(49): Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num_CaseInsensitive->__construct() #2 /www/content/crm-sys/docs/SuiteCRM/install/performSetup.php(243): AOD_Index->__construct() #3 /www/content/crm-sys/docs/SuiteCRM/install.php(749): require(’/www/content/cr…’) #4 {main} thrown in /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num.php on line 62

So I re-install pcre with utf8 support and then recompile PHP.

After that, the installation moved further until I got the following:

Creating SuiteCRM configuration file (config.php)

Creating SuiteCRM application tables, audit tables and relationship metadata

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php on line 493

…

Creating default SuiteCRM data

 Creating default users...   done
 Creating default scheduler jobs...   done

Populating the database tables with demo data (this may take a little while)

Warning: Invalid argument supplied for foreach() in /www/content/crm-sys/docs/SuiteCRM/modules/ProjectTask/updateDependencies.php on line 52

Fatal error: Uncaught exception ‘Exception’ with message ‘Database error. Please check suitecrm.log for details.’ in /www/content/crm-sys/docs/SuiteCRM/include/utils.php:1623 Stack trace: #0 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(347): sugar_die(‘Database error…’) #1 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(321): DBManager->registerError(‘Retrieving reco…’, ‘MySQL error 104…’, true) #2 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(191): DBManager->checkError(‘Retrieving reco…’, true) #3 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(277): MysqlManager->query(‘SELECT users.* …’, true, ‘Retrieving reco…’) #4 /www/content/crm-sys/docs/SuiteCRM/data/SugarBean.php(3834): MysqlManager->limitQuery(‘SELECT users.* …’, 0, 1, true, ‘Retrieving reco…’) #5 /www/content/crm-sys/docs/SuiteCRM/include/SugarObjects/templates/person/Person.php(83): SugarBean->retrieve(‘1’, true, true) #6 /www/content/crm-sys/docs/SuiteCRM/modu in /www/content/crm-sys/docs/SuiteCRM/include/utils.php on line 1623

suitecrm.log is empty, 0 byte.
install.log:
2016-05-06 18:53:17…DBG: SugarThemeRegistry::getDefault
2016-05-06 18:53:17…DBG: require modules/Users/Save.php

sugarcrm.log:

Fri May 6 14:52:12 2016 [37454][-none-][FATAL] Query Failed:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 ::: MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Fri May 6 14:52:12 2016 [37454][-none-][FATAL] Query Failed:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 ::: MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Fri May 6 14:53:17 2016 [37454][1][FATAL] Retrieving record by id users:1 found Query Failed:SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1::: MySQL error 1046: No database selected

Is the installation really tested and working?

Dian

dianyuanwang · 6 May 2016 19:13

That part of the code does not seem to do anything.
It is this part of the code in include/database/DBManager.php:
public function checkConnection()
{
$this->last_error = ‘’;
if (!isset($this->database)) {
$this->connect();
}else{
/** try {
$this->database->ping();
}catch(Exception $ex){
unset($this->database);
$this->connect();
}
*/
$this->connect();
}
}

I commented out as above and installation at least proceeds now. But failed at a later stage.

Populating the database tables with demo data (this may take a little while)

Warning: Invalid argument supplied for foreach() in /www/content/crm-sys/docs/SuiteCRM/modules/ProjectTask/updateDependencies.php on line 52

Fatal error: Uncaught exception ‘Exception’ with message ‘Database error. Please check suitecrm.log for details.’ in /www/content/crm-sys/docs/SuiteCRM/include/utils.php:1623 Stack trace: #0 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(347): sugar_die(‘Database error…’) #1 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(321): DBManager->registerError(‘Retrieving reco…’, ‘MySQL error 104…’, true) #2 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(191): DBManager->checkError(‘Retrieving reco…’, true) #3 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(277): MysqlManager->query(‘SELECT users.* …’, true, ‘Retrieving reco…’) #4 /www/content/crm-sys/docs/SuiteCRM/data/SugarBean.php(3834): MysqlManager->limitQuery(‘SELECT users.* …’, 0, 1, true, ‘Retrieving reco…’) #5 /www/content/crm-sys/docs/SuiteCRM/include/SugarObjects/templates/person/Person.php(83): SugarBean->retrieve(‘1’, true, true) #6 /www/content/crm-sys/docs/SuiteCRM/modu in /www/content/crm-sys/docs/SuiteCRM/include/utils.php on line 1623

dianyuanwang · 6 May 2016 19:17

Andreas

yes, that did do the trick. After commenting out the following in include/database/DBManager.php:

public function checkConnection()
{
$this->last_error = ‘’;
if (!isset($this->database)) {
$this->connect();
}else{
/** try {
$this->database->ping();
}catch(Exception $ex){
unset($this->database);
$this->connect();
}
*/
$this->connect();
}
}

Now it makes some progress, but got fatal error:
Fatal error: Uncaught exception ‘Zend_Search_Lucene_Exception’ with message ‘Utf8Num analyzer needs PCRE unicode support to be enabled.’ in /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num.php:62 Stack trace: #0 /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num/CaseInsensitive.php(44): Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num->__construct() #1 /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/AOD_Index.php(49): Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num_CaseInsensitive->__construct() #2 /www/content/crm-sys/docs/SuiteCRM/install/performSetup.php(243): AOD_Index->__construct() #3 /www/content/crm-sys/docs/SuiteCRM/install.php(749): require(’/www/content/cr…’) #4 {main} thrown in /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num.php on line 62

So I re-install pcre with utf8 support and then recompile PHP.

After that, the installation moved further until I got the following:

Creating SuiteCRM configuration file (config.php)

Creating SuiteCRM application tables, audit tables and relationship metadata

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php on line 493

…

Creating default SuiteCRM data

Creating default users… done
Creating default scheduler jobs… done

Populating the database tables with demo data (this may take a little while)

Warning: Invalid argument supplied for foreach() in /www/content/crm-sys/docs/SuiteCRM/modules/ProjectTask/updateDependencies.php on line 52

Fatal error: Uncaught exception ‘Exception’ with message ‘Database error. Please check suitecrm.log for details.’ in /www/content/crm-sys/docs/SuiteCRM/include/utils.php:1623 Stack trace: #0 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(347): sugar_die(‘Database error…’) #1 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(321): DBManager->registerError(‘Retrieving reco…’, ‘MySQL error 104…’, true) #2 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(191): DBManager->checkError(‘Retrieving reco…’, true) #3 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(277): MysqlManager->query(‘SELECT users.* …’, true, ‘Retrieving reco…’) #4 /www/content/crm-sys/docs/SuiteCRM/data/SugarBean.php(3834): MysqlManager->limitQuery(‘SELECT users.* …’, 0, 1, true, ‘Retrieving reco…’) #5 /www/content/crm-sys/docs/SuiteCRM/include/SugarObjects/templates/person/Person.php(83): SugarBean->retrieve(‘1’, true, true) #6 /www/content/crm-sys/docs/SuiteCRM/modu in /www/content/crm-sys/docs/SuiteCRM/include/utils.php on line 1623

suitecrm.log is empty, 0 byte.
install.log:
2016-05-06 18:53:17…DBG: SugarThemeRegistry::getDefault
2016-05-06 18:53:17…DBG: require modules/Users/Save.php

sugarcrm.log:

Fri May 6 14:52:12 2016 [37454][-none-][FATAL] Query Failed:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 ::: MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Fri May 6 14:52:12 2016 [37454][-none-][FATAL] Query Failed:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 ::: MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Fri May 6 14:53:17 2016 [37454][1][FATAL] Retrieving record by id users:1 found Query Failed:SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1::: MySQL error 1046: No database selected

Is the installation really tested and working?

Dian

dianyuanwang · 9 May 2016 13:05

After commenting out the following in include/database/DBManager.php:

public function checkConnection()
{
$this->last_error = ‘’;
if (!isset($this->database)) {
$this->connect();
}else{
/** try {
$this->database->ping();
}catch(Exception $ex){
unset($this->database);
$this->connect();
}
*/
$this->connect();
}
}

Now it makes some progress, but got fatal error:
Fatal error: Uncaught exception ‘Zend_Search_Lucene_Exception’ with message ‘Utf8Num analyzer needs PCRE unicode support to be enabled.’ in /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num.php:62 Stack trace: #0 /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num/CaseInsensitive.php(44): Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num->__construct() #1 /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/AOD_Index.php(49): Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num_CaseInsensitive->__construct() #2 /www/content/crm-sys/docs/SuiteCRM/install/performSetup.php(243): AOD_Index->__construct() #3 /www/content/crm-sys/docs/SuiteCRM/install.php(749): require(’/www/content/cr…’) #4 {main} thrown in /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num.php on line 62

So I re-install pcre with utf8 support and then recompile PHP.

After that, the installation moved further until I got the following:

Creating SuiteCRM configuration file (config.php)

Creating SuiteCRM application tables, audit tables and relationship metadata

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php on line 493

…

Creating default SuiteCRM data

Creating default users… done
Creating default scheduler jobs… done

Populating the database tables with demo data (this may take a little while)

Warning: Invalid argument supplied for foreach() in /www/content/crm-sys/docs/SuiteCRM/modules/ProjectTask/updateDependencies.php on line 52

Fatal error: Uncaught exception ‘Exception’ with message ‘Database error. Please check suitecrm.log for details.’ in /www/content/crm-sys/docs/SuiteCRM/include/utils.php:1623 Stack trace: #0 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(347): sugar_die(‘Database error…’) #1 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(321): DBManager->registerError(‘Retrieving reco…’, ‘MySQL error 104…’, true) #2 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(191): DBManager->checkError(‘Retrieving reco…’, true) #3 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(277): MysqlManager->query(‘SELECT users.* …’, true, ‘Retrieving reco…’) #4 /www/content/crm-sys/docs/SuiteCRM/data/SugarBean.php(3834): MysqlManager->limitQuery(‘SELECT users.* …’, 0, 1, true, ‘Retrieving reco…’) #5 /www/content/crm-sys/docs/SuiteCRM/include/SugarObjects/templates/person/Person.php(83): SugarBean->retrieve(‘1’, true, true) #6 /www/content/crm-sys/docs/SuiteCRM/modu in /www/content/crm-sys/docs/SuiteCRM/include/utils.php on line 1623

suitecrm.log is empty, 0 byte.
install.log:
2016-05-06 18:53:17…DBG: SugarThemeRegistry::getDefault
2016-05-06 18:53:17…DBG: require modules/Users/Save.php

sugarcrm.log:

Fri May 6 14:52:12 2016 [37454][-none-][FATAL] Query Failed:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 ::: MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Fri May 6 14:52:12 2016 [37454][-none-][FATAL] Query Failed:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 ::: MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Fri May 6 14:53:17 2016 [37454][1][FATAL] Retrieving record by id users:1 found Query Failed:SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1::: MySQL error 1046: No database selected

Is the installation really tested and working?

Dian
2 days 17 hours ago #31698
dianyuanwang

dianyuanwang’s Avatar

That part of the code does not seem to do anything.
It is this part of the code in include/database/DBManager.php:
public function checkConnection()
{
$this->last_error = ‘’;
if (!isset($this->database)) {
$this->connect();
}else{
/** try {
$this->database->ping();
}catch(Exception $ex){
unset($this->database);
$this->connect();
}
*/
$this->connect();
}
}

I commented out as above and installation at least proceeds now. But failed at a later stage.

Populating the database tables with demo data (this may take a little while)

Warning: Invalid argument supplied for foreach() in /www/content/crm-sys/docs/SuiteCRM/modules/ProjectTask/updateDependencies.php on line 52

Fatal error: Uncaught exception ‘Exception’ with message ‘Database error. Please check suitecrm.log for details.’ in /www/content/crm-sys/docs/SuiteCRM/include/utils.php:1623 Stack trace: #0 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(347): sugar_die(‘Database error…’) #1 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(321): DBManager->registerError(‘Retrieving reco…’, ‘MySQL error 104…’, true) #2 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(191): DBManager->checkError(‘Retrieving reco…’, true) #3 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(277): MysqlManager->query(‘SELECT users.* …’, true, ‘Retrieving reco…’) #4 /www/content/crm-sys/docs/SuiteCRM/data/SugarBean.php(3834): MysqlManager->limitQuery(‘SELECT users.* …’, 0, 1, true, ‘Retrieving reco…’) #5 /www/content/crm-sys/docs/SuiteCRM/include/SugarObjects/templates/person/Person.php(83): SugarBean->retrieve(‘1’, true, true) #6 /www/content/crm-sys/docs/SuiteCRM/modu in /www/content/crm-sys/docs/SuiteCRM/include/utils.php on line 1623
2 days 18 hours ago #31697
dianyuanwang

dianyuanwang’s Avatar

Andreas

yes, that did do the trick. Now it makes some progress, but got fatal error:
Fatal error: Uncaught exception ‘Zend_Search_Lucene_Exception’ with message ‘Utf8Num analyzer needs PCRE unicode support to be enabled.’ in /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num.php:62 Stack trace: #0 /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num/CaseInsensitive.php(44): Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num->__construct() #1 /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/AOD_Index.php(49): Zend_Search_Lucene_Analysis_Analyzer_Common_Utf8Num_CaseInsensitive->__construct() #2 /www/content/crm-sys/docs/SuiteCRM/install/performSetup.php(243): AOD_Index->__construct() #3 /www/content/crm-sys/docs/SuiteCRM/install.php(749): require(’/www/content/cr…’) #4 {main} thrown in /www/content/crm-sys/docs/SuiteCRM/modules/AOD_Index/Lib/Zend/Search/Lucene/Analysis/Analyzer/Common/Utf8Num.php on line 62

So I re-install pcre with utf8 support and then recompile PHP.

After that, the installation moved further until I got the following:

Creating SuiteCRM configuration file (config.php)

Creating SuiteCRM application tables, audit tables and relationship metadata

Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php on line 493

…

Creating default SuiteCRM data

Creating default users… done
Creating default scheduler jobs… done

Populating the database tables with demo data (this may take a little while)

Warning: Invalid argument supplied for foreach() in /www/content/crm-sys/docs/SuiteCRM/modules/ProjectTask/updateDependencies.php on line 52

Fatal error: Uncaught exception ‘Exception’ with message ‘Database error. Please check suitecrm.log for details.’ in /www/content/crm-sys/docs/SuiteCRM/include/utils.php:1623 Stack trace: #0 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(347): sugar_die(‘Database error…’) #1 /www/content/crm-sys/docs/SuiteCRM/include/database/DBManager.php(321): DBManager->registerError(‘Retrieving reco…’, ‘MySQL error 104…’, true) #2 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(191): DBManager->checkError(‘Retrieving reco…’, true) #3 /www/content/crm-sys/docs/SuiteCRM/include/database/MysqlManager.php(277): MysqlManager->query(‘SELECT users.* …’, true, ‘Retrieving reco…’) #4 /www/content/crm-sys/docs/SuiteCRM/data/SugarBean.php(3834): MysqlManager->limitQuery(‘SELECT users.* …’, 0, 1, true, ‘Retrieving reco…’) #5 /www/content/crm-sys/docs/SuiteCRM/include/SugarObjects/templates/person/Person.php(83): SugarBean->retrieve(‘1’, true, true) #6 /www/content/crm-sys/docs/SuiteCRM/modu in /www/content/crm-sys/docs/SuiteCRM/include/utils.php on line 1623

suitecrm.log is empty, 0 byte.
install.log:
2016-05-06 18:53:17…DBG: SugarThemeRegistry::getDefault
2016-05-06 18:53:17…DBG: require modules/Users/Save.php

sugarcrm.log:

Fri May 6 14:52:12 2016 [37454][-none-][FATAL] Query Failed:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 ::: MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Fri May 6 14:52:12 2016 [37454][-none-][FATAL] Query Failed:SELECT id FROM aow_workflow WHERE aow_workflow.flow_module = ‘ACLActions’ AND aow_workflow.status = ‘Active’ AND (aow_workflow.run_when = ‘Always’ OR aow_workflow.run_when = ‘On_Save’ OR aow_workflow.run_when = ‘Create’) AND aow_workflow.deleted = 0 ::: MySQL error 1146: Table ‘suitecrm.aow_workflow’ doesn’t exist
Fri May 6 14:53:17 2016 [37454][1][FATAL] Retrieving record by id users:1 found Query Failed:SELECT users.* FROM users WHERE users.id = ‘1’ AND users.deleted=0 LIMIT 0,1::: MySQL error 1046: No database selected

Is the installation really tested and working?

Dian