Fatal Error in Workflow

[insto]

Hi,

I am getting a Fatal Error when trying to set conditions for a workflow.

This only happens when i select the option:

"When the target module changes and a field in a related module contains a specified value" and then i click the "module" link to select the module.

The error that i receive is:

Fatal error: Call to a member function getRelatedModuleName() on a non-object in /home/sugarins/public_html/include/VarDefHandler/VarDefHandler.php on line 95

Has any one seen this before or has suggestions on what would be causing it?

Cheers,

James

[andopes]

Hi James

What is the version of your SugarCRM instance?

Cheers

[insto]

Hi Andre,

Firstly thanks for responding.

sugar instance is Version 6.1.0 (Build 5389)

Cheers

[andopes]

Can you kindly provide screen shot regarding each page and popup for this workflow definition?
I can see the buggy line code, but now it is required to understand why does it happen.

Cheers

[insto]

Let me know if that is what you meant.

Cheers!

[andopes]

According to error and related lines on code, there is an issue at your relationships.
Edit the script include/VarDefHandler/VarDefHandler.php
and add the lines

                     $GLOBALS['log']->fatal("Parent Module: '{$this->module_object->module_dir}'");
                    $GLOBALS['log']->fatal("Child Module: '{$value_array['name']}'"); 
  

Before the line

                     if(!empty($app_list_strings['moduleList'][$this->module_object->$value_array['name']->getRelatedModuleName()])){ 
  

Around line #95.

Test again, open file sugarcrc.log, go to the tail of file and let me know the last lines.

Cheers

[insto]

Here is what was in sugarcrm.log

Mon Dec 27 10:34:26 2010 [32665][-none-][FATAL] Slow Query (time:0.115181922913
SELECT * FROM fields_meta_data WHERE custom_module='Administration' AND deleted = 0
Mon Dec 27 10:34:27 2010 [32623][1][FATAL] Slow Query (time:0.286996126175
SELECT count( DISTINCT users.id ) user_count FROM tracker, users WHERE users.id = tracker.user_id AND tracker.date_modified >= DATE_FORMAT('2010-11-27 10:34:27', '%Y-%m-%d %H:%i:%s')
Mon Dec 27 10:34:32 2010 [1899][1][FATAL] Slow Query (time:0.136945009232
SELECT accounts.id , accounts.name , accounts.website , accounts.phone_office , accounts.billing_address_country , accounts.assigned_user_id , sfav.id is_favorite FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN sugarfavorites sfav ON sfav.module ='Accounts' AND sfav.record_id=accounts.id AND sfav.assigned_user_id='1' AND sfav.deleted=0 where ((accounts.assigned_user_id = '1')) AND accounts.deleted=0 ORDER BY accounts.date_entered DESC LIMIT 0,6
Mon Dec 27 10:34:33 2010 [1899][1][FATAL] Slow Query (time:0.487534999847
SELECT count(*) c FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN sugarfavorites sfav ON sfav.module ='Accounts' AND sfav.record_id=accounts.id AND sfav.assigned_user_id='1' AND sfav.deleted=0 where ((accounts.assigned_user_id = '1')) AND accounts.deleted=0
Mon Dec 27 10:34:43 2010 [3874][-none-][FATAL] Slow Query (time:0.1632168293
SELECT category, name, value FROM config
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'teams'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'members'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'member_of'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'cases'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'tasks'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'notes'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'meetings'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'calls'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'bugs'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'contacts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'opportunities'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'quotes'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'quotes_shipto'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'project'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'leads'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'campaigns'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'contracts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'contracts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'prospect_lists'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Error fetching relationship from cache contacts_accounts
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Parent Module: 'Accounts'
Mon Dec 27 10:41:02 2010 [3688][1][FATAL] Child Module: 'contacts_accounts'


This could be an issue with a relationship i attempted to build myself when my sugarCRM when i couldnt import data correctly. I created a new Contacts to Account relationship and later found out that it was import process. I thought i had deleted the bogus relationship i had made. Does this sound like a reasonable cause?

How would i go about restoring the relationships to default and removing any bogus code out there from my earlier mistake?

Cheers,

James