Help - Accounts module corrupted on Repair All

[datasponge]

I'm seeing some very strange behavior. I suspect I caused it with Extension customizations, but I'm not successfully tracking it down.

When I go to Admin > Repair > Quick Repair and Rebuild, leave All Modules selected, leave all boxes checked and click Repair, I can no longer access Account Data (see below for symptoms). If I then go to Admin > Repair and click Rebuild Extensions it works fine again. Or if I do a Quick Repair and Rebuild and specifically select only Accounts it's fine again. Throughout, Contacts and Opportunities work with no problems. Also, if I restore the SugarCRM tree from backup it works fine until I Repair All Modules. Data through MySQL is fine throughout.

The specific behaviors after a Rebuild for All Modules are:
- If I click on an Account Last Viewed shortcut or an Account link on the Contacts detail view I get the error:

Error retrieving record. This record may be deleted or you may not be authorized to view it.

- If I click the Accounts tab, the Search panel input box for Name is missing on both Basic and Advanced Search pages even though the label "Name" is displayed.
- The Accounts list shows no data in any columns, but appears to be matching records properly as the number of rows changes for different searches. If I click the pencil in one of the rows, the Edit view shows no data and many fields do not even display the input text box (making me suspect vardefs).

This was working after the last time I added Extensions and I don't see any new Extensions since then, although it is very possible I'm missing something. I made minor changes before the repair, but backing them out did not solve the problem and it occurred even when I restored from a week old backup, so it was something earlier.

Anyone recognize any clues in all that?

Any tips how to systematically track down what broke it?

Thanks

Phil

Version Info:
SugarCRM 5.2.0f
Apache/2.2.6 (Mandriva Linux/PREFORK-8.1mdv2008.0)
PHP Version 5.2.4

[datasponge]

I think I found it.

I had tried some experiments trying to enable auditing for email addresses a while back and had the line below in the file <sugarcrm>/custom/Extension/modules/EmailAddresses/Ext/Vardefs/audit_fields.php

   $dictionary['Account']['fields']['email_address']['audited'] = 'true'; 
  

When I comment out that line, all the errors go away, though I want to do more testing.

Makes sense in hindsight since I'm confusing old email schema with new and trying to set an Account module vardef in the EmailAddresses module. Not too bright.

So beware of serious consequences if you screw up a "simple" vardefs line.

Phil

PS. My "system" was to go to a very old backup that worked and add my custom extensions one at a time, repairing after each module until the Accounts module broke. It broke when I added the EmailAddresses custom extensions, so I had my culprit.