Hi,
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 [220][-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 existMy 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;
exitMy 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 : yyyyyyyyyyyyyyyyyyMy 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 ?