Quick Repair 5.0a fails to Rebuild Audit Table for most modules

[chriswright]

When using the quick repair option with all flags set it should rebuild the audit tables for all modules. This is a clean install hosted with siteground. Freshly installed with no real data. When the repair runs here's the output:

Clearing Vardefs from cache...done
Repair Database
Print Print Help Help
Processing database and vardef comparison...
Database tables are synced with vardefs
Clearing Template files from cache...done
Clearing JS files from cache...done
Clearing Vardefs from cache...done
Clearing JS Language files from cache...done
Clearing Dashlet files from cache...done
Rebuilding Audit Tables...
Relationship not Audit Enabled...
ACLRole not Audit Enabled...
ACLAction not Audit Enabled...
Audit table for Lead already exists. skipping...
Audit table for Contact already exists. skipping...
Audit table for Account already exists. skipping...
Audit table for Opportunity already exists. skipping...
Audit table for Case already exists. skipping...
Note not Audit Enabled...
EmailTemplate not Audit Enabled...
EmailMan not Audit Enabled...
Call not Audit Enabled...
Email not Audit Enabled...
Meeting not Audit Enabled...
iFrame not Audit Enabled...
Task not Audit Enabled...
User not Audit Enabled...
Employee not Audit Enabled...
Currency not Audit Enabled...
tracker not Audit Enabled...
ImportMap not Audit Enabled...
SugarFile not Audit Enabled...
UsersLastImport not Audit Enabled...
Administration not Audit Enabled...
UpgradeHistory not Audit Enabled...
vcal not Audit Enabled...
Audit table for Bug already exists. skipping...
version not Audit Enabled...
Release not Audit Enabled...
Feed not Audit Enabled...
Project not Audit Enabled...
Audit table for ProjectTask already exists. skipping...
Role not Audit Enabled...
EmailMarketing not Audit Enabled...
Audit table for Campaign already exists. skipping...
ProspectList not Audit Enabled...
Prospect not Audit Enabled...
Document not Audit Enabled...
DocumentRevision not Audit Enabled...
FieldsMetaData not Audit Enabled...
schedulers not Audit Enabled...
SchedulersJob not Audit Enabled...
InboundEmail not Audit Enabled...
User not Audit Enabled...
CampaignLog not Audit Enabled...
Dashboard not Audit Enabled...
CampaignTracker not Audit Enabled...
SavedSearch not Audit Enabled...
UserPreference not Audit Enabled...
MergeRecord not Audit Enabled...
EmailAddress not Audit Enabled...
done
Rebuilding Extensions...
Rebuilding Language...en_us
Rebuilding Vardefs...
Rebuilding Layoutdefs...
Rebuilding Menus...
Rebuilding User Page Section...
Rebuilding administration Section...
Rebuilding Relationships
Clearing language files from cache...done

Note: none of the modules are audit enabled? Is this a default and where is the area to set audit enabled for the modules?

[kuske]

That's correct.
Not all modules are audit enabled.
e.g. contacts is, so you can find the enableing statement in modules/contacts/vardef.php:
$dictionary['Contact'] = array('table' => 'contacts', 'audited'=>true, 'unified_search' => true, 'duplicate_merge'=>true, 'fields' =>,,,

In your list the default modules of the following list

Audit table for Lead already exists. skipping...
Audit table for Contact already exists. skipping...
Audit table for Account already exists. skipping...
Audit table for Opportunity already exists. skipping...
Audit table for Case already exists. skipping...
Audit table for Bug already exists. skipping...
Audit table for ProjectTask already exists. skipping...
Audit table for Campaign already exists. skipping...

are audit enabled

[cmacholz]

(I know its an old post ,but)

Whats the upgrade safe way to turn on auditing for NOTES?

Thanks,

p.s. I'm still using 5.2 version of Sugar.

This is my best guess:
C:\sugarcrm-5.2.0j\htdocs\sugarcrm\custom\Extension\modules\No tes\Ext\Vardefs\custom.php

Add these lines????
$dictionary['Notes']['audited'] = true;
$dictionary['Notes']['fields']['description ']['audited'] = true;

[andopes]

The path to save the script is correct, the lines are:

 $dictionary['Note']['audited'] = true;
$dictionary['Note']['fields']['description ']['audited'] = true; 
  

Then go to Admin -> Repair -> Quick Repair and Rebuild

Cheers

[cmacholz]

Thanks Andre,

Quick question....your lines of code worked, but...I've noticed for Meeting and Calls, when I turn on auditing and run the rebuild the _audit table doesn't get created.

If I add the "'audited'=>true, " to the vardefs.php in ,<sugar Root>. the _audit table DOES get created. I don't like editing these files because their not upgrade safe.

Do know what going on here?

//C:\sugarcrm-5.2.0j\htdocs\sugarcrm\custom\Extension\modules\Me etings\Ext\Vardefs
$dictionary['Meeting']['audited'] = true;

//C:\sugarcrm-5.2.0j\htdocs\sugarcrm\custom\Extension\modules\Ca lls\Ext\Vardefs
$dictionary['Call']['audited'] = true;

Thanks, I have a work-a-round, but i'm curious why its not working the way I think it should.