$GLOBALS["db"]->query()  not working in before save logic hook

If you use before save logic hook in module Users, Sugar logic overwrites field [Description].

You need use this:

function customHook(&$focus, $event, $arguments){
    $focus->description = 'test';
}

Update the bean instead

$user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');

$user->description = 'Test';

Hi Gustav Lindstrom

    I have tried

$user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');

$user->description = 'Test';

    but it wasnt working.

You also need this:

$user->save();

Hi Anand Chitikela,

Have you tried like global $db; to get $db instead of creating db instance.

Can you please try below two possibilities

1.

global $db;

$res = $db->query("UPDATE users SET description='test' WHERE id='27283e5a-8f34-b846-367a-561fbbb4cb54'");

2.

require_once('data/BeanFactory.php');

$user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');

$user->description = 'Test';

$user->save();

Thanks!.

If it's an before save hook and it's the same record/bean that jst got saved he can't do a save bean, that will create a infinite loop. He should do it the way Roman adviced, change bean that is handed with the function.

Hi Roman and Gustav

     I am currently work in on sugarcrm version 7.6.I have used

class logic_hooks_class{

     function before_save_method($bean, $event, $arguments){

                    $user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');

                    $user->description = 'Test';

                    $user->save();//line 8

            }

But this was throwing

Fatal error: Call to undefined method stdClass::save() in /<>/custom/modules/Users/logic_hooks_class.php on line 8

Hi Roman and Gustav

     I am currently work in on sugarcrm version 7.6.I have used

class logic_hooks_class{

     function before_save_method($bean, $event, $arguments){

                    $user= BeanFactory::getBean('users', '27283e5a-8f34-b846-367a-561fbbb4cb54');

                    $user->description = 'Test';

                    $user->save();//line 8

            }

But this was throwing

Fatal error: Call to undefined method stdClass::save() in /<>/custom/modules/Users/logic_hooks_class.php on line 8

The bean you're changing is it the same that triggers the hook? If it's not I would not use an before save hook but an after instead. If it is you can't save it, as I sad earlier.

     function before_save_method($bean, $event, $arguments){

                    $bean->description = 'Test';

      }

Hi Gustav

     Actually i want to execute an sql query inside the logic hook as a start up i am  using the above query as a sample.The code($bean->description="Test") is updating the description field.But i want an sql query to get executed in side the logic hook.

Okay, try the exact same thing you did initially, but with an after save hook. Also do a log call to make sure it running.

$GLOBALS['log']->fatal('Database update');

Hi Gustav

The crm is throwing this error when we save

Fatal error: Call to undefined method stdClass::save() in /<>/custom/modules/Users/logic_hooks_class.php

Didn't you want to do an database update?

If the method don't exist you might need to add the following line.

require_once 'modules/Users/User.php';