Suitecrm: Incorrect email shown ( multiple view's ) 7.10.1

[ghost]

Issue

After upgrading form 7.10 to 7.10.1 there are several issuess realted with email field.

1. In account list view email are shown twice:

1. When creating relation between account and user email while looking at account -> subpanel for contacts main email form account is shown instead of actuall contact email.

Context

I'm using backup copy of CRM in version 7.9.14, due to many problems which occured after upgrading to 7.10.x I've even set all permission to 777, compared files from 7.10 pure installation with my after upgrade but no effect. Tried on different browers and platforms Windows, Android, MacOS, Firefox, google chrome bu no effect.

In logs i get error's propably not related with issue:

Wed Mar 7 11:48:17 2018 [1472][68d92b56-f55c-b8ac-d3e1-583be9227722][ERROR] fromUser: Conversion of 2018-03-07 10:48:17 from user format d/m/Y H:i failed

Wed Mar 7 11:48:17 2018 [1472][68d92b56-f55c-b8ac-d3e1-583be9227722][ERROR] Unable to load related bean by id

Wed Mar 7 11:34:35 2018 [27444][68d92b56-f55c-b8ac-d3e1-583be9227722][ERROR] fromString: Conversion of 16/01/2018 15:17 from string failed: DateTime::__construct(): Failed to parse time string (16/01/2018 15:17) at position 0 (1): Unexpected character

With enabled error display:
Notice: Array to string conversion occurred in /var/www/crm.fortecait.pl/include/formbase.php on line 209 [2018-03-07 12:02:56] display_stack_trace caller, file: /var/www/crm.fortecait.pl/include/utils.php line#: 3533
/var/www/crm.fortecait.pl/include/formbase.phpL:209
/var/www/crm.fortecait.pl/include/formbase.phpL:219
/var/www/crm.fortecait.pl/include/MassUpdate.phpL:94
/var/www/crm.fortecait.pl/include/ListView/ListViewDisplay.phpL:240
/var/www/crm.fortecait.pl/include/ListView/ListViewSmarty.phpL:293
/var/www/crm.fortecait.pl/include/MVC/View/views/view.list.phpL:251
/var/www/crm.fortecait.pl/include/MVC/View/views/view.list.phpL:354
/var/www/crm.fortecait.pl/include/MVC/View/SugarView.phpL:207
/var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.phpL:432
/var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.phpL:375
/var/www/crm.fortecait.pl/include/MVC/SugarApplication.phpL:109
/var/www/crm.fortecait.pl/index.phpL:52
Notice: Array to string conversion occurred in /var/www/crm.fortecait.pl/include/formbase.php on line 209 [2018-03-07 12:02:56] display_stack_trace caller, file: /var/www/crm.fortecait.pl/include/utils.php line#: 3533
/var/www/crm.fortecait.pl/include/formbase.phpL:209
/var/www/crm.fortecait.pl/include/formbase.phpL:219
/var/www/crm.fortecait.pl/include/MassUpdate.phpL:94
/var/www/crm.fortecait.pl/include/ListView/ListViewDisplay.phpL:240
/var/www/crm.fortecait.pl/include/ListView/ListViewSmarty.phpL:293
/var/www/crm.fortecait.pl/include/MVC/View/views/view.list.phpL:251
/var/www/crm.fortecait.pl/include/MVC/View/views/view.list.phpL:354
/var/www/crm.fortecait.pl/include/MVC/View/SugarView.phpL:207
/var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.phpL:432
/var/www/crm.fortecait.pl/include/MVC/Controller/SugarController.phpL:375
/var/www/crm.fortecait.pl/include/MVC/SugarApplication.phpL:109
/var/www/crm.fortecait.pl/index.phpL:52

Your Environment

• SuiteCRM Version used: 7.10.1
• Browser name and version (e.g. Chrome 64.0.3282.186
• Environment name and version (e.g. MySQL, PHP 7):
• Operating System and version CentOS

[VWT4]

Unfortunately, I have to confirm that issue. The same behavior is also evident in my installation. Since the update to 7.10. The update to 7.10.1 did not fix it.

[ghost]

Are you also having problem with missing action menu on main page and not working ajax ?

[baptistethomas]

Hello,

I had the same problem,

On modules/Emails/EmailUI.php line 486,

Original : http://prntscr.com/ir0kvv
Modify : http://prntscr.com/ir0l3i

Looks like there is a problem with the value genereated by $myBean->{$emailField} for the module Leads links only.

Regards,
B.

[mrbarletta]

For all of you having the same issue it is due to a listviewdef.php change made a few month ago.

So you have to update your custom/modules/Leads/listviedef.php as shown in the commit:

https://github.com/salesagility/SuiteCRM/commit/57912ad71e0ea44c094581127f1a1dcb4e2bced1#diff-6ed04ad7e04a71b7df46e69d8b20e0ca

Please, don't do what @it7baptiste did, it will remove the HREF for the email.

[ghost]

Confirmed.

custom/modules/Accounts/metadata/listviewdefs.php

change line:
'customCode' => '{$EMAIL1_LINK}{$EMAIL1}',

to:
'customCode' => '{$EMAIL1_LINK}',

[ghost]

Just to clarify it resolves first problem. incorrect emails are still shown under account view related with contact.

[belzebub40k]

Did you also adjust _custom/modules/Contacts/metadata/listviewdefs.php_?

I adjusted Accounts and Contacts and for me the email addresses are correct now.

[ghost]

I did but still emails shown are main email account instead showing contacts actual main email

Edit:
I've tried to replicate issue on 7.10.4 offical demo but will, will doesnt work

[jbrveen]

Those commits do not work for me. In the Accounts it's giving all the same mail addresses in the Contacts Listview, however, the contacts detailview give the right mailadress. A quick checkw shows that it is indeed showing the mail adress from the Relation instead of the primary mail address from the contact. (

Problem two: sometimes at Cases it's not showing a mail address at all. See screenshots.

[mrbarletta]

@jbrveen - thats issue # 2 which I didn't address, there is another issue open for that.

[gfeser]

This bug appeared after upgrade to 7.10.4.
The link has got an additional tag /a in the tail.
<a href="mailto:[email protected]">[email protected]</a>[email protected]</a>

I solved this problem by editing the file custom/modules/Accounts/metadata/listviewdefs.php
from
'customCode' => '{$EMAIL1_LINK}{$EMAIL1}</a>',
to
'customCode' => '{$EMAIL1_LINK}',

In addition, you can delete this file.

[pgorod]

So if this is caused by an outdated file in custom, then there is no bug to fix, is there?

Did you notice that you had a warning during the upgrade saying that some files in custom were overriding a new file coming with the upgrade? These files were listed on the top of your screen, that's when you should have compared the old file with the new to see if there could be problems. this was recently added to the installer, and I don't think there's more that the installer could do...

[gfeser]

pgorod: Yes, it's no bug in this case. Yes, I saw warnings, but did not give them due attention.

[javitoron]

@mrbarletta And where can I find that issue?? I'm having the same problem but I can't find a solution... thanks!

[mrbarletta]

@javitoron - #5516 I think thats the one