I have a Debian Jessie uptodate with nginx and mariadb (mysql). I have followed SuiteCRM installation instructions, but pressing the install button leads to error.
Here is the install.log and what sugarcrm.log says many times:
Thu Sep 3 15:51:14 2015 [-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 'alainsuitecrm.aow_workflow' doesn't exist
My database user is defined with :
mysql -p CREATE USER 'alain'@'localhost' IDENTIFIED BY 'xxxxxxxxxxxxxxxxxx'; CREATE USER 'alain'@'%' IDENTIFIED BY 'xxxxxxxxxxxxxxxxxx'; CREATE DATABASE alainsuitecrm; #GRANT ALL PRIVILEGES ON alainsuitecrm.* TO 'alain'@'localhost' WITH GRANT OPTION; #GRANT ALL PRIVILEGES ON alainsuitecrm.* TO 'alain'@'%' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'alain'@'localhost' WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO 'alain'@'%' WITH GRANT OPTION; FLUSH PRIVILEGES; exit
My SuiteCRM install settings are:
Name of the database : alainsuitecrm Name of web server : localhost database username : alain user password : xxxxxxxxxxxxxxxxxx SuiteCRM Database Username : Same as Admin User admin name : admin admin password : yyyyyyyyyyyyyyyyyy
My php setup meets SuiteCRM requirements: phpinfo.
The install.log shows that the table aow_workflow is created, while sugarcrm.log shows this table does not exist ! I could see in other OP with the same issue that mysql user rights are suspected, but my setup looks correct ? Any idea please ?