mysql update statement - where is it?

[netron]

i'm trying to debug a contact form (sugar 4.5.1) and i'd just like to see what mysql statement is being issued by sugar when i update a contact.

is there any way of turning on the mysql statements to print to screen for debugging purposes?

[Angel]

Enabling the debug log would be the easiest way of doing this.

To enable it, open the file log4php.properties located in the root directory of your Sugar installation.

Modify it so it looks like this:

//log4php.rootLogger=fatal, A2
//log4php.rootLogger=error, A2
//log4php.rootLogger=warn, A2
//log4php.rootLogger=info, A2
log4php.rootLogger=debug, A2

Save the file and perform your actions. The log will be written to sugarcrm.log, which is also written to your root install directory.

[netron]

thats exactly what i'm after. thank you.

[netron]

that logging of some assistance but i am no nearer to figuring out why my additional form field contents are not making their way into the sugar update query.

i can see (from doing a print_r($_POST) in index.php) that my extra field is being POSTed across
but somehow sugar transforms this into a null value when it does its mysql update.


the extra field is in modules/Contacts/vardefs , and in EditView.html

are there any gotchas with regards to adding extra form fields that i might need to be aware of?

[netron]

some details:

the field i'm trying to add to the contacts editview is "bdm"


database altered:
alter table contacts add `bdm` varchar(50) not null;

added to modules/Contacts/vardefs.php:

'bdm' => array (
'name' => 'bdm',
'vname' => 'LBL_BDM',
'type' => 'varchar',
'len' => '50',
'comment' =>'biz dev manager'
)

went into Studio - added field to contacts editview.

however the data i input into that bdm field never ends up in the contacts table - evne though i can see it in the $_POST request.

is there something else i need to tell sugar so that it recognises the field?

[netron]

not to worry - i've figured it out using custom fields instead.