HELP! Email addresses in custom module disappeared

[climbing-alien]

Hi

I have a custom module based on the accounts module.

All the emails for all the fields have stopped showing up in both edit and list views.

They are in the database but no longer displaying!

I _THINK_ the ID that the SQL is using is wrong.

In email_addresses the ID is 19928052-9cb5-d8a1-2e81-4d23f777cd50

but the query seems to be

01/05/11 05:10:20 [13512][1][INFO] Query:SELECT ea.*, ear.* FROM email_addresses ea
LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE ear.bean_module = 'gihl_agent_copmany_accounts'
AND ear.bean_id = '2e05cea7-17d2-2518-2d96-4d23eb378b78'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC

This maybe the wrong things Im looking at.

Please help as Im utterly lost with this and employers are breathing down my kneck.

Thanks in advance.

SugarCRM 6.1.0

[davidboris]

Hello,

Can you elaborate the issue a bit in detail? A screenshot will be a good help. What exactly you did and such issue arose? Did you import records for custom module or something like that?

[climbing-alien]

Hello

It is just the most basic accounts custom module though i have changed its name. Created in the module builder.

I had imported some 100 records into it.

I had not entered any other data into it previously.

i have now created a test record with email addresses. They are being stored into the database but are not displaying in record display page or the list view. The emails are all just blank as if the email had never been entered.

ive done a quick repair and rebuild also.

[davidboris]

Hello,

I tried to do what you have explained here with exactly the same version of Sugar, but could not regenerate same issue. Could you attach the module's zip here if not prohibited?

[climbing-alien]

hi

i think this is the right file. Its really the most basic accounts module from the module builder.

[davidboris]

Hello,

The zip attached is not working. Please do "Publish" from module builder and attach the fresh zip here.

[climbing-alien]

Hi

Sorry wasnt really sure what file before.

Attached now.

Im looking through the database trying to tie things together to see what the problem could be and it seems the IDs are actually correct.

Im very lost with what could be causing this.

Thanks so much for your help

[davidboris]

Hello,

Oh yes! The issue is with the module name, it is longer than 25 chars(bean_module field in table email_addr_bean_rel). So you need to recreate same module with shorter name.

[climbing-alien]

Hello again.

Thanks so much for your help. I will work on this this evening.

Do you know how I might go about changing the module name without just uninstalling the old one and reinstalling it. I already have data in it tied to other parts of the system and it would be quite a headache to get it all re-done.

Thanks again

[davidboris]

Hello,

Create a file under custom/Extension/application/Ext/TableDictionary/<ANYNAME>.php

Write following line in <ANYNAME>.php

 include("custom/metadata/email_addressesMetaData.php"); 
  

Copy and paste metadata/email_addressesMetaData.php to custom/metadata/email_addressesMetaData.php

And change 'len' => 50, for 'bean_module' and do Quick Repair & Rebuild. This will make the field size bigger.

Now execute an update query for old data to update bean_module value to long name of your module.

 UPDATE email_addr_bean_rel SET bean_module = "<NEW_VALUE>" WHERE bean_module = "<OLD_VALUE>";