CiviCRM Community Forums (archive)

I have created logging tables (in a separate DB) and activated the new logging feature. When I run the summary report, it does list the preview of which contacts where updated and by who, but when I try to open a specific instance to see the detailed report, I get this error:

Contact Logging Report (Detail)
Sorry. A non-recoverable error has occurred.
One of parameters (value: ) is not of the type Integer

Any ideas?

I'm not sure exactly what this is, but I *think* it's caused by code not being backwards compatible with custom fields that were created in an earlier version. There's a code fix below which seems to work for me.

I've tried debugging this, enabling backtraces from administer -> debugging and liberally placing CRM_Core_Error::debug(); anywhere that looks suspect, and the problem for me seems to be in line 227 of /CRM/Logging/Differ.php -                 $params[3] = array($cfDao->option_group_id, 'Integer');
creates an array [null], ['Integer'] because it's running over a custom field group that doesn't have option_group_id in the results returned from the dao.

Here's a reply that seems to work for me. DISCLAIMER: I don't really know what's going on with the code at this point, but the fields that come up for me that lack option_group_id have an id and this seems to work so far:

                if (is_int($cfDao->option_group_id)) {
                  $params[3] = array($cfDao->option_group_id, 'Integer');
                } elseif (is_int($cfDao->id)) {
                  $params[3] = array($cfDao->id, 'Integer');                 
                }

(This is in a fresh 4.0.1 upgrade, no active custom code, with all www. s set to redirect. Reopening old thread because the problem clearly can still exist and there's no solution elsewhere)