Logic hook is not working, apache crashes

[chilyroll]

Hi all,

I have added a logic hook which is not working as expected. Below is the complete code:

logic_hooks.php

 <?php
 
$hook_version=1;
$hook_array=array();
 
$hook_array['after_save']=array();
$hook_array['after_save'][]=array(1,'SetData','custom/modules/Opportunities/SetData/SetData.php','SetData','SetData');
?>  

and my logic_hook handler is:

 <?php
 
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
class SetData {  
 
    function SetData($bean, $event, $args) {
            $dbm = DBManagerFactory::getInstance();
            $sql="update accounts_cstm
                  set acc_data_id_c = '".$bean->fetched_row['data_id_c']."'
                  where id_c='".$account_data['id']."'";
            $dbm->query($sql,true,"Error updating Opportunities: ");
        }
    }
}
 
?>  

data_id_c is a Relate field which is related to the Opportunities module. I want to set acc_data_id_c to the Opp.data_id_c. It works fine and updates the DB perfectly when I look up the accounts_cstm table, but when I try to view the Account my Apache crashes and it doesn't work until I clear off the acc_data_id_c field in accounts_cstm table.

Let me know if these details are sufficient. Any kind of help is appreciated.

Thanks in advance

[Angel]

Try it like this:

    function SetData($bean, $event, $args) {  
            $sql="update accounts_cstm 
                  set acc_data_id_c = '".$bean->fetched_row['data_id_c']."' 
                  where id_c='".$account_data['id']."'"; 
            $bean->db->query($sql,true); 
        }

[chilyroll]

Hi Angel,

Thanks for the response. The thing is I am facing a strange issue. My DB is updated properly through the logic hooks, no issues in that. But once the DB is updated, my apache crashes for no reason. It works fine for some of the relate field IDs, but for some IDs it just crashes my apache and won't let me access the accounts, opp pages unless I clear that relate field value from the accounts_cstm field. I have been banging my head on this trying to figure out the issue, but no luck till now. May be something to do with the relations but not very much sure about it.

Thanks again for your response. Much appreciated!

[Angel]

Ok, I am confused. Did the change help or are you still stuck?

[chilyroll]

I am still stuck.

[andopes]

Can you see any error message at error log of your apache?

Cheers

[kuske]

Where did you set $account_data['id'] in your code?

Your function should have the header

function SetData(& $bean, $event, $args) {

[chilyroll]

@andopes: No significant or relevant messages in Apache logs.

@kuske: Just FYI I am attaching the entire code again...

logic_hook:

 <?php
 
$hook_version=1;
$hook_array=array();
 
$hook_array['after_save']=array();
$hook_array['after_save'][]=array(1,'SetSoldSystem','custom/modules/Opportunities/SetSoldSystem/SetSoldSystem.php','SetSoldSystem','SetSoldSystem');
?>  

And below is the logic hook handler:

 <?php
 
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
 
class SetSoldSystem {  
 
    function SetSoldSystem($bean, $event, $args) {
        if ($bean->sales_stage == 'Closed/Won') {
            $account_data = $bean->get_account_detail($bean->id);
            $account = new Account();
            $account->retrieve($account_data['id']);
            $account->description = 'this description is changed through the logic hook';
            $account->sun_systems_id2_c = $bean->fetched_row['sun_systems_id_c'];
 
            /*
             * Works fine if I use the System Id our couple of others but not every ID though those Sugar Objects are perfectly fine when viewed in Sugar
             */
            //$account->sun_systems_id_c = '647783da-14fd-d82c-e827-4c079d31f642';
 
            /*
             * Comment out below line as it crashes the APACHE
             */
            $account->save();
        }
    }
}
 
?>  

See if this helps...

Thanks again for you time guys!

[chilyroll]

I am getting a feeling that it's Sugar core issue. It's not able to handle the complex relationship between interlinked modules.

I will try to explain my relationship matrix here a bit and will tell you what I have done.

I have a custom module say 'TestModule'

Opportunity < 1:M > TestModule
Opportunity <1:1> Accounts

'TestModule' is itself is considerably complex and having a lot of related modules.

Currently I have a couple of relate fields on the Opportunities Detail view pages added. And it was working absolutely fine till yesterday when I added one relate field of the type 'TestModule' on Accounts page. Under some condition I set the value of that field on accounts as that of Opportunity. And then because of some complex stuff that sugar doesn't handle very well, it crashes my apache. Note that there is no relation between the Accounts and TestModule, I just added the relate field on the accounts.

I tested it on windows 7, xp and also on Ubuntu systems but no luck.

So just confirm with me that it's sugar thing only

Thanks again!

[chilyroll]

To add something more, if I delete the relationship between the Opportunity and TestModule but keep the relate fields on the Accounts as is, the page loads just fine.