Email Field Not Updating/Editing (Weird)

[kyojody]

Hi Everyone,

Thank you to the excellent community support, these forums are wonderful.

I have a strange issue, when we try to update (edit or delete) any Contact or Account's email address field(s) it does not get saved.

It is saved when creating a new Account or Contact - but not when you edit/delete it afterwards.

There are no error code or message - the email address field(s) are just not saved with an edit.

I have enabled debug mode and find no error reported in the log ? any help will be greatly appreciated!

Regards,

Jody / South Africa

[matthew]

When troubleshooting this issue, two possible places stand out as culprits right away.

When the browser sends the data to the server, the PHP that does the form processing may not be capturing the particular input you have for the email address.

The second part is when the application writes to the database. The SQL query could be mal-formed.

Try turning on debug logging in Admin >> system settings

You can then view the sugarcrm.log file and search for the email address and the SQL query keyword "UPDATE"

[kyojody]

Hi Matthew,

tried that already, when i test i set the edit email address to TESTEDIT@DEBUG.COM so that it is easy for me to search the log file.

i find no UPDATE commands, the only 1 SQL listed in the log is a SELECT on the email_address_caps column.

"Query:SELECT * FROM email_addresses WHERE email_address_caps = 'TESTEDIT@DEBUG.COM' AND deleted = 0" is all I find in the log.

any ideas?

[matthew]

I'm not really sure with out debugging it myself. You could track the $_REQUEST through different parts of the code and see what's going on. That's usually what I do.

you can use

$GLOBALS['log']->fatal("your message here. Some variable: " . $foo);

if you want to just set logging to fatal and then put in these debugging logging lines to see what's going on.

I'd probably start in ./modules/Contacts/Contact.php in the save method, if you're testing Contacts for example.

I'm pretty sure you may want to also look at ./modules/EmailAddresses module as well.

[matthew]

I'm not really sure with out debugging it myself. You could track the $_REQUEST through different parts of the code and see what's going on. That's usually what I do.

you can use

$GLOBALS['log']->fatal("your message here. Some variable: " . $foo);

if you want to just set logging to fatal and then put in these debugging logging lines to see what's going on.

I'd probably start in ./modules/Contacts/Contact.php in the save method, if you're testing Contacts for example.

I'm pretty sure you may want to also look at ./modules/EmailAddresses module as well.

[kyojody]

I cannot find any error message in the sugarcrm log file.

fatal setting produces 0 log entries.

i'm stunned and this is on my production server?