Module accounts is showing bogus email addresses when the email field is blank

[gnorman2000]

In the email field in accounts, it is showing a bogus email address when the email1 or email2 field is blank in the DB table. The email is a vlaue email for one account, but it is showing on many other accounts.

System Sugar OS 5.0b
PHP
Apache
MySQL

Any Help would be good

Thanks

Garry

[datasponge]

You refer to Email1 and Email2, yet you say you are using 5.0.0b. The schema changed from 4.51 to 5.0 to independently save email addresses in their own table in order to relate any number of email addresses to any module.

The table used to relate Email addresses is email_addr_bean_rel, which relates email addresses stored in email_addresses to any Sugar bean, which can be an id to join to another module such as accounts.

Did you upgrade from 4.51? If so, you may have something left over from 4.51 that didn't get mapped properly into the new email_addresses and email_addr_bean_rel tables.

Phil

[gnorman2000]

Phil,

Hey thanks, I see what it is doing now, somehow it made alot records in the email_addr_bean_rel,table with the same email address. Not sure how it happen, I guess the best way to fix it is remove the ones that are wrong.

Thanks for your help.

Garry