Setting up personal email accounts crashes database

SuiteCRM Forum - English Language Installation & Upgrade Help
#1

Hi Guys,

Ok so forgive me if this is the wrong place. Please advise on where this needs to go in future. Anyway I am having issues post installation of SuiteCRM MAX 7.2.1 basically everything in terms of functionality works fine and doesn’t cause any issues I can send emails out on the system email account without dramas. However as soon as I attempt to set up personal emails the whole app has a meltdown to the point I have to restart both httpd and mariadb instances in order for it to come back online.

Looking at the suitecrm.log I get this.

Thu Mar 19 13:23:01 2015 [3124][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone UTC. Please set date.timezone="UTC" in php.ini!
Thu Mar 19 13:23:01 2015 [3124][1][FATAL] Job c9703c22-f0d3-821b-8cc4-550acdcc03e2 (Perform Lucene Index) failed in CRON run
Thu Mar 19 13:24:01 2015 [3140][-none-][FATAL] Configuration variable date.timezone is not set, guessed timezone UTC. Please set date.timezone="UTC" in php.ini!
Thu Mar 19 13:24:01 2015 [3140][1][FATAL] Job 9ad8cf9b-41c6-4e00-0257-550acdb0682f (Optimise AOD Index) failed in CRON run

(I’ll correct the collation issue in the php.ini file tomorrow as per what the log says)

the sugarcrm.log reads:

Wed Mar 18 09:10:49 2015 [3534][-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 'crm.aow_workflow' doesn't exist
Wed Mar 18 09:10:49 2015 [3534][-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 'crm.aow_workflow' doesn't exist
Wed Mar 18 09:10:49 2015 [3534][-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 'crm.aow_workflow' doesn't exist
Wed Mar 18 09:10:49 2015 [3534][-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 'crm.aow_workflow' doesn't exist

Reading the documentation from what I can see appears to show little if at all info on what could be causing the issue (just how to setup emails).

I have a feeling that I have misconfigured something somewhere and so it can’t write a new email account to the database (permissions related possibly).

Anyone here able to point me in the right direction? Alternate documentation maybe? Also checking other forum posts there was something similar but it seems like it isn’t quite the google-fu/forum-fu I was looking for.

here is the link: https://suitecrm.com/community/forum%%/bug-tracker/1083-can-t-create-mailbox

However I am not sure if it is similar. Anyway guys any advice would be appreciated.

Cheers

#2

Bump anyone? No-one at all?

#3

Have you tried a repair and rebuild, right at the bottom of the page there may be sql to run ?

This looks like the AOW module has not installed correctly during the installation.

Ian.

#4

Hello,
i have the same problem, sugarcrm log gives the following error:

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

No body here!!!